Oracle 1z0-071 Question Answer
Which statement executes successfully?
SELECT TO_DATE(TO_NUMBER(INTERVATL '800' SECOND)) FROM DUAL;
SELECT TO_NUMBER(INTERVAL'800' SECOND, 'HH24:MM') FROM DUAL;
SELECT TO_DATE(INTERVAL '800' SECOND,'HH24:MM') FROM DUAL;
SELECT TO_NUWBER(TO_DATE(INTERVAL '800' SECOND)) FROM DUAL;
SELECT TO_CHAR(INTERVAL '800' SECOND, 'HH24:MM') FROM DUAL;
Oracle's interval data types store a period of time. When you want to format an interval as a string, you can use the TO_CHAR function.
A. This statement will not execute successfully because TO_DATE expects a string representing a date, not a number derived from an interval.
B. This statement will not execute successfully because TO_NUMBER does not support interval data types as an input.
C. This statement will not execute successfully because TO_DATE does not support interval data types as an input.
D. This statement will not execute successfully because TO_NUMBER expects a number or a string representing a number as an argument, not a date.
E. This statement will execute successfully. TO_CHAR function can be used to convert interval values to a formatted string, such as 'HH24:MM'.
TESTED 11 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved