Multiple choice technology databases

Which clause use CASCADE CONSTRAINTS in the syntax?

  1. ALTER TABLE DROP COLUMN

  2. ALTER TABLE DROP CONSTRAINT

  3. ALTER TABLE DISABLE CONSTRAINT

  4. -
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Oracle SQL, the CASCADE CONSTRAINTS clause is used with ALTER TABLE DROP COLUMN to automatically drop any referential integrity constraints (like foreign keys) that refer to the column being dropped. This prevents errors when removing columns that are part of a relationship.

Keep practicing — related questions