MCQ Guru LogoMCQ Guru

SQL Joins MCQs

Test your understanding of INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, and CROSS JOIN.

3 MCQsSubtopic of SQLProgrammingAll Levels
Subtopic Focus & Conceptual Depth

Deep-dive into Joins principles within SQL. These targeted questions evaluate edge-cases, common pitfalls, and interview problem patterns.

Skill Level
Focused Subtopic Mastery
Explanation Depth
Code Snippets & Analysis
Exam Scope
Campus Hiring & GATE CS

Other SQL Subtopics

All SQL MCQsJoinsQueries & Subqueries

Joins MCQ Questions

Page 1 of 1 (3 total)
Q1

Which JOIN returns all rows from the left table and matching rows from the right table, filling with NULL where there is no match?

easy
Correct Answer: LEFT JOIN
Explanation:
LEFT OUTER JOIN (or LEFT JOIN) returns all records from the left table and matched records from the right table. If no match exists, NULL is returned for right table columns.
Q2

Which join returns all rows from the left table, and matching rows from the right table, filling nulls if no match exists?

easy
Q3

What is the Cartesian product join of two tables with M and N rows respectively?

medium