Skills101
← All practice quizzes

Quiz: SQL Joins

5 questionsNo time limitPass: 60%+10 XP on first pass

Combine tables with joins. Venn-style pictures for each join type, real results on a sample database, self joins for manager questions, and the classic interview traps.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

    Which join returns only rows that have a match in BOTH tables?

  2. Question 2

    Table A has 5 rows and B has 4 rows. How many rows does A CROSS JOIN B return?

  3. Question 3

    How do you find customers who have NEVER placed an order?

  4. Question 4

    To list each employee with their manager's name from ONE employees table, you use a:

  5. Question 5

    After a LEFT JOIN, what value appears in the right table's columns for unmatched rows?