When implementing the physical-level design,for secondary keys,you must ensure that it is possible to retrieve data rapidly on the basis of a value of the ____ key.
A) primary
B) secondary
C) alternate
D) foreign

Question

When implementing the physical-level design,for secondary keys,you must ensure that it is possible to retrieve data rapidly on the basis of a value of the ____ key.​
A) ​primary
B) ​secondary
C) ​alternate
D) ​foreign

Quizplus · Accepted Answer

The question specifically mentions secondary keys, implying that primary keys have already been established. Therefore, the option for primary key can be eliminated. Alternate and foreign keys are not relevant to the question. Secondary keys are meant to improve retrieval speed based on specific values, so ensuring efficient retrieval on the basis of a secondary key is crucial in the physical-level design.

When Implementing the Physical-Level Design,for Secondary Keys,you Must Ensure That