四川大学数据库系统期末试题2014-2015.doc
课程名称:数据库系统 任课教师 张天庆、龚勋、李川、屈立笳 学号: 姓名:
本题 NUMPAGES 3页,本页为第 PAGE 2页
教务处试题编号:
注:试题字迹务必清晰,书写工整。 本题 NUMPAGES 3页,本页为第 PAGE 1页
教务处试题编号:
四川大学期末考试试题(闭卷)
(2014-2015学年第1学期)
Multiple Choices (20 marks, 2 marks for each)
1)、The following are functions of a DBMS except ( )
HYPERLINK "javascript:%20void%200;" A.
creating and processing forms
HYPERLINK "javascript:%20void%200;" B.
creating databases
HYPERLINK "javascript:%20void%200;" C.
processing data
HYPERLINK "javascript:%20void%200;" D.
administrating databases
2)、In a one-to-many relationship, the entity that is on the one side of the relationship is called a( )entity.
HYPERLINK "javascript:%20void%200;" A.
parent
HYPERLINK "javascript:%20void%200;" B.
child
HYPERLINK "javascript:%20void%200;" C.
instance
D.
subtype
3)、When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a( ):
HYPERLINK "javascript:%20void%200;" A.
transitive dependency.
HYPERLINK "javascript:%20void%200;" B.
insertion anomaly.
HYPERLINK "javascript:%20void%200;" C.
referential integrity constraint.
HYPERLINK "javascript:%20void%200;" D.
normal form.
4))?
A tuple is a( ):
HYPERLINK "javascript:%20void%200;" A.
column of a table.
HYPERLINK "javascript:%20void%200;" B.
two dimensional table.
HYPERLINK "javascript:%20void%200;" C.
row of a table.
HYPERLINK "javascript:%20void%200;" D.
key of a table.
8.?
5)、In which of the following is a single-entity instance of one type related to many entity instances of another type?()( )
HYPERLINK "javascript:%20void%200;" A.
One-to-One Relationship
HYPERLINK "javascript:%20void%200;" B.
One-to-Many Relationship
HYPERLINK "javascript:%20void%200;" C.
Many-to-Many Relationship
HYPERLINK "javascript:%20void%200;" D.
Composite Relationship
15.?
6)、Which of the following i