Multiple choice technology databases

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual?

  1. 10-JUL-00

  2. 12-JUL-00

  3. 11-JUL-00

  4. 14-JUL-00

  5. 17-JUL-00
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

NEXT_DAY finds the first occurrence of the specified day after the given date. Starting from Monday July 10, the next Monday is July 17. The format mask 'DD-MON-RR' gives 17-JUL-00. The other options are incorrect dates.

Keep practicing — related questions