PHYSICAL DATABASE DESIGN QUIZ

True

False

Maximize storage space

Improve data integrity

Represent most values

All of these

False

True

True

False

attributes grouped together by the same primary key.

the number of physical records per page.

attributes grouped together by the same secondary key.

a group of fields stored in adjacent memory.

Write complex queries.

Use compatible data types.

Query one query within another.

Combine a table with itself.

Data warehouse

Hierarchical

Relational

Network

All of these

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.

False

True

True

False