Download Aptitude Crack
img not found img not found

Introduction to SQL

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.



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.