ON UPDATE CASCADE Ensures Which Of The Following?

By Anjnee Bhatnagar|Updated : July 7th, 2022

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.

Solution

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:

Comments

write a comment

Follow us for latest updates