You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr')
FROM DUAL;
What is the result?
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr')
FROM DUAL;
What is the result?
The query uses SYSDATE to get the current date, LAST_DAY to get the last day of the current month, and NEXT_DAY to find the next specified day after that date. In this case, NEXT_DAY finds the first Monday after the last day of the current month. TO_CHAR formats the resulting date to the specified format 'dd "Monday for" fmMonth rrrr'. Therefore, the query returns the date for the first Monday of the next month.
Answer is B. Tested.
There should be 'Monday' instead of 'MON'
https://www.examtopics.com/discussions/oracle/view/27077-exam-1z0-082-topic-1-question-86-discussion/ It works fine
The argument char must be a day of the week in the date language of your session, either the full name or the abbreviation https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/NEXT_DAY.html#GUID-01B2CC7A-1A64-4A74-918E-26158C9096F6
B correct. D is wrong. output is "06 Monday for May 2024"