engineering computer science MCQ #755

engineering computer science MCQ #755

1. Question 1

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

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

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

   Explanation: INNER JOIN returns only the records that have matching values in both tables, while LEFT JOIN returns all records from the left table and the matching records from the right table.