PHYSICAL DATABASE DESIGN QUIZ

True

False

Use compatible data types.

Query one query within another.

Write complex queries.

Combine a table with itself.

Be careful indexing attributes that have null values.

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

Indexes are more useful on smaller tables.

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

False

True

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

Limit the use of null values in some fields.

All of these

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

True

False

True

False

Inconsistent access speed

Extra space

Complexity

Security

All fields are stored in two relations.

All fields are stored in four relations.

All fields are stored in three relations.

All fields are stored in one relation.

attributes grouped together by the same primary key.

the number of physical records per page.

a group of fields stored in adjacent memory.

attributes grouped together by the same secondary key.