Which integrity constraint ensures that a value appearing in one table must…
2023
Which integrity constraint ensures that a value appearing in one table must also appear in another related table?
- A.
Functional Dependency
- B.
Referential Integrity
- C.
Assertion
- D.
Domain Constraint
Attempted by 186 students.
Show answer & explanation
Correct answer: B
The correct option is B. Referential Integrity ensures relationships between tables remain consistent. It uses a foreign key in one table to reference a primary key in another. This constraint mandates that any value in the foreign key column must match an existing value in the referenced table's primary key column or be NULL.