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