🎴 Flashcard Mode
SQL and Database Fundamentals Quiz
Card1 / 19
Mastered0
Review0
QuestionClick to flip
In databases, ON UPDATE CASCADE ensures which of the following?
AnswerClick to flip back
A
Data Integrity
💡 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).