Multiple choice technology databases

What is referential integrity?

  1. The relation of the primary key of a base table with foreign key of the reference table is known as referential integriety.

  2. The relation of the secondary key of a base table with foreign key of the reference table is known as referential integriety.

  3. The relation of the primary key of a secondary table with foreign key of the reference table is known as referential integriety.

  4. The relation of the primary key of a base table with index key of the reference table is known as referential integriety.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Referential integrity is a database concept that ensures relationships between tables remain consistent. It is maintained by defining a Foreign Key in a child (reference) table that must match a Primary Key in the parent (base) table, ensuring no orphaned records exist.

Keep practicing — related questions