← Quiz: Recursive CTEs: all 15 questions
Quiz: Recursive CTEs · Question 10 of 15
A filter WHERE level < 3 is written in the OUTER query instead of the recursive part. What happens?
A filter WHERE level < 3 is written in the OUTER query instead of the recursive part. What happens?
- A.The query fails
- B.The full recursion still runs; rows are only filtered afterwards
- C.It stops the recursion earlier
- D.It returns no rows
Answer & explanation
Correct answer: The full recursion still runs; rows are only filtered afterwards
The outer WHERE runs after the CTE is complete, so it cannot stop an endless loop.
Can you get the rest right without peeking?
Take the timed Quiz: Recursive CTEs quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →