PHYSICAL DATABASE DESIGN QUIZ

False

True

False

True

the number of physical records per page.

attributes grouped together by the same secondary key.

attributes grouped together by the same primary key.

a group of fields stored in adjacent memory.

True

False

Inconsistent access speed

Extra space

Security

Complexity

Maximize storage space

Improve data integrity

Represent most values

All of these

True

False

Impractical

Slow

Moderately fast

Very fast

All fields are stored in two relations.

All fields are stored in one relation.

All fields are stored in three relations.

All fields are stored in four relations.

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

Limit the use of null values in some fields.

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

All of these