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, s where r. c = s. c (+); (r left outer join s)
b. select * from r, s where s. c = r. c (+); (r right outer join s)
c. either a. or b.
d. neither a. nor b.

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

Explanation:

In SQL, left outer join of two tables R and S joined on a common column C means that all rows of R are included in the result including those rows for which value of R.C is null. On the contrary, right outer join of two tables R and S joined on a common column C means that all rows of S are included in the result including those rows for which value of S.C is null. As per the question our requirement is the former. So option a is correct.

here's the

hope it