大学mysql期末试题_四川大学数据库系统期末试题2014-2015.doc

四川大学数据库系统期末试题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