PHYSICAL DATABASE DESIGN QUIZ

False

True

Use compatible data types.

Write complex queries.

Combine a table with itself.

Query one query within another.

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

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.

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

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

Indexes are more useful on smaller tables.

Be careful indexing attributes that have null values.

False

True

Useful for denormalization decisions

Nonunique key

Primary key

Determines the tablespace required

True

False

The length of all of the fields in a table row

Random row access speed

Block contention

The number of columns

Security

Inconsistent access speed

Extra space

Complexity

Represent most values

Maximize storage space

All of these

Improve data integrity