Physical Database Design – True or False

1. Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.

A. True
B. False

Correct Answer:  A. True
Advertisement

2. Denormalization and clustering can work well to minimize data access time for small records.

A. True
B. False

Correct Answer:  A. True
Advertisement

3. Hashing algorithm converts a primary key value into a record address.

A. True
B. False

Correct Answer:  A. True
Advertisement

4. The primary goal of physical database design is data processing efficiency.

A. True
B. False

Correct Answer:  A. True
Advertisement

5. A bitmap index is an index on columns from two or more tables that come from the same domain of values.

A. True
B. False

Correct Answer:  B. False
Advertisement

Leave A Comment?