Oracle Database SQL — Question 182

You execute this query:

SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr')
FROM DUAL;

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 returns the date for the last Monday of the current month.
• D. It generates an error.

Correct answer: B

Explanation

The correct answer is B because the query is designed to find the first Monday after the last day of the current month, which is achieved using the NEXT_DAY and LAST_DAY functions. Options A and D are incorrect as the query executes without errors, and option C is incorrect because it refers to the last Monday of the current month instead of the first Monday of the next month.