Multiple choice technology databases

Which type of join should be written to perform an outer join of tables A and B that returns all rows from B?

  1. Any outer join

  2. A left outer join

  3. A cross join

  4. A right outer join

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A RIGHT OUTER JOIN returns all rows from the right table (Table B) and the matched rows from the left table (Table A). If there is no match, the result contains NULL values for the columns of Table A.