Multiple choice technology databases

Referential constraint is

  1. Designates the values that columns of a table can contain

  2. The limiting of a set of foreign key values to a set of primary key values

  3. The limiting of a set of Primary key values to a set of foreign key values

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A referential constraint (foreign key constraint) ensures database integrity by restricting the values in a foreign key column to only those values that already exist in the referenced primary key column.

Keep practicing — related questions