Here are two relations, R(A,B), S(C,D). Their current values are:

Here are two relations, R(A,B), S(C,D). Their current values are:

Here are two relations, R(A,B), S(C,D). Their current values are:

R
A B
-------------------
1 4
2 5
8 6
4 7

S
C D
-------------------
0 1
1 0
2 1
5 8

Compute the result of the query:

SELECT A, B, C, D
FROM R RIGHT OUTER JOIN S
ON R.A = S.C

Identify, in the list below, 2 rows that appears in the result.
a. (null, null, 0, 1)
b. (null, null, 5, 8)
c. (8, 6, null, null)
d. (4, 7, null, null)



Answer: A & B.


Learn More :