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?
Answer: B. Referential Integrity — The correct option is B. Referential Integrity ensures relationships between tables remain consistent. It uses a foreign key in one table to reference a…
- A.
Functional Dependency
- B.
Referential Integrity
- C.
Assertion
- D.
Domain Constraint
Attempted by 481 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.
Loading lesson…