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
An
employees(employee_id, manager_id) table contains (1, NULL), (2, 1), (3, 99), (4, 3), and (5, NULL). There is no employee 99. A recursive CTE anchors on manager_id IS NULL and repeatedly joins employees whose manager_id equals an employee already in the CTE.Ignoring row order, which employee IDs will the CTE contain?
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