
SQL Subqueries and Joins Quiz
Quiz
•
Information Technology (IT)
•
University
•
Practice Problem
•
Medium
ARLENE QUICAY
Used 7+ times
FREE Resource
Enhance your content in a minute
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Which of the following queries best finds students who are taking the same course as 'Alice' using a subquery?
SELECT StudentName FROM Students WHERE CourseID IN (SELECT CourseID FROM Students WHERE StudentName = 'Alice');
SELECT StudentName FROM Students s JOIN Courses c ON s.CourseID = c.CourseID WHERE c.CourseName = 'Alice';
SELECT StudentName FROM Students WHERE StudentName = 'Alice';
SELECT StudentName FROM Students WHERE CourseID = ALL (SELECT CourseID FROM Courses WHERE CourseName = 'Alice');
2.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
You are tasked to find instructors not assigned to any course. Which type of SQL approach is most appropriate?
Inner Join
LEFT JOIN with WHERE CourseID IS NOT NULL
Subquery using NOT IN
Correlated Subquery inside JOIN
3.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Why might a subquery be preferred over a join in Task 1 (finding students enrolled in 'Database Systems')?
It simplifies the query by hiding the relationship in a nested form
It uses fewer keywords, making the SQL script shorter to write and read
Because it clearly separates the filtering condition from the main query
Because JOINs do not work with multiple tables
4.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Which query correctly lists students taking courses with no assigned instructor using a JOIN?
SELECT StudentName FROM Students JOIN Courses ON Students.CourseID = Courses.CourseID WHERE Courses.InstructorID IS NULL;
SELECT StudentName FROM Students JOIN Instructors ON Students.CourseID = Instructors.InstructorID;
SELECT StudentName FROM Students WHERE InstructorID IS NULL;
SELECT StudentName FROM Students JOIN Courses ON Courses.InstructorID IS NOT NULL;
5.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Which JOIN ensures that all students are listed even if their course has no instructor assigned?
INNER JOIN between Students and Instructors
LEFT JOIN between Students → Courses → Instructors
RIGHT JOIN between Instructors and Courses
CROSS JOIN between Students and Courses
6.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Which of the following best explains when to prefer an INNER JOIN over a subquery?
When filtering using a single-column comparison
When you need to filter rows that have no related values
When combining data from multiple tables for result display
When avoiding Cartesian products
7.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Which query correctly returns instructors who are not assigned to any course using a LEFT OUTER JOIN?
SELECT i.InstructorName FROM Instructors i LEFT JOIN Courses c ON i.InstructorID = c.InstructorID WHERE c.CourseID IS NULL;
SELECT i.InstructorName FROM Instructors i LEFT JOIN Courses c ON i.InstructorID = c.InstructorID WHERE i.InstructorID IS NULL;
SELECT i.InstructorName FROM Instructors i LEFT JOIN Courses c ON c.InstructorID = i.InstructorID WHERE c.InstructorID IS NOT NULL;
SELECT i.InstructorName FROM Instructors i JOIN Courses c ON i.InstructorID = c.InstructorID WHERE c.CourseID IS NULL;
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Comandos SQL
Quiz
•
University
10 questions
MongoDB Concepts 1
Quiz
•
University
10 questions
Windows Group Policy Object Batch 1
Quiz
•
University
10 questions
HTML + CSS + JS
Quiz
•
University
10 questions
Base de Datos I - Parte 2
Quiz
•
University
12 questions
practicaIndices
Quiz
•
University
20 questions
APPDEV Prelim
Quiz
•
University
10 questions
Chapter Quiz
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Information Technology (IT)
7 questions
How James Brown Invented Funk
Interactive video
•
10th Grade - University
5 questions
Helping Build the Internet: Valerie Thomas | Great Minds
Interactive video
•
11th Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
19 questions
Review2-TEACHER
Quiz
•
University
15 questions
Pre2_STUDENT
Quiz
•
University
20 questions
Ch. 7 Quadrilateral Quiz Review
Quiz
•
KG - University
