← Quiz: Recursive CTEs: all 15 questions
Quiz: Recursive CTEs · Question 13 of 15
A calendar CTE starts at '2026-01-01' and adds one day while d < '2026-01-31'. How many days does it produce?
A calendar CTE starts at '2026-01-01' and adds one day while d < '2026-01-31'. How many days does it produce?
- A.30
- B.32
- C.1
- D.31
Answer & explanation
Correct answer: 31
The last row made is '2026-01-31', produced from '2026-01-30'; then the condition fails.
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 →