Which type of JOIN returns all matching rows from both tables, plus all unmatched rows from the left table with NULL values filled in for the right table columns? MCQ with Answer and Explanation
Which type of JOIN returns all matching rows from both tables, plus all unmatched rows from the left table with NULL values filled in for the right table columns?
A. Full Outer Join
B. Inner Join
C. Right Outer Join
D. Left Outer Join
Answer: Option D
Solution (By JKSSB Mock Tests)
A Left Outer Join preserves all records from the left table, matching them with right table records when possible, or inserting NULL values if no match is found.
An attribute that can be broken down into smaller, independent sub-parts with independent meanings (such as Name into First_Name and Last_Name) is called a what?
No comments yet. Be the first to start the discussion!