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

What rule must the anchor and the recursive part follow?

What rule must the anchor and the recursive part follow?

  1. A.They must read different tables
  2. B.The recursive part must return fewer columns
  3. C.They must return the same number of columns, in the same order
  4. D.They must both use GROUP BY
Answer & explanation

Correct answer: They must return the same number of columns, in the same order

They are combined with UNION ALL, so their columns must line up.

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 →