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
...
This section is not available anymore. Please use the main Exam Page.1z0-082 Exam Questions
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 1 year, 3 months agokhaleesi89
Most Recent 6 months, 1 week ago[Removed]
6 months, 2 weeks agoOracle2020
8 months ago8hyehye8
8 months agomusafir
1 year, 4 months agoBeomK
1 year, 7 months agoGuhborges
1 year, 8 months agoivanadj
1 year, 8 months agostefan_a
1 year, 10 months agoGuhborges
1 year, 8 months agoWh0au
2 years, 1 month agosteves
2 years, 2 months ago