If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
A)the primary key
B)any alternate key
C)a surrogate key
D)a foreign key

Question

Quizplus · Accepted Answer

The correct answer is A) the primary key. In a database, if a relationship has a cascade updates constraint, then changing the primary key value in the parent table will automatically update any corresponding foreign key values in the child table to maintain referential integrity.

If a Relationship Has a Cascade Updates Constraint, Then If