摘要：对于【数据库系统工程师】软考考试而言，试题无疑是最重要的学习资料之一。在软考备考过程中，吃透试题、掌握试题所考知识点、熟悉试题的出题思路，对我们提升分数的效果是最明显的，通过对试题的反复练习，还可以查漏补缺。今天，给大家带来【2020年11月数据库系统工程师上午题】部分试题的详解，一起来看看吧~



1、NOSQL 数据库的四大分类是指(       )
A、 键值存储数据库，列存储数据库，文档型数据库，关系型数据库
B、 列存储数据库，文档型数据库，关系型数据库，分布式数据库
C、 键值存储数据库，列存储数据库，文档型数据库，图数据库
D、 列存储数据库，文档型数据库，关系型数据库，图数据库

答案:C
答题解析:

本题考查数据库新技术相关问题。

NoSQL是指非关系型数据库，是对不同于传统的关系型数据库DBMS的统称。有几种典型的NoSQL数据库。

文档存储数据库是以文档为存储信息的基本单位，如BaseX，CouchDB，MongoDB等。

键值存储数据库支持简单的键值存储和提取，具有极高的并发读写性能，如Dynamo，Memcached，Redis等。

图形存储数据库利用计算机将点、线、面等图形基本元素按照一定的数据结构进行存储，如FlockDB、Neo4j等。

列存储按列存储每个字段的数据聚集存储，在查询只需要少数几个字段的时候，能大大减少读取的数据量，一个字段的数据聚集存储，那就更容易为这种聚集存储设计更好的压缩/解压算法。

2、A database system is a collection of interrelated data and a set of programs that allowusers to access and modify these data. A major purpose of a database system is to provide userswith an (71) view of the data. That is, the system hides certain details of how the data arestored and maintained. For the system to be usable, it must retrieve data(72) . The need forefficiency 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 complexityfrom 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 highestlevel of abstraction that describes only part of the entire database.
A、abstract
B、physical
C、administrator
D、operator

答案:A
答题解析:略

3、A database system is a collection of interrelated data and a set of programs that allowusers to access and modify these data. A major purpose of a database system is to provide userswith an (71) view of the data. That is, the system hides certain details of how the data arestored and maintained. For the system to be usable, it must retrieve data(72) . The need forefficiency 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 complexityfrom 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 highestlevel of abstraction that describes only part of the entire database.
A、completely
B、safely
C、usefully
D、fficiently

答案:D
答题解析:略

查看完整试题>>>