Which of the following would likely be a primary key in a purchases table?
A)Purchase_Order_Date.
B)Purchase_Order_Number.
C)Supplier_Number.
D)Product_Description.

Question

Quizplus · Accepted Answer

A primary key in a purchases table should uniquely identify each purchase. While Purchase_Order_Date and Supplier_Number may occur multiple times in the table, each purchase would have a unique Purchase_Order_Number. Product_Description does not provide enough uniqueness to be a suitable primary key.

Which of the Following Would Likely Be a Primary Key