If there is more than one possible choice for the primary key,and one of the possibilities is chosen to be the primary key,the other choices are referred to as ____.
A)surrogate keys
B)alternate keys
C)intelligent keys
D)contributory keys

Question

Quizplus · Accepted Answer

The other choices are referred to as alternate keys when a primary key has more than one possible choice. Surrogate keys are artificially generated keys, intelligent keys are keys that are based on business logic or attributes, and contributory keys are not a widely recognized term in the context of database design. Therefore, the best choice is B (alternate keys).

If There Is More Than One Possible Choice for the Primary