Multiple choice

Referential integrity stipulates

  1. Every table must have a primary key

  2. Foreign keys must always reference a valid unique key

  3. Joins should only be used with foreign and primary keys

  4. Columns should be atomic

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Referential integrity ensures that relationships between tables remain consistent. It requires that any foreign key field in a table must point to a valid, existing primary key or unique key in the referenced table, preventing orphaned records.

Keep practicing — related questions