2022大学慕课答案 数据库系统概论(西安电子科技大学) 最新大学MOOC满分章节测试答案
本答案对应课程为:点我自动跳转查看
本课程起止时间为:2020-09-15到2020-12-01
第一章 绪论 第一章测验
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;
并;
合并】
9、 问题:Relational algebra consists of six basic operations: select, ____, union, set difference, cartesian product, and rename.
答案: 【(以下答案任选其一都对)project;
投影】
10、 问题:K is a ____ of R if values for K are sufficient to identify a unique tuple of each possible relation r(R).
答案: 【(以下答案任选其一都对)superkey;
超键;
超码】
11、 问题:In history of data model development, there are four major different data models named as hierarchical data model, network data model, ______data model，and object-oriented data model.
答案: 【(以下答案任选其一都对)relational;
关系;
relation;
关系型】
第三章 SQL 第三章测验
1、 问题:Which phrase can be used to express MIN() in set function:
选项：
A:>= ALL
B:>= ANY
C:<= ALL
D:<= ANY
答案: 【<= ALL】
2、 问题:The SQL command to modify record(s) in a tabled is :
选项：
A:ALTER
B:INSERT
C:UPDATE
D:DELETE
答案: 【UPDATE】
3、 问题:Which phrase can be used to express MAX() in set function:
选项：
A: >= ALL
B:>= ANY
C:<= ALL
D:<= ANY
答案: 【 >= ALL】
4、 问题:To erase a column in a table, we use the command in SQL:
选项：
A:Delete
B:Alter
C:Erase
D:Update
答案: 【Alter】
5、 问题:To give database user ‘Zhang’ the privilege of modifying balance on table account, Which of the following statements is RIGHT:
选项：
A:GRANT UPDATE(balance) ON account TO Zhang ;
B:GRANT UPDATE balance OF account TO Zhang ;
C:REVOKE UPDATE(balance) ON account TO Zhang ;
D:REVOKE UPDATE balance OF account FROM Zhang ;
答案: 【GRANT UPDATE(balance) ON account TO Zhang ;】
6、 问题:Values of attribute Customer_ID in table BORROW(Customer_ID, Loan_no) must be the values of Customer_ID that have already existed in table CUSTOMER(Customer_ID, Customer_Name, Address), this constraint is called :
选项：
A:Entity integrity
B:Referential integrity
本文章不含期末不含主观题！！
本文章不含期末不含主观题！！
支付后可长期查看
有疑问请添加客服QQ 2356025045反馈
如遇卡顿看不了请换个浏览器即可打开
请看清楚了再购买哦，电子资源购买后不支持退款哦
