Drop Table cannot be used to drop a Table referenced by __________ constraint.
(a)Primary key
(b)Sub key
(c)Super key
(d)Foreign key
(A) (a)
(B) (a), (b) and (c)
(C) (d)
(D) (a) and (d)
Answer: (C)
Explanation: Drop Table cannot be used to drop a Table referenced by foreign key constraint.
For more information on keys Refer:DBMS | Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign) and for information on sql operation Refer:SQL | ALTER (ADD, DROP, MODIFY)
Option (C) is correct
Quiz of this Question
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.