Web-Technologies
October 3, 2023Operating-Systems
October 3, 2023Database-Management-System
Question 22 |
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), b = (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?
R contains a,b,e,f,g but not c, d.
| |
R contains all of a,b,c,d,e,f,g | |
R contains e,f,g but not a,b | |
R contains e but not f,g |
Question 22 Explanation:
⋆ So, from the above resultant table, R contains e, f, g only but not a, b.
Correct Answer: C
Question 22 Explanation:
⋆ So, from the above resultant table, R contains e, f, g only but not a, b.
Subscribe
Login
0 Comments