PHYSICAL DATABASE DESIGN QUIZ

RAID-2

RAID-3

RAID-0

RAID-1

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

Indexes are more useful on smaller tables.

Be careful indexing attributes that have null values.

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

False

True

All fields are stored in three relations.

All fields are stored in two relations.

All fields are stored in one relation.

All fields are stored in four relations.

Moderately fast

Slow

Very fast

Impractical

False

True

Query one query within another.

Use compatible data types.

Write complex queries.

Combine a table with itself.

False

True

All of these

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

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

Limit the use of null values in some fields.

True

False