UGC-NET | UGC NET CS 2015 Jun – II | Question 18

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




My Personal Notes arrow_drop_up
Article Tags :

Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.