When two fields are needed to uniquely identify a record,a ________ key is used.
A) numeric
B) natural
C) composite
D) foreign

Question

Quizplus · Accepted Answer

A composite key is created by combining two or more fields/columns to uniquely identify a record in a table. This is necessary when a single field cannot uniquely identify a record, but the combination of two or more fields can. Therefore, when two fields are needed to uniquely identify a record, a composite key is the appropriate choice. Options A, B, and D do not accurately describe a key that requires two fields to uniquely identify a record.

When Two Fields Are Needed to Uniquely Identify a Record,a