大学MOOC 数据库原理（郭云飞）(湘潭大学)1450816237 最新慕课完整章节测试答案

第1次测试

1、判断题：
‏数据库原理是我的专业课，非常重要，以后靠它吃饭，我一定要学好‍
选项：
A: 正确
B: 错误
答案: 【 正确】

第一章测验

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 】

兴湘签到2

1、判断题：
‍学校规定：本学期不能提前返校。‏
选项：
A: 正确
B: 错误
答案: 【 正确】

兴湘签到3

1、判断题：
‏In the relational model the term relation is used to refer to a table, while
the term tuple is used to refer to a row. Similarly, the term attribute refers to acolumn of a table.‎‏(在关系模型中，术语关系用来指代表，元组用来指代行。类似的，术语属性用来指代表中的列)‎
选项：
A: 正确
B: 错误
答案: 【 正确】

第二章测验

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, __________, union, set difference, cartesian product, and rename.​
答案: 【 project##%_YZPRLFH_%##投影】

10、填空题：
‍K is a __________ of R if values for K are sufficient to identify a unique tuple of each possible relation r(R).‌
答案: 【 superkey##%_YZPRLFH_%##超键##%_YZPRLFH_%##超码】

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##%_YZPRLFH_%##关系##%_YZPRLFH_%##relation##%_YZPRLFH_%##关系型】

软件签到2

1、判断题：
‎数据库原理课程非常重要，以后靠它吃饭，我一定要学好​
选项：
A: 正确
B: 错误
答案: 【 正确】

软件签到3

1、判断题：
​In the relational model the term relation is used to refer to a table, while
the term tuple is used to refer to a row. Similarly, the term attribute refers to acolumn of a table.‏
选项：
A: 正确
B: 错误
答案: 【 正确】

随堂测

1、填空题：
‌关系代数有几种基本操作？‍
答案: 【 6】

兴湘签到4

1、判断题：
‍按照教学安排，今天还是学习第二章的内容​
选项：
A: 正确
B: 错误
答案: 【 错误】

兴湘签到5

1、判断题：
‎下面的SQL语句正确吗？‎creat table account‎   (account_number  char(15) primary key,‎    branch_name varchar(15) ‎    balance  number  not null,‎    );‎‎‏‎
选项：
A: 正确
B: 错误
答案: 【 错误】

兴湘签到6

1、判断题：
‍​‍查询：对于大学中所有讲授过课程的教师，找出他们的姓名及其所讲授课程的ID。​‍该查询可以写成：​‍select name, course id​‍from instructor natural join teaches;​‍​
选项：
A: 正确
B: 错误
答案: 【 正确】

兴湘签到7

1、判断题：
‏‎‏Einstein在哪栋楼办公？查询如下：‎‏select department.building‎‏from department,instructor‎‏where instructor.name = 'Einstein';‎‏‎
选项：
A: 正确
B: 错误
答案: 【 错误】

兴湘签到8

1、判断题：
‎将各个系教师的平均工资定义为视图average_salary.‎create view average_salary as‎select dept_name,max(salary)‎from instructor;‎group by dept_name;‎‌‎
选项：
A: 正确
B: 错误
答案: 【 错误】

新兴湘签到8

1、判断题：
​‍​计算学生的平均成绩，将该查询定义为视图 average_grade‍​假设grade是int型的。‍​create view average_grade as‍​select id,name,avg(grade)‍​from student natural join takes‍​group by id‍​‍
选项：
A: 正确
B: 错误
答案: 【 错误】

新软件签到8

1、判断题：
​‏​计算学生的平均成绩，将该查询定义为视图