...
Web-Technologies
October 3, 2023
Demand-Paging
October 3, 2023
Web-Technologies
October 3, 2023
Demand-Paging
October 3, 2023

Database-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?  

A
R contains a,b,e,f,g but not c, d.
B
R contains all of a,b,c,d,e,f,g
C
R contains e,f,g but not a,b
D
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.
1 1 vote
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
error: Alert: Content selection is disabled!!