engineering computer science MCQ #881

engineering computer science MCQ #881

1. Question 1

   Q1. What is the difference between a inner join and a left join?

   • A) An inner join returns all records from both tables, while a left join returns only matching records
   • B) An inner join returns only matching records, while a left join returns all records from the left table and matching records from the right table
   • C) An inner join is used for data encryption, while a left join is not
   • D) An inner join is used for indexing, while a left join is not

   Answer: An inner join returns only matching records, while a left join returns all records from the left table and matching records from the right table

   Explanation: An inner join returns only matching records, while a left join returns all records from the left table and matching records from the right table.