A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.
A)incremental updates
B)incremental deletes
C)cascading updates
D)cascading deletes

Question

Quizplus · Accepted Answer

Cascading updates is the referential integrity constraint policy that ensures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table. When a primary key value is updated, it is cascaded to all the corresponding foreign keys in the child tables, ensuring data consistency. Incremental updates and deletes are not relevant to this scenario, while cascading deletes can result in loss of data if not used carefully.

A Referential Integrity Constraint Policy That Insures That Foreign Key