SQL Join Basics Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By ProProfs AI
P
ProProfs AI
Community Contributor
Quizzes Created: 81 | Total Attempts: 817
| Questions: 15 | Updated: May 1, 2026
Please wait...
Question 1 / 16
🏆 Rank #--
0 %
0/100
Score 0/100

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

Explanation

INNER JOIN returns rows that have matching values in both tables involved in the query. It effectively filters out any rows that do not have corresponding entries in the other table, ensuring that only the intersecting data is included in the result set. This makes it useful for combining related information from two datasets.

Submit
Please wait...
About This Quiz
SQL Join Basics Quiz - Quiz

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 to use subqueries effectively. Perfect for grade 10 students building intermediate SQL... see moreskills. see less

2.

What first name or nickname would you like us to use?

You may optionally provide this to label your report, leaderboard, or certificate.

2. What does a LEFT JOIN do?

Explanation

A LEFT JOIN retrieves all records from the left table, even if there are no corresponding matches in the right table. For rows in the left table without a match, NULL values are returned for the right table's columns. This allows for a comprehensive view of the left table's data alongside any relevant information from the right table.

Submit

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

Explanation

The ON clause in a JOIN statement defines the specific condition that establishes how rows from the two tables relate to each other. In this case, it specifies that the rows from the "students" table should be matched with rows from the "grades" table based on the student ID, ensuring accurate data linkage.

Submit

4. Which JOIN includes all rows from both tables, even if there's no match?

Explanation

A FULL OUTER JOIN combines all records from both tables, returning matched rows where available and filling in with NULLs where there are no matches. This ensures that every row from both tables is represented in the result, regardless of whether there is a corresponding row in the other table.

Submit

5. A subquery is a query nested inside another query. True or False?

Explanation

A subquery is indeed a query that is embedded within another SQL query. It allows for the retrieval of data that can be used by the outer query, enabling more complex data operations and filtering. This definition aligns with the fundamental structure of SQL, confirming the statement as true.

Submit

6. What is the result of a RIGHT JOIN?

Explanation

A RIGHT JOIN returns all rows from the right table, ensuring that even if there are no matching entries in the left table, the right table's data will still be included in the result. If there are matches, corresponding data from the left table is also displayed.

Submit

7. In a subquery, the inner query runs _____ and its result is used by the outer query.

Explanation

In a subquery, the inner query executes before the outer query. This sequential processing allows the outer query to utilize the results of the inner query, enabling it to perform operations based on those results. Thus, the inner query must complete its execution first to provide the necessary data for the outer query's operations.

Submit

8. Which keyword is used to introduce a subquery in the WHERE clause?

Explanation

The "IN" keyword is used in SQL to specify a subquery within the WHERE clause. It allows you to filter results based on whether a column's value matches any value returned by the subquery, effectively narrowing down the dataset to relevant entries that meet the specified criteria.

Submit

9. A CROSS JOIN produces a result set combining every row from the first table with every row from the second table. True or False?

Explanation

A CROSS JOIN generates a Cartesian product, meaning it pairs each row from the first table with every row from the second table. This results in a comprehensive combination of all possible row pairs, making the statement true.

Submit

10. Which type of subquery returns multiple rows?

Explanation

A table subquery is designed to return multiple rows and columns as a result set. Unlike scalar or single-value subqueries, which return a single value, table subqueries can provide a complete set of data that can be used in the main query, allowing for more complex data retrieval and analysis.

Submit

11. What is the main difference between a JOIN and a subquery?

Explanation

JOINs allow the combination of rows from two or more tables based on related columns, effectively merging data horizontally. In contrast, subqueries are queries nested within another query, allowing for more complex data retrieval but typically operating independently of the main query's structure. This fundamental difference defines their use in SQL.

Submit

12. The keyword used to match columns in a JOIN is _____.

Explanation

In SQL, the "ON" keyword is used in JOIN operations to specify the condition that defines how rows from two or more tables are related. It establishes the criteria for matching columns, enabling the database to combine data based on the specified relationship.

Submit

13. Which statement best describes a correlated subquery?

Submit

14. In SQL, the INNER JOIN is the most commonly used join type. True or False?

Submit

15. A subquery placed in the FROM clause is called a _____ or derived table.

Submit
×
Saved
Thank you for your feedback!
View My Results
Cancel
  • All
    All (15)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Which JOIN returns only rows that exist in both tables?
What does a LEFT JOIN do?
In the query: SELECT * FROM students LEFT JOIN grades ON students.id =...
Which JOIN includes all rows from both tables, even if there's no...
A subquery is a query nested inside another query. True or False?
What is the result of a RIGHT JOIN?
In a subquery, the inner query runs _____ and its result is used by...
Which keyword is used to introduce a subquery in the WHERE clause?
A CROSS JOIN produces a result set combining every row from the first...
Which type of subquery returns multiple rows?
What is the main difference between a JOIN and a subquery?
The keyword used to match columns in a JOIN is _____.
Which statement best describes a correlated subquery?
In SQL, the INNER JOIN is the most commonly used join type. True or...
A subquery placed in the FROM clause is called a _____ or derived...
play-Mute sad happy unanswered_answer up-hover down-hover success oval cancel Check box square blue
Alert!