Easy Remember SQL open_ended

What does LEFT JOIN return when there is no matching row in the right table?

Remember — Tests recall of fundamental facts and definitions.

Want to see the correct answer?

Get the answer with a detailed explanation, plus practice 31+ more SQL questions with adaptive quizzes and timed interviews.

See the Answer on Guru Sishya →

This question is from the SQL topic (Databases).

Learn SQL → Browse All Questions

More SQL Questions

What does `NULL + 1` evaluate to in SQL?

True or False: A FULL OUTER JOIN returns all rows from both tables, including unmatched rows from each.

What is the difference between a primary key and a unique constraint?

What is the purpose of `COALESCE` in SQL?

What is the difference between WHERE and HAVING?