In the following table description,____ is the primary key.
PRODUCT (PROD_CODE,PROD_DESCRIPT,PROD_PRICE,PROD_ON_HAND,VEND_CODE)
A) PROD_DESCRIPT
B) PROD_CODE
C) PROD_PRICE
D) PROD_ON_HAND

Question

Quizplus · Accepted Answer

The primary key is a unique identifier for each record in a table. In the given table description, PROD_CODE is the most appropriate choice as a primary key because it uniquely identifies each product, whereas PROD_DESCRIPT and PROD_PRICE can have duplicates. PROD_ON_HAND may change frequently, so it is not an ideal choice as the primary key. VEND_CODE is not a good choice as the primary key because multiple vendors can supply the same product.

In the Following Table Description,____ Is the Primary Key