🎙 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 1 of 15

In a recursive CTE, how many times does the anchor query run?

In a recursive CTE, how many times does the anchor query run?

  1. A.Once
  2. B.Once per level of recursion
  3. C.Once per row in the table
  4. D.Until it returns no rows
Answer & explanation

Correct answer: Once

The anchor produces the starting rows; only the recursive part repeats.

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 →