注:
试题字迹务必清晰,书写工整?/p>
本题
4
页,本页为第
1
?/p>
教务处试题编号:
四川大学期末考试试题(闭卷)
?/p>
2007-2008
学年?/p>
2
学期?/p>
课程号:
31113740
课序号:
课程名称
数据库系统原理(
A
?/p>
?/p>
任课教师?/p>
适用专业年级?/p>
软件工程
2006
?/p>
学生人数?/p>
340
印题份数?/p>
350
学号?/p>
姓名?/p>
考试须知
四川大学学生参加由学
校组织或由学?/p>
承办的各级各?/p>
考试?/p>
必须严格?/p>
?/p>
《四川大学考试
工作管理办法?/p>
?/p>
?/p>
四川大学考场?/p>
则?/p>
?/p>
有考试违纪作弊行为?/p>
,一律按照《四
川大学学生考试
违纪作弊处罚?/p>
例》进行处理?/p>
四川大学各级各类考试
的监考人员,
必须严格执行
《四川大学考试
工作管理办法
?/p>
?/p>
《四川大学?/p>
场规则》和?/p>
四川大学监考人
员职
责?/p>
。有违反?/p>
校有关规定的?/p>
严格按照《四?/p>
大学教学事故?/p>
定及处理办法?/p>
进行处理?/p>
?/p>
?/p>
一
?/p>
?/p>
?/p>
?/p>
?/p>
?/p>
?/p>
?/p>
?/p>
?/p>
?/p>
阅卷教师
阅卷时间
?/p>
?/p>
?/p>
100
期末卷面
50 %
半期测验
10 %
平时练习
10 %
项目练习
30 %
1.
Multiple Choices. (2points
×
10)
(1)
If relation R has n tuples and relation S has m tuples, the maximum number of tupes that R
─
S can contain i
s _____.
A. n
B. m
C. n+m
D. |n-m|
(2)
Whi
ch of the followi
ng statements are true.
I. 4NF implies BCNF
II. BCNF implies 3NF
.
III. 3NF implies BCNF
A. None
B. I only
C. I and II
D. I and III
(3)
The FD
X -> Y
i
s a full dependency in a relation R, i
f there is _____ attribute
A
that can be _____
X
and the
dependency still holds.
A. at least one, added to
B. at l
east one, removed from
C. no, added to
C. removed from
(4)
An excl
usive l
ock on a data i
tem represents permi
ssi
on to perform whi
ch of the operations, read and wri
te, on the
data item?
A. Both read and write.
B. Wri
te onl
y
.
C. Read only
.
D. Nei
ther read nor wri
te.
(5)
For two tables to be uni
on compatible, corresponding col
umns from each table should have whi
ch of the followi
ng?
A.
different domai
ns
B.
different names
C.
the same domai
n
D.
the same name