10th Grade Joins & Subqueries Quizzes, Questions & Answers

10th Grade

Top Trending Joins & Subqueries Quizzes

This SQL Join Basics Quiz tests your understanding of how to combine data from multiple tables using joins and subqueries. You'll practice INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN techniques, plus learn when and how...

Questions: 15 | Attempts: 11 | Last updated: May 1, 2026

Sample Question 1
Which JOIN returns only rows that exist in both tables?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

Sample Question 2
What does a LEFT JOIN do?

Returns all rows from the left table and matching rows from the right

Returns only matching rows from both tables

Returns all rows from the right table and matching rows from the left

Returns rows that don't match in either table

Sample Question 3
In the query: SELECT * FROM students LEFT JOIN grades ON students.id = grades.student_id, what does ON do?

Specifies the condition to match rows between tables

Filters the final result set

Orders the results

Limits the number of rows returned

10th Grade Joins & Subqueries Quizzes, Questions & Answers

Top Trending Joins & Subqueries Quizzes

Recent Joins & Subqueries Quizzes