The creating a new primary key physical database design technique is designed to ____.
A) reduce the number of joins
B) reduce the number of indexes
C) replace clumsy keys that have a large number of attributes
D) All of the above.
E) None of the above.

Question

Quizplus · Accepted Answer

The creating a new primary key physical database design technique is designed to replace clumsy keys that have a large number of attributes, which can improve performance and simplify the design. It is not directly related to reducing the number of joins or indexes, although these may be indirectly affected by the new primary key. So, option C is the best choice.

The Creating a New Primary Key Physical Database Design Technique