Purpose of 'Foreign Key' in a table is to ensure

2009

Answer: B. Referential Integrity — A Foreign Key constraint ensures referential integrity. It maintains consistency by ensuring that values in a column match existing values in another table's…

A.
Null Integrity
B.
Referential Integrity
C.
Domain Integrity
D.
Null and Domain Integrity

Attempted by 2074 students.

Show answer & explanation

Correct answer: B

A Foreign Key constraint ensures referential integrity. It maintains consistency by ensuring that values in a column match existing values in another table's primary key.

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Iocl Engineers Officers Grade A Paper 2