Machine-translated by Google. Questions are authored in English.
Top

Physical Database Design Questions and Answers

31.

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

Answer: A

Correct answer: True

Physical design begins from a logical design that is already correct, so what remains to be decided is how to make it perform: indexes, file organisation, clustering, partitioning and controlled denormalisation. Correctness is settled by then; efficiency is what physical design trades against.

Please log in or register to report this question.

32.

An extent is a contiguous section of disk storage space.

Answer: A

Correct answer: True

An extent is a contiguous run of disk space allocated to a segment in one go. Allocating in extents rather than block by block keeps related data physically together, which matters for sequential reading, and reduces the bookkeeping the storage manager must do.

Please log in or register to report this question.

Loading…
Tags: Physical Database Design Questions and Answers || Physical Database Design MCQ Questions and Answers || Physical Database Design GK Questions and Answers || Physical Database Design GK MCQ Questions || Physical Database Design Multiple Choice Questions and Answers || Physical Database Design GK || GK on Physical Database Design || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database