Test Index

GATE CS and IT 2014 Paper

© examsnet.com

Question : 32

Total: 65

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.

Go to Question:

Prev Question

Next Question