ON UPDATE CASCADE ensures which of the following?

Solution (By Examveda Team)

Option A: Normalization - ON UPDATE CASCADE in SQL is not directly related to normalization, which is a process of organizing data to minimize redundancy and dependency.
Option B: Data Integrity - This is the correct option. ON UPDATE CASCADE is a referential integrity constraint that ensures data integrity by automatically updating related records in child tables when the parent record is updated.
Option C: Materialized Views - ON UPDATE CASCADE does not relate to materialized views, which are views that store the results of a query physically for faster access.
Option D: All of the above - This option suggests that ON UPDATE CASCADE ensures all the benefits mentioned in Options A, B, and C. However, only Option B correctly describes the purpose of ON UPDATE CASCADE.
Conclusion:
In SQL, ON UPDATE CASCADE ensures data integrity by automatically updating related records in child tables when the parent record is updated. Therefore, the correct answer is Option B: Data Integrity.