ON UPDATE CASCADE Ensures Which Of The Following?

By BYJU'S Exam Prep

Updated on: September 25th, 2023

ON UPDATE CASCADE ensures which of the following?

  1. Normalization
  2. Data Integrity
  3. Materialized Views
  4. All of the above

Answer: B. Data Integrity

ON UPDATE CASCADE ensures data integrity.


The ON UPDATE CASCADE ensures data integrity. In relation, if one value is updated, then, in turn, there might be the requirement of updating the other linked data to it. This functionality is provided by the command ON UPDATE CASCADE. Option A, normalization, does not ensure integrity as it is the methodology to reduce redundancy from the relation. Similarly, option C is incorrect.

☛ Related Questions:

Our Apps Playstore
SSC and Bank
Other Exams
GradeStack Learning Pvt. Ltd.Windsor IT Park, Tower - A, 2nd Floor, Sector 125, Noida, Uttar Pradesh 201303
Home Practice Test Series Premium