PHYSICAL DATABASE DESIGN QUIZ

All fields are stored in four relations.

All fields are stored in two relations.

All fields are stored in one relation.

All fields are stored in three relations.

All of these

Improve data integrity

Maximize storage space

Represent most values

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

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.

True

False

The number of columns

Random row access speed

Block contention

The length of all of the fields in a table row

Relational

Network

Hierarchical

Data warehouse

True

False

VARCHAR2

NUMBER

CHAR

LONG

True

False

True

False