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 R(a,b,c)R(a,b,c) where aa and bb 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?

  1. A.

    S1 is TRUE and S2 is FALSE.

  2. B.

    Both S1 and S2 are TRUE.

  3. C.

    S1 is FALSE and S2 is TRUE.

  4. D.

    Both S1 and S2 are FALSE.

Attempted by 843 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…