Physical Database Design – True or False

6. When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.

A. True
B. False

Correct Answer:  A. True
Advertisement

7. A field represents each component of a composite attribute.

A. True
B. False

Correct Answer:  A. True
Advertisement

8. Some advantages of partitioning include: efficiency, security, and load balancing.

A. True
B. False

Correct Answer:  A. True
Advertisement

9. A pointer is a detailed coding scheme recognized by system software for representing organizational data.

A. True
B. False

Correct Answer:  B. False
Advertisement

10. Distributing the columns of a table into several separate physical records is known as horizontal partitioning.

A. True
B. False

Correct Answer:  B. False
Advertisement

Leave A Comment?