🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: Recursive CTEs: all 15 questions

Quiz: Recursive CTEs · Question 2 of 15

When does the recursion stop?

When does the recursion stop?

  1. A.After exactly 10 rounds
  2. B.When the anchor returns no rows
  3. C.When the recursive part returns no new rows
  4. D.When the outer SELECT has a LIMIT
Answer & explanation

Correct answer: When the recursive part returns no new rows

Each round works on the previous round's rows; an empty round ends it.

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 →