Multiple choice technology testing

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. 03-JUL-00

  2. 10-JUL-00

  3. 12-JUL-00

  4. 11-JUL-00

  5. 17-JUL-00

  6. 09-JUL-00
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The NEXT_DAY function returns the date of the first weekday named by char that is later than the date sysdate. Since July 10, 2000 is a Monday, the next Monday is exactly one week later, which is July 17, 2000.

AI explanation

To determine the answer, let's break down the given statement and understand how it works:

The statement NEXT_DAY(sysdate, 'MONDAY') returns the date of the next occurrence of the day specified, which in this case is 'MONDAY'.

So, when we execute the statement SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;, it will return the date of the next Monday.

Given that today is Monday, 10 July 2000, the next Monday will be on 17 July 2000.

Therefore, the correct answer is E) 17-JUL-00.

Keep practicing — related questions