大学MOOC 数据库系统概论(西安电子科技大学)1002199005 最新慕课完整章节测试答案

第一章测验

1、单选题：
‌The relational data model is proposed by :‌
选项：
A: C. W. Bachman
B:  R. Boyce
C: E. F. Codd
D: J. Gray
答案: 【 E. F. Codd】

2、单选题：
​Which of the following Software is NOT DBMS :​
选项：
A: SQL Server   
B: Oracle
C: Android
D: MySQL
答案: 【 Android】

3、单选题：
​There are two different standard terminologies (术语). A column in a table is called a(an) [     ] in a relation：‌
选项：
A: tuple
B: attribute
C: domain
D: degree
答案: 【 attribute】

4、单选题：
​Which of the following database object is used to speed up access to desired data ?‍
选项：
A: Table
B: Index 
C: View
D: Log
答案: 【 Index 】

第二章测验

1、单选题：
‏In the relational database, data are stored in：‏
选项：
A: Table
B: Index
C: View
D: Transaction
答案: 【 Table】

2、单选题：
‌Natural join is an additional operation in relational algebra, it can be replaced by which set of the following operations equivalently :‍
选项：
A: Select, Project
B: Cartesian-Product, Project
C: Cartesian-Product, Select, Project
D: Cartesian-Product, Select
答案: 【 Cartesian-Product, Select, Project】

3、单选题：
‎Division is an additional operation in relational algebra, it can be replaced by which set of the following operations equivalently :‌
选项：
A: Select, Project, Cartesian-Product
B: Union, Project, Cartesian-Product
C: Select, Rename, Cartesian-Product
D: Set difference, Project, Cartesian-Product
答案: 【 Set difference, Project, Cartesian-Product】

4、单选题：
‌Which of the following is WRONG in the relation rules?‏
选项：
A: There is no order on the rows.
B: There is no order on the columns.
C: Two tuples can be identical in all column values.
D: Multi-valued attributes are not permitted.
答案: 【 Two tuples can be identical in all column values.】

5、单选题：
‎The constraint “In a base relation, NO attribute of a primary key can be null”, is called :‎
选项：
A: Entity integrity
B: Referential integrity
C: Check constraint      
D: User defined constraint
答案: 【 Entity integrity】

6、单选题：
‌A 　 　 contains a collection of interrelated data, a set of programs to access the data and an environment that is both convenient and efficient to use.‏
选项：
A:  DBMS
B: Database
C: Database application
D: Data Schema
答案: 【  DBMS】

7、单选题：
‎Let R = ( A, B, C, D ), S = ( B, D ), the schema of relation ( R ÷ S )  is :‌
选项：
A: ( A, B )
B: ( A, C )  
C: ( B, D )
D: ( B, C)
答案: 【 ( A, C )  】

8、填空题：
‍Relational algebra consists of six basic operations: select, project, __________, set difference, cartesian product, and rename.‎
答案: 【 union##%_YZPRLFH_%##并##%_YZPRLFH_%##合并】

9、填空题：
‎Relational algebra consists of six basic operations: select, __________,