the correct query is
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') FROM DUAL;
I had this question also on the 1Z0-071 exam.
I had this question also on the 1Z0-071 exam taken on May 21, 2024 and the query was
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') FROM DUAL;
SO the correct answer in B.
Tested on May 15, 2024 via below:
https://livesql.oracle.com/apex/f?p=590:1:103395717088091:::RP::#
Command:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr')
Error:
ORA-00923: FROM keyword not found where expected
Command:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr')
FROM DUAL
Result:
TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'DD"MONDAYFOR"FMMONTHRRRR')
03 Monday for June 2024
C is correct since FROM DUAL is missing and ( 'Monday for') should actually be ("Monday for"). Could be an issue where the website didn't post the question correctly. I've seen this question in 071 exam which has the correct format but different answers.
https://www.examtopics.com/discussions/oracle/view/32798-exam-1z0-071-topic-2-question-17-discussion/
B is correct.
SQL> SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') from dual;
TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'DD"MONDAYFOR"FMMONTHRRRR')
--------------------------------------------------------------------------------
01 Monday for May 2023
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd `Monday for` fmMonth rrrr') from dual;
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd `Monday for` fmMonth rrrr') from dual
*
ERROR at line 1:
ORA-01821: date format not recognized
C - it generates an error, even if FROM dual is added.
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd `Monday for` fmMonth rrrr')
returns ORA-00923: FROM keyword not found where expected
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd `Monday for` fmMonth rrrr') FROM dual;
returns ORA-01821: date format not recognized
I think answer should be C. There is no from clause!
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
zouve
Highly Voted 10 months agokhaleesi89
Most Recent 2 weeks, 3 days ago[Removed]
3 weeks, 5 days agoOracle2020
2 months, 1 week ago8hyehye8
2 months, 1 week agomusafir
10 months, 2 weeks agoBeomK
1 year, 1 month agoGuhborges
1 year, 2 months agoivanadj
1 year, 3 months agostefan_a
1 year, 4 months agoGuhborges
1 year, 3 months agoWh0au
1 year, 8 months agosteves
1 year, 9 months ago