Multiple Choice
The common advantage of separating portions of a table's data using either horizontal or vertical partitioning is that ____.
A) performance will be improved when indexes are in use
B) performance will be improved when the entire table must be retrieved
C) the data in a partition can be stored in a concentrated space on the disk, which will speed up its retrieval
D) All of the above.
E) None of the above.
Correct Answer:

Verified
Correct Answer:
Verified
Q29: In a hashed file, a collision occurs
Q30: A view is an important device in
Q31: The three ways of achieving direct access
Q32: The storing derived data physical database design
Q33: In vertical partitioning, the rows of a
Q35: The frequency with which stored data is
Q36: In a hashed file, synonym pointer chains
Q37: <span class="ql-formula" data-value="\begin{array}{lllll}\begin{array}{lll}\text { Course } \quad\quad
Q38: The way that data is stored for
Q39: All of the following are true about