Given the following statements: S1: A foreign key declaration can always be…
GATE · 2014 · CS · Set 1 · Computer Science & IT
Given the following statements:
S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL.
S2: Given the table where and 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?
- A.
S1 is TRUE and S2 is FALSE.
- B.
Both S1 and S2 are TRUE.
- C.
S1 is FALSE and S2 is TRUE.
- D.
Both S1 and S2 are FALSE.
Attempted by 843 students.
Sign up free to check your answer
Sign up freeLoading lesson…