GATE Computer Science (CS) 2014 Shift 1 Solved Paper
© examsiri.com
Question : 32 of 65
Marks:
+1,
-0
Given the following statements:
S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL.
S2: Given the table R (a, b, c) where a and b together form the primary key, the following is a valid table definition.
Which one of the following statements is CORRECT?
S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL.
S2: Given the table R (a, b, c) where a and b together form the primary key, the following is a valid table definition.
CREATE TABLE S (
a INTEGER,
d INTEGER,
e INTEGER,
PRIMARY KEY (d)
FOREIGN KEY (a) references R)Which one of the following statements is CORRECT?
Go to Question: