PHYSICAL DATABASE DESIGN QUIZ

Inconsistent access speed

Extra space

Security

Complexity

False

True

Limit the set of permissible values that a field may assume.

Assume a default value in a field unless a user enters a value for that field.

All of these

Limit the use of null values in some fields.

Moderately fast

Very fast

Impractical

Slow

False

True

True

False

All of these

Maximize storage space

Improve data integrity

Represent most values

True

False

Determines the tablespace required

Primary key

Nonunique key

Useful for denormalization decisions

All fields are stored in four relations.

All fields are stored in two relations.

All fields are stored in one relation.

All fields are stored in three relations.