Multiple choice technology databases

To write a query that performs an outer join of tables A and B and returns all rows from B, You need to write

  1. any outer join

  2. left outer join

  3. cross join

  4. 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 (B) and matching rows from the left table (A), with NULL for non-matching left-side rows. LEFT OUTER JOIN would return all from A, CROSS JOIN is a Cartesian product, and ANY OUTER JOIN isn't valid SQL syntax.

Keep practicing — related questions