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

An outer join returns records from one table even when there's no matching record in the other table. This is useful for finding unmatched records (like customers without orders) or maintaining all records from a primary table.

Keep practicing — related questions