Oracle Database Administration I — Question 172

You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd `Monday for` fmMonth rrrr')
What is the result?

Answer options

• A. It executes successfully but does not return any result
• B. It returns the date for the first Monday of the next month
• C. It generates an error
• D. It returns the date for the last Monday of the current month

Correct answer: B

Explanation

The query successfully retrieves the date of the first Monday of the next month after determining the last day of the current month. Option A is incorrect because the query does return a result, while options C and D do not match the expected output of the query.