Multiple choice technology databases

Cascade option is used

  1. disable dependent integrity constraint

  2. deactivate an integrity constraint

  3. both of above

  4. none of above
Reveal answer Fill a bubble to check yourself
A Correct answer
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.

Keep practicing — related questions