33. Given table R(A,B,C) and S(C,D,E), which of the following SQL statements wou

Question

33. 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.

34. 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.

Explanation / Answer

33

a. select * from R, S where R.C = S.C (+);

this sql will return all the records including nulls from R and only the matching records from table S

if you want only the null values on the column C in table R
then
d. neither a. nor b.
is the correct option

34

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

d.   neither a. nor b

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.