engineering computer science MCQ #788

Which join type returns all records from the left table and matching records from the right table?

engineering computer science MCQ #788

  1. Question 1

    Q1. Which join type returns all records from the left table and matching records from the right table?

    • A) INNER JOIN
    • B) LEFT JOIN
    • C) RIGHT JOIN
    • D) FULL OUTER JOIN

    Answer: LEFT JOIN

    Explanation: LEFT JOIN returns all records from the left table and matching records from the right table, or NULL if no match.