📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    Question

    Which join returns rows from the left table even when

    there is no matching row in the right table, filling with NULLs for the right side?
    A INNER JOIN Correct Answer Incorrect Answer
    B CROSS JOIN Correct Answer Incorrect Answer
    C RIGHT OUTER JOIN Correct Answer Incorrect Answer
    D LEFT OUTER JOIN Correct Answer Incorrect Answer
    E FULL OUTER JOIN Correct Answer Incorrect Answer

    Solution

    LEFT OUTER JOIN returns all left rows and matches from right or NULLs when no match.

    Practice Next
    More SQL Questions
    ask-question