Which integrity rule ensures that a foreign key value matches an existing referenced key value or is NULL when permitted?
Options
-
A.
Entity integrity
-
B.
Referential integrity
-
C.
Domain integrity
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
B.
Referential integrity
Detailed Explanation
- Referential integrity: Ensures that foreign key references remain valid.
- A foreign key value must match an existing referenced key value, or be NULL if the column permits NULL.
- It prevents invalid relationships between database tables.
OOps! You are currently offline.