Which of the following is not true for an ideal primary key?
A)a composite of several long attributes
B)numeric
C)fixed
D)short

Question

Quizplus · Accepted Answer

An ideal primary key should be simple, unique, and stable. A composite key composed of several long attributes may not be easy to manage or maintain, and it may also not be unique in the case of duplicates. Therefore, A is not a true statement for an ideal primary key. The ideal primary key should be short, fixed, and preferably numeric if possible.

Which of the Following Is Not True for an Ideal