What rows does a LEFT JOIN return that an INNER JOIN does not?
Answer options
A
Rows from the right table with no match in the left table
B
Rows from the left table with no match in the right table
C
Duplicate rows from both tables
D
Rows where both tables have NULL values
Correct answer: Rows from the left table with no match in the right table
Explanation
Quick AnswerThe correct answer is Rows from the left table with no match in the right table because it directly addresses the core logic of Database Management.
This question has been retained as-is due to its unique context.