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
Last Updated :
14 May, 2018
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...