Which of the following is true about “referential integrity” ?
2025
Which of the following is true about “referential integrity” ?
- A.
It ensures that foreign keys are valid and correspond to primary keys.
- B.
It prevents the insertion of null values in a table.
- C.
It allows duplicate entries in a table.
- D.
It is unrelated to the relational database model.
Attempted by 134 students.
Show answer & explanation
Correct answer: A
Referential integrity ensures that foreign key values in a database table correspond to valid primary keys in another table. This constraint prevents orphaned records and maintains consistency between related tables.