🎴 Flashcard Mode
Database Fundamentals: Keys, Cursors, and PL/SQL
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Cascade option is used
AnswerClick to flip back
A
disable dependent integrity constraint
💡 Explanation:
The CASCADE option in Oracle (e.g., 'DISABLE CONSTRAINT pk_emp CASCADE') disables a constraint and automatically disables any dependent integrity constraints. This prevents situations where a primary key constraint remains enabled while its dependent foreign key constraints are disabled, which would violate referential integrity rules.