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