QUESTION 8

Given table R(A,B,C) and S(C,D,E), which of the following SQL statements would find the record(s) with null values on the column C in table R?

a. select * from R left outer join S where R.C = S.C;

b. select * from R right outer join S where R.C = S.C;

c. either a. or b.

d. neither a. nor b.

QUESTION 20

Given table R(A,B,C) and S(C,D,E), which of the following SQL statements would find the record(s) with null values on the column C in table S?

a. select * from R left outer join S where R.C = S.C;

b. select * from R right outer join S where R.C = S.C;

c. either a. or b.

d. neither a. nor b.