A key consisting of one or more columns that is a primary key in another relation is a ________.
A)composite key
B)candidate key
C)foreign key
D)surrogate key

Question

Quizplus · Accepted Answer

A foreign key is a key that is a primary key in another relation, used to establish a relationship between two tables. A composite key is a combination of two or more columns that uniquely identifies a record in a table. A candidate key is a column or set of columns that can uniquely identify a record in a table. A surrogate key is a unique identifier assigned to each record in a table.

A Key Consisting of One or More Columns That Is