Multiple choice technology databases

In databases, ON UPDATE CASCADE ensures which of the following?

  1. Normalization

  2. Data Integrity

  3. Materialized Views

  4. None of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ON UPDATE CASCADE is a referential integrity constraint that automatically updates dependent rows when a referenced primary key is updated. This ensures data consistency across related tables, preventing orphaned records and maintaining the integrity of relationships. Options A and C describe different database concepts (normalization and materialized views).

Keep practicing — related questions