Introduction to SQL - Technical MCQs

Q1:

ON UPDATE CASCADE ensures which of the following?

A Normalization

B Data Integrity

C Materialized Views

D All of the above.

ANS:B - Data Integrity

ON UPDATE CASCADE indicates that if we update the parent, then the change is cascaded (affected) to the child easily.
However, Data integrity means maintaining and assuring the accuracy and consistency of data over its entire life-cycle. Therefore, Cascade directly leads to data integrity.

For Example: If you delete a company, you might also want to delete the company's history of addresses.