Multiple choice technology databases

What does the function next_day('14-mar-2001','tuesday') return?

  1. '14-mar-2002'

  2. '13-mar-2001'

  3. '20-mar-2001'

  4. '14-apr-2001'

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The next_day function finds the first occurrence of the specified day of week after the given date. March 14, 2001 was a Wednesday, so the following Tuesday is March 20, 2001 (6 days later). Options A and B incorrectly calculate the date, while D jumps too far ahead to a full month.