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.