JOINs — INNER, LEFT, RIGHT, CROSS — Concept Check
Questions on JOINs — INNER, LEFT, RIGHT, CROSS. INNER JOIN returns matching rows; LEFT/RIGHT JOIN includes unmatched rows from one side; CROSS JOIN produces a Cartesian product; choose the right join to avoid silent data exclusion.
Questions in this quiz
7 questions on JOINs — INNER, LEFT, RIGHT, CROSS — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.A report is missing some customers who have no orders. Which JOIN should you use to include all customers, even those without orders?
- ACROSS JOIN
- BINNER JOIN
- CLEFT JOIN
- DRIGHT JOIN
2.You notice a query is producing a huge result set unexpectedly. Which JOIN type might be the cause?
- ACROSS JOIN
- BLEFT JOIN
- CRIGHT JOIN
- DINNER JOIN
3.A query using INNER JOIN is missing some expected rows. What might be the issue?
- AAll rows have matching keys
- BIndexes are missing
- CCROSS JOIN was used
- DRows have NULL foreign keys
4.Which JOIN type should you use to ensure all employees appear, even those without managers?
- AINNER JOIN
- BCROSS JOIN
- CRIGHT JOIN
- DLEFT JOIN
5.A developer uses RIGHT JOIN to get all orders with customer info. Why might this be less preferred?
- AINNER JOIN is always better
- BRIGHT JOIN is faster
- CLEFT JOIN is more intuitive
- DCROSS JOIN is more efficient
6.Which JOIN type is likely to cause a full table scan if indexes are missing?
- ARIGHT JOIN
- BCROSS JOIN
- CINNER JOIN
- DLEFT JOIN
7.You need to combine data from multiple tables and ensure performance. What should you do?
- AIndex all JOIN columns
- BUse CROSS JOIN
- CUse RIGHT JOIN
- DAvoid LEFT JOIN