SQL Quiz
10 questions · no time limit
0:00
SUBQUERIES AND CTES
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
Consider these predicates, each used for the same customer row:
Predicate 1:
EXISTS (SELECT NULL FROM Orders o WHERE o.customer_id = c.customer_id)
Predicate 2:
c.customer_id IN (SELECT o.customer_id FROM Orders o WHERE o.customer_id = c.customer_id)For a non-
NULL customer ID, which statement best explains the role of the values projected by the subqueries? YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end