Which key is used to create a link and relationship between tables in a relational database?

The correct answer is C. Foreign Key. A foreign key is a column or a set of columns in one table that references the primary key of another table. It is used to create a link and relationship between tables in a relational database. A foreign key ensures that the values in the referencing table match the values in…

IT Operations and Infrastructure Management

Question

Options

APrimary Key
BSecondary Key
CForeign Key

How the community answered

(27 responses)

A
7% (2)
B
4% (1)
C
89% (24)

Explanation

A foreign key is a column or a set of columns in one table that references the primary key of another table. It is used to create a link and relationship between tables in a relational database. A foreign key ensures that the values in the referencing table match the values in the referenced table, thus maintaining the referential integrity of the database. A foreign key can also be used to implement constraints such as cascading updates or deletes.

Topics

#foreign key#relational database#table relationships

Community Discussion

No community discussion yet for this question.

Full CITM-001 Practice