engineering computer science MCQ #697

engineering computer science MCQ #697

1. Question 1

   Q1. What is the difference between INNER JOIN and LEFT JOIN?

   • A) INNER JOIN returns all rows, LEFT JOIN returns matching rows
   • B) INNER JOIN returns matching rows, LEFT JOIN returns all rows from the left table
   • C) INNER JOIN returns all rows from the right table, LEFT JOIN returns matching rows
   • D) INNER JOIN returns all rows from both tables, LEFT JOIN returns matching rows

   Answer: INNER JOIN returns matching rows, LEFT JOIN returns all rows from the left table

   Explanation: INNER JOIN returns rows with matches in both tables, while LEFT JOIN returns all rows from the left table and matching rows from the right table.