aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Oracle Databases and SQL
  • Which of the following clause enables to drop the foreign...
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
D Correct answer

Keep practicing — related questions

  • Which clause use CASCADE CONSTRAINTS in the syntax?
  • Which of the following delete rules will not allow a row to be deleted from the parent table if a row with ...
  • What is true about FOREIGN KEY constraint? Choose all that apply
  • Which is the syntax for enforcing the rule of deleting the dependent Foreign Key values on the deletion of ...
  • Target table T1 is getting deleted. Table T2 has the foreign key. We require that whenever a row from T1 is...
  • Which of the following deletion rules on CREATE TABLE will allow parent table rows to be deleted if a depen...
  • Which type of key is defined on the child table to implement a referential constraint?
  • Which of the following is defined on the dependent table to implement a referential constraint?
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy