Which JOIN type returns all rows from the left table and matched rows from the right table, filling NULLs where there is no match?
Understand — Tests comprehension and ability to explain concepts.
Answer Options
Want to see the correct answer?
Get the answer with a detailed explanation, plus practice 15+ more RDBMS & SQL questions with adaptive quizzes and timed interviews.
See the Answer on Guru Sishya →This question is from the RDBMS & SQL topic (Databases).
More RDBMS & SQL Questions
What is the difference between RANK() and DENSE_RANK() window functions when there are ties?
Medium-EasyWhat type of index should you use for a column that is only ever queried with exact equality checks (e.g., WHERE user_id = 42)?
Medium-EasyWhich ACID property guarantees that a committed transaction's data survives a system crash?
EasyAt which isolation level can 'phantom reads' occur — where a transaction re-runs a query and finds new rows inserted by another committed transaction?
MediumA table has columns: order_id (PK), customer_id, customer_name, product_id, product_name, quantity. Which normal form violation does this represent?
Medium