engineering computer science MCQ #620

engineering computer science MCQ #620

1. Question 1

   Q1. What is the result of a LEFT JOIN operation?

   • A) Only matching rows from both tables
   • B) All rows from the left table, with NULLs in non-matching columns
   • C) Only rows from the right table
   • D) All rows from both tables

   Answer: All rows from the left table, with NULLs in non-matching columns

   Explanation: A LEFT JOIN returns all rows from the left table, with NULLs in columns where there are no matches in the right table.