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 others are referred to as ____.
A) canceled keys
B) alternate keys
C) nonkey attributes
D) contributory keys

Question

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 others are referred to as ____.​
A) ​canceled keys
B) ​alternate keys
C) ​nonkey attributes
D) ​contributory keys

Quizplus · Accepted Answer

When there are multiple possible choices for the primary key, the others are referred to as alternate keys. These alternate keys can still uniquely identify a row in the table, but they are not chosen as the primary key. Other options such as canceled keys, nonkey attributes, and contributory keys are not correct terms for this scenario.

If There Is More Than One Possible Choice for the Primary