engineering computer science MCQ #612

engineering computer science MCQ #612

1. Question 1

   Q1. What is the result of a FULL OUTER JOIN operation?

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

   Answer: All rows from both tables, with NULLs in non-matching columns

   Explanation: A FULL OUTER JOIN returns all rows from both tables, with NULLs in columns where there are no matches.