Question

Which join refers to join records from the right table that have no matching key in the left table are include in the result set:

(a) Left outer join

(b) Right outer join

(c) Full outer join

(d) Half outer join

I have been asked this question in a job interview.

The question is from Join Expressions in section SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Right option is (b) Right outer join

For explanation: RIGHT OUTER JOIN: Return all rows from the right table and the matched rows from the left table.