Question

Two fields needed to uniquely identify a record are called a ________ key?

1) composite
2) natural primary
3) foreign
4) primary

Answer 1

The term for two fields needed to uniquely identify a record is a composite key. This differs from a natural primary key, primary key, or foreign key, as a composite key involves multiple attributes.

Step-by-step explanation:

Two fields needed to uniquely identify a record are called a composite key. A composite key is made up of two or more attributes (fields) that collectively ensure uniqueness of the record in a database table. This is different from a natural primary key, which is a single attribute that uniquely identifies a record, or a primary key, which may be either a single field or a composite key. A foreign key, on the other hand, is a field in one table that links to the primary key in another table.