PHYSICAL DATABASE DESIGN QUIZ

Improve data integrity

All of these

Maximize storage space

Represent most values

All of these

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

Limit the use of null values in some fields.

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

All fields are stored in one relation.

All fields are stored in four relations.

All fields are stored in two relations.

All fields are stored in three relations.

attributes grouped together by the same primary key.

attributes grouped together by the same secondary key.

the number of physical records per page.

a group of fields stored in adjacent memory.

False

True

All fields are stored in three relations.

All fields are stored in four relations.

All fields are stored in two relations.

All fields are stored in one relation.

RAID-0

RAID-2

RAID-1

RAID-3

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

Block contention

The length of all of the fields in a table row

Random row access speed

The number of columns