PrepAway - Latest Free Exam Questions & Answers

Which of the following ensures referential integrity between tables?

Which of the following ensures referential integrity between tables?

PrepAway - Latest Free Exam Questions & Answers

A.
Foreign key

B.
CHECK constraint

C.
Index

D.
Primary key

Explanation:
The foreign key ensures referential integrity between tables. A foreign key is a column or combinationof
columns used to establish and enforce a relationship between the data in two tables. This relationshipis
created by adding a column(s) in one of the tables to refer to the other table’s column(s) protected by a
PRIMARY KEY or UNIQUE constraint. This column becomes a foreign key in the first table. A foreign key can
be created by defining a FOREIGN KEY constraint when creating or altering a table.


Leave a Reply