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;

technology testing

  1. 03-JUL-00

  2. 10-JUL-00

  3. 12-JUL-00

  4. 11-JUL-00

  5. 17-JUL-00

  6. 09-JUL-00

Show answer
Correct Option: D

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.

Find more quizzes: