In the record format STORE (STORE_NO,CITY,VEND#1,VEND#2)
Which field is the key?
A) STORE
B) STORE_NO
C) VEND
D) CITY

Question

Quizplus · Accepted Answer

The field STORE_NO is the most likely candidate for the key field, as it is specifically named and presumably unique for each store. The field CITY is not necessarily unique, and the fields VEND#1 and VEND#2 are likely to contain multiple values for each record. The field VEND is not clearly defined in the format.

In the Record Format STORE (STORE_NO,CITY,VEND#1,VEND#2)