Multiple choice technology databases

An outer join is used to:

  1. Return records which have no direct match

  2. Return records which have direct match

  3. Return all the records

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Outer joins (LEFT, RIGHT, FULL) are specifically designed to return unmatched rows from one or both tables, along with matched rows. This is their defining purpose - unlike inner joins which only return matches. Option A correctly identifies this behavior.

Keep practicing — related questions