Suppose R1(A, B) and R2(C, D) are two relation schemas. Let r1 and r2 be the…

PYQ GATE 2012

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?

  1. A.

    ΠB(r1)−ΠC(r2)=∅\Pi_{B}(r_{1})- \Pi_{C}(r_{2})= \varnothing

  2. B.

    ΠC(r2)−ΠB(r1)=∅\Pi_{C}(r_{2})- \Pi_{B}(r_{1})= \varnothing

  3. C.

    ΠB(r1)=ΠC(r2)\Pi_{B}(r_{1}) = \Pi_{C}(r_{2})

  4. D.

    ΠB(r1)−ΠC(r2)≠∅\Pi_{B}(r_{1}) - \Pi_{C}(r_{2}) \neq \varnothing

Attempted by 639 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…