Exam 1z0-082 All QuestionsBrowse all questions from this exam
Go to Exam
Question 86

You execute this query:

SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd `Monday for` fmMonth rrrr')

What is the result?

    Correct Answer: C

    The query executes the SELECT statement without a FROM clause, which is mandatory in SQL. Therefore, it generates an error. The correct syntax should include 'FROM DUAL' to ensure it runs successfully.

Discussion
zouveOption: B

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.

Wh0auOption: B

FROM DUAL; must be added after the query statement so answer is B

stevesOption: C

I think answer should be C. There is no from clause!

BeomKOption: B

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

GuhborgesOption: B

The correc query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') from dual; B is right.

khaleesi89Option: B

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.

SDXINOption: C

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

Oracle2020Option: C

c is correct, because it generates an error, the query does not have the FROM keyword

8hyehye8Option: C

ORA-01846: 01846. 00000 - "not a valid day of the week"

musafirOption: C

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/

ivanadjOption: C

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

stefan_aOption: C

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

Guhborges

It was probably a mistake when moving to the website, some characters are wrong. For me, the righ answers is B.