📢 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 type of join returns all rows from the left table

      and matching rows from the right table?
      A INNER JOIN Correct Answer Incorrect Answer
      B LEFT JOIN Correct Answer Incorrect Answer
      C RIGHT JOIN Correct Answer Incorrect Answer
      D FULL OUTER JOIN Correct Answer Incorrect Answer
      E CROSS JOIN Correct Answer Incorrect Answer

      Solution

      LEFT JOIN returns all records from the left table and matching records from the right table; non-matching right-side rows return NULL.

      Practice Next
      More IT DBMS Questions
      ask-question