数据库系统试卷及答案

Principles of Database Systems(A)(final test)

— 0201~0203-Computer Science & Technology

Name________________ ID____________________

I.Multiple Choice( 2 points * 20)

1.Which is NOT a component of a relational database?

a)Entity

b)Table

c)Attribute

d)Hierarchy

2.Which is NOT an advantage of the database approach?

a)Limited data sharing

b)Minimal data redundancy

c)Improved data quality

d)Reduced program maintenance

3.A formal, top-down methodology that uses a data orientation to create and maintain

information systems.

a)Enterprise data modeling

b)Information engineering

c)Information system architecture

d)Strategic planning factors

4.In this step of the SDLC, one writes, tests, and installs the programs that process the database.

a)Database implementation

b)Physical database design and definition

c)Database maintenance

d)Logical database design

5.Which is NOT an example of a strong entity type?

a)STUDENT

b)COURSE

c)DEPARTMENT

d)STUDENT_ID

6.A property or characteristic of an entity type is a(n)

a)attribute.

b)relationship.

c)field.

d)trait.

7.An attribute whose value can be calculated from related attribute values is a(n) ___ attribute.

a)composite

b)multivalued

c)stored

d)derived

8.The most common type of relationship encountered in data modeling is the ____ relationship.

a)unary

b)binary

c)ternary

d)associative

9.The process of defining a more basic entity type from a set of specialized entity types is

called

a)generalization.

b)specialization.

c)inheritance.

d)subtype hierarchy.

10.The ____ specifies that an entity instance can simultaneously be a member of two or more

subtypes.

a)disjoint rule

b)disjoint constraint

c)completeness constraint

d)overlap rule

11.In ____ normal form, any transitive dependencies have been removed.

a)first

b)second

c)third

d)fourth

12.The ____ guarantees that every primary key attribute is not null.

a)entity integrity rule

b)referential integrity constraint

c)action assertion

d)composite attribute

13.A(n) ____ is a constraint between two attributes.

a)determinant

b)action assertion

c)candidate

d)functional dependency

14.Data integrity controls may include

a)default values, null value control, and denormalization.

b)default values, hashing, and referential integrity.

c)range control, hashing, and denormalization.

d)range control, referential integrity, and default value.

15.A ____ is a routine that converts a primary key value into a relative record number.

a)hashing algorithm

b)hash index table

c)join index

d)hierarchical index