1z0-071 Exam QuestionsBrowse all questions from this exam

1z0-071 Exam - Question 201

Which statement executes successfully?

SELECT TO_NUMBER(INTERVAL ‘800’ SECOND, ‘HH24:MM’) FROM DUAL;

SELECT TO_CHAR(INTERVAL ‘800’ SECOND, ‘HH24:MM’) FROM DUAL;

SELECT TO_NUMBER(TO_DATE(INTERVAL ‘800’ SECOND)) FROM DUAL;

SELECT TO_DATE(TO_NUMBER(INTERVAL ‘800’ SECOND)) FROM DUAL;

SELECT TO_DATE(INTERVAL ‘800’ SECOND, ‘HH24:MM’) FROM DUAL;

Show Answer

Correct Answer: B

The statement 'SELECT TO_CHAR(INTERVAL ‘800’ SECOND, ‘HH24:MM’) FROM DUAL;' executes successfully. The INTERVAL '800' SECOND expression can be converted into a character string using the TO_CHAR function, which supports display formats such as 'HH24:MM'. This correctly converts the interval to a readable string representing hours and minutes. None of the other options perform valid operations with the INTERVAL data type.

Discussion

7 comments

jfc1Option: B

Feb 16, 2023

B is correct

zouveOption: B

Jul 2, 2023

B tested

MooonLight

Apr 24, 2023

Can please explain?

Rik92

May 15, 2023

INTERVAL '800' SECOND, 'HH24:MM' will result in +00 00:13:20.000000 using the 'HH24:MM' format. This string can only be converted to a character string, not into any of the other options.

lucemqyOption: B

Nov 15, 2023

B is correct

yaya32Option: B

Jan 24, 2024

B is correct

amizh

Apr 18, 2024

Only one LONG column is allowed per table. refer: https://docs.oracle.com/cd/A58617_01/server.804/a58241/ch5.htm#418225

amizh

Apr 18, 2024

pls ignore the below information. it is for qsn:209