Test Your Knowledge
The EXISTS keyword in SQL is used to test for the existence of rows returned by a subquery. It’s often used in correlated subqueries for performance and conditional logic.
0 of 15 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 15 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
What does the EXISTS keyword do in SQL?
Which clause is most commonly used with EXISTS?
What does this query return?
SELECT name
FROM students s
WHERE EXISTS (
SELECT 1
FROM enrollments e
WHERE e.student_id = s.id
);
What is returned by the EXISTS subquery?
Can EXISTS be used without a correlated subquery?
What is the performance benefit of using EXISTS?
What value is commonly selected in an EXISTS subquery?
Which of the following is TRUE about EXISTS and IN?
Which of these is a valid EXISTS query?
SELECT name
FROM customers c
WHERE EXISTS (
SELECT 1
FROM orders o
WHERE o.customer_id = c.id
);
What does EXISTS return when subquery has no matching row?
What happens if EXISTS subquery returns multiple rows?
Which is more efficient on large tables with indexes?
Why is SELECT 1 used in EXISTS subqueries?
What is the output of this query?
SELECT department
FROM departments d
WHERE EXISTS (
SELECT 1
FROM employees e
WHERE e.department_id = d.id AND e.salary > 50000
);
Can EXISTS be nested inside another EXISTS?
The `EXISTS` keyword is used in SQL subqueries to check if any row exists in the result of a subquery. It’s efficient, especially in correlated subqueries, and returns a boolean value, helping filter results based on conditional presence.
Tags: mcq on sql exists in subqueryquiz on exists subquery in sqlquiz on sqlquiz on sql exists in subqueryquiz on sql exists subquerysql exists in subquery quizsql exists subquery quizSQL Quizsql quiz on exists in subquery
Quiz Orbit Team
At QuizOrbit, our team specializes in fun, informative quizzes across topics like general knowledge, technology, and entertainment. Boost your knowledge with our expert-designed quizzes.
