Question

Which of the following joins returns all rows from both tables, filling in NULL values for non-matching rows?

A INNER JOIN Correct Answer Incorrect Answer
B LEFT JOIN Correct Answer Incorrect Answer
C RIGHT JOIN Correct Answer Incorrect Answer
D FULL JOIN Correct Answer Incorrect Answer
E None of these Correct Answer Incorrect Answer

Solution

The FULL JOIN returns all rows from both tables and fills in NULL values for non-matching rows.

Practice Next
×
×