-
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.
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 ?
-
- S1 is TRUE and S2 is FALSE.
- Both S1 and S2 are TRUE.
- S1 is FALSE and S2 is TRUE.
- Both S1 and S2 are FALSE.
- S1 is TRUE and S2 is FALSE.
Correct Option: D
Both S1 and S2 are false.
