📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!
  • google app store apple app store
    • ✖

      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