WorksheetsSQL Joins Quiz
Total questions: 30
Worksheet time: 15mins
Which SQL join returns only the rows that have matching values in both tables?
LEFT JOIN
INNER JOIN
RIGHT JOIN
FULL JOIN
Which join includes all rows from the left table and the matched rows from the right table?
INNER JOIN
LEFT JOIN
RIGHT JOIN
CROSS JOIN
Which join returns all rows from the right table and the matched rows from the left table?
RIGHT JOIN
INNER JOIN
LEFT JOIN
FULL JOIN
Which join returns all rows when there is a match in either left or right table?
INNER JOIN
FULL JOIN
CROSS JOIN
NATURAL JOIN
Which SQL join produces the Cartesian product of two tables?
LEFT JOIN
RIGHT JOIN
CROSS JOIN
FULL JOIN
Which join matches rows automatically based on columns with the same name in both tables?
NATURAL JOIN
INNER JOIN
CROSS JOIN
SELF JOIN
A join in which a table is joined with itself is called?
INNER JOIN
NATURAL JOIN
SELF JOIN
CROSS JOIN
In an INNER JOIN, if one table has 10 rows and another has 15 rows, the maximum result set can be:
25
150
15
10
Which join can result in NULL values in the output?
INNER JOIN
CROSS JOIN
OUTER JOIN
SELF JOIN
LEFT JOIN is also known as:
Left Outer Join
Left Inner Join
Full Left Join
Semi Join
Which join ensures that unmatched rows from both tables appear in the result?
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
If you want to get all students even if they are not enrolled in any course, which join should you use between Students and Enrollments?
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
Which join duplicates rows when there are multiple matching rows?
CROSS JOIN
INNER JOIN
SELF JOIN
All of the above
Which SQL clause is always required in INNER JOIN?
WHERE
ON
HAVING
GROUP BY
A join that returns rows that do not have matching rows in another table is called?
Semi Join
Anti Join
Cross Join
Natural Join
Which of the following joins is not explicitly supported in SQL but can be simulated using NOT EXISTS or NOT IN?
INNER JOIN
LEFT JOIN
FULL JOIN
ANTI JOIN
Which join is best to find employees who have no department assigned?
INNER JOIN
LEFT JOIN with NULL check
RIGHT JOIN with NULL check
FULL JOIN with NULL check
Which join returns rows when at least one table has a match?
INNER JOIN
FULL OUTER JOIN
CROSS JOIN
NATURAL JOIN
In SQL, a CROSS JOIN without a WHERE clause gives:
Same as INNER JOIN
Cartesian product
Only matched rows
NULL values
A join that combines rows from two tables based on a condition is called:
Equi Join
Natural Join
Cross Join
Self Join
Which join uses equality operator (=) in join condition?
Equi Join
Non-Equi Join
Outer Join
Cross Join
Which join uses inequality operators like , =?
Equi Join
Non-Equi Join
Outer Join
Inner Join
If Table A has 5 rows and Table B has 4 rows, CROSS JOIN will return:
9 rows
20 rows
5 rows
4 rows
Which join type can be replaced by UNION of LEFT JOIN and RIGHT JOIN?
INNER JOIN
FULL OUTER JOIN
CROSS JOIN
NATURAL JOIN
Which join is used when a table references itself through a foreign key?
NATURAL JOIN
SELF JOIN
INNER JOIN
CROSS JOIN
Which SQL join is most likely to be slowest with very large tables?
INNER JOIN
OUTER JOIN
CROSS JOIN
SELF JOIN
Which join includes NULLs from both sides of the tables?
INNER JOIN
FULL OUTER JOIN
CROSS JOIN
NATURAL JOIN
Which join produces fewer rows than CROSS JOIN but more than INNER JOIN?
FULL OUTER JOIN
LEFT JOIN
RIGHT JOIN
None of the above
To join three tables together, you should use:
Multiple JOIN clauses
UNION
CROSS JOIN only
NATURAL JOIN only
Which join is best to use if you need all possible combinations between two tables?
INNER JOIN
CROSS JOIN
FULL OUTER JOIN
SELF JOIN
