ЁЯУв 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