Which of the following is most likely to be a primary key in an "employee" table?
A)Last name
B)Employee ID number
C)Both A and B together
D)Either A or B separately

Question

Quizplus · Accepted Answer

An employee ID number is the most appropriate choice for a primary key as it is a unique identifier for each employee and can be used to ensure that each row in the table is distinct. Last name is not necessarily unique and could lead to errors or ambiguity if used as a primary key by itself. Using both together as a composite key is an option, but in many cases, relying on a single identifier as the primary key is preferable.

Which of the Following Is Most Likely to Be a Primary