2020年11月数据库系统工程师考试上午真题【基础知识】-软考吧-您身边的软考专家-www.ruankaoba.com

2020年11月数据库系统工程师考试上午真题【基础知识】

内容：基础知识
时间：150分钟
总分：75分
题数：75题

【66】在数据库系统中，使数据恢复到故障发生前的一致状态的机制称为（66）。

真题详情及解析

【67】通过将一个关系拆分成两个更小的关系来使其满足范式时，必须（67）来保持数据的完整性约束。

真题详情及解析

【68】下列描述中，（68）不是分布式数据库数据透明性的表现形式。

真题详情及解析

【69】分布式数据库的CAP理论指的是：对于一个分布式数据库系统，一致性、可用性和分区容错性这三个特点，最多只能满足（69）个。

真题详情及解析

【70】NOSQL数据库的四大分类是指（70）。

真题详情及解析

【71-75】A database system is a ollction of itererelated data and a set of programs that allow users to access and modify these data. A major purpose of a database system is to provide users with an（71）view of the data. That is, the system hides certain details of how the data are stored and maintained. For the system to be usable, it must retrieve data（72）。 The need for efficiency has led designers to use complex data（73）to represent data in the database. Since many database-system users are not computer trained, developers hide the complexity from users through several levels of abstraction, to simplify users' interactions with the system. Physical level is the lowest level of abstraction that describes（74）the data are actually stored. Logical level is the next-higher level of abstraction that describes（75）data are stored in the database, and what relationships exist among those data. View level is the highest level of abstraction that describes only part of the entire database.

真题详情及解析