Multiple choice technology databases

Which of the following clause enables to drop the foreign key constraints of the child table while dropping the parent table?

  1. drop foreign keys

  2. cascade constraints

  3. this is not possible in oracle

  4. clear references

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle SQL, dropping a parent table referenced by foreign keys requires the CASCADE CONSTRAINTS clause to automatically drop the referencing foreign key constraints on child tables.