PHYSICAL DATABASE DESIGN QUIZ

Limit the use of null values in some fields.

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

All of these

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

True

False

Do not specify a unique index for the primary key of each table.

Be careful indexing attributes that have null values.

Indexes are more useful on smaller tables.

Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.

True

False

False

True

Slow

Very fast

Moderately fast

Impractical

True

False

False

True

False

True

attributes grouped together by the same secondary key.

attributes grouped together by the same primary key.

a group of fields stored in adjacent memory.

the number of physical records per page.