GATE Papers >> CSE >> 2015 >> Question No 140

Question No. 140 CSE | GATE 2015

Consider two relations R1(A,B) with the tuples(1, 5), (3, 7) and R2(A, C) = (1, 7), (4, 9). Assume that R(A,B,C) is the full natural outer join of R1 and R2. Consider the following tuples of the form (A, B, C): a =(1, 5, null), =(1, null, 7), c = (3, null, 9), d = (4, 7, null), e = (1, 5, 7), f = (3, 7, null), g = (4, null, 9). Which one of the following statements is correct?


Answer : (C) R contains e, f, g but not a, b.


Solution of Question No 140 of GATE 2015 CSE Paper
R1 A B
  1 5
3 7

R2 A C
  1 7
4 9

R = R1 $ ? $ R2

R A B C
  1 5 7
3 7 Null
4 Null 9

R contains e, f, g but not a, b.

Comments
No Comments
Leave a comment