Which join type returns all records from both tables including unmatched rows, with NULLs where there is no match?

• A. INNER JOIN
• B. FULL OUTER JOIN
• C. CROSS JOIN
• D. LEFT OUTER JOIN

Answer: (B)

The concept tested is how join types handle rows that don’t have a match in the other table. A full outer join returns every row from both tables, and when a row from one table has no matching row in the other, the missing side is filled with NULLs. That’s why it’s the correct choice here: you see all records from both sides, with NULLs where there is no match.

Inner join would only include rows with matches in both tables, so unmatched rows are excluded. Cross join produces every possible combination of rows from the two tables, not about matching at all. Left outer join includes all rows from the left table (with NULLs on the right when there’s no match) but does not bring in unmatched rows from the right table.