Which one of the following statements is true about primary keys?
A) A column of names is usually a good choice for use as a primary key.
B) Only a single record can be used as a primary key.
C) Social Security numbers are never used as a primary key.
D) A primary key is used to uniquely identify records in a table.

Question

Quizplus · Accepted Answer

A primary key is used to uniquely identify records in a table. It should be a column or set of columns that contains unique values and is never null. Names are not always unique and should not be used as a primary key. While a single record can be used as a primary key, it is not practical for tables with large numbers of records. Social Security numbers can be used as a primary key, but it is generally not recommended due to privacy concerns and the possibility of duplicates or errors.

Which One of the Following Statements Is True About Primary