135k views
4 votes
Two fields needed to uniquely identify a record are called a ________ key.

A) composite
B) natural primary
C) foreign
D) primary

User Pot
by
7.7k points

1 Answer

1 vote

Final answer:

Two fields needed to uniquely identify a record together are called a composite key, which is used when a single field is not enough to uniquely identify a record.

Step-by-step explanation:

Two fields needed to uniquely identify a record are called a composite key. A composite key is formed by combining two or more columns in a table to create a unique key for each record. It is different from a primary key, which is a single column that uniquely identifies each record. A foreign key, on the other hand, is a field (or collection of fields) in one table that uniquely identifies a row of another table. A natural primary key is naturally occurring and is not a combination of multiple fields.

User Andrea Mannari
by
8.2k points