期中考试-试题1
需积分: 0 104 浏览量
2022-08-03
15:36:00
上传
评论
收藏 490KB PDF 举报
Page 1
2018 级数据库期中试卷
课程名称： 数据库系统及其应用(Database Systems and Applications)
学生姓名：___________________ 学 号：___________________
专 业：___________________ 年级/班级：__________________
课程性质：专业必修
I
II
III
IV
V
VI
总分
阅卷人签名
请在自己的答题纸上抄写以下内容并签名之后开始答题。
本次考试是本人独立完成，保证没有在考试时间范围内就相关内容与任何人进
行交流。
本人签字：
Part I. (30 Points ,2 points for each problem)
1. Database system can solve the data redundancy and inconsistency
problems with file-processing systems. ( )
(A) True (B) False
2. A foreign key is a referential constraint between two tables. ( )
(A) True (B) False
3. When a client requests a record that contains a BLOB (binary large object),
the database server that receives the request should return the entire
record at a time. ( )
(A) True (B) False
4. SQL allows you to not only create a new table, but also to delete an
existing table from the database. ( )
(A) True (B) False
5. The relation R(A,B,C,D) consists of ONLY the tuples that are listed and NO
other tuples. The functional dependency C
→
B is not satisfied. ( )
A
B
C
D
3
2
1
3
1
2
1
5
2
3
6
8
2
3
2
1
(A) True (B) False
6. Given the two tables: Staff(id, name, deptno, job, salary) and Org(deptno,
deptname, location).The statement “Update Staff set salary=salary*1.1
where deptno in (select deptno from org where location=’Shanghai’)” will
give all staffs in Shanghai a 10 percent salary raise. ( )
(A) True (B) False
7. Which statement is true? ( )
(A) Physical level of data abstraction describes what data are stored in the
评论0