engineering computer science MCQ #789

engineering computer science MCQ #789

1. Question 1

   Q1. What is the result of a FULL OUTER JOIN between two tables?

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

   Answer: All records from both tables, with NULL in non-matching columns

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