Multiple choice technology mainframe

Which of the following is defined on the dependent table to implement a referential constraint?

  1. Primary Key

  2. Check constraint

  3. Foreign Key

  4. Update trigger
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A referential constraint maintains relationships between tables by ensuring that values in a foreign key column match existing values in the parent table's primary key. The foreign key is defined on the dependent (child) table and points to the primary key of the referenced (parent) table. Check constraints validate column values, while triggers perform actions in response to events, but neither implements referential integrity.

Keep practicing — related questions