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?
- Normalization
- Data Integrity
- Materialized Views
- All of the above
Answer: B. Data Integrity
Table of content
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:
