Home / GATE 2017-2018 / GATE CSE :: Discussion

Discussion :: GATE CSE

  1. Suppose R1(A, B) and R2(C, D) are two relation schemas. Let r1 and r2 be the corresponding relation instances. B is a foreign key that refers to C in R2. If data in r1 and r2 satisfy referential integrity constraints, which of the following is ALWAYS TRUE?
  2. A.
    πB(r1) - πC(r2) = Ø
    B.
    πC(r2) - πB(r1) = Ø
    C.
    πB(r1) = πC(r2)
    D.
    πB(r1) - πC(r2) ≠ Ø

    View Answer

    Workspace

    Answer : Option A

    Explanation :

    -NA-


Be The First To Comment