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

Question

Quizplus · Accepted Answer

A composite key is a combination of two or more fields that are used to uniquely identify a record in a table. This is needed when a single field cannot uniquely identify a record, and multiple fields are required to do so. In contrast, a primary key is a single field used to uniquely identify a record, and a foreign key is used to establish a relationship between two tables. A natural key is a real-world value that is used as a unique identifier, such as a social security number or a phone number, but it may not always be suitable as a primary key in a database.

A ________ Key Is Used When Two Fields Are Needed