A referential integrity constraint policy that insures that all rows containing a particular foreign key value in a table are eliminated from the table when the row containing the corresponding primary key value in a parent table is eliminated from the database is called ________.
A)incremental updates
B)incremental deletes
C)controlled key adjustments
D)cascading updates
E)cascading deletes

Question

Quizplus · Accepted Answer

Cascading deletes is the referential integrity constraint policy that ensures that all rows containing a particular foreign key value in a table are eliminated from the table when the row containing the corresponding primary key value in a parent table is eliminated from the database. Therefore, option E is the best choice. The other options are not relevant to the given scenario.

A Referential Integrity Constraint Policy That Insures That All Rows