Oracle Exam 1Z0-071 Topic 16 Question 91 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 91
Topic #: 16

Which statement executes successfully?

ASELECT TO_DATE(TO_NUMBER(INTERVATL '800' SECOND)) FROM DUAL;

BSELECT TO_NUMBER(INTERVAL'800' SECOND, 'HH24:MM') FROM DUAL;

CSELECT TO_DATE(INTERVAL '800' SECOND,'HH24:MM') FROM DUAL;

DSELECT TO_NUWBER(TO_DATE(INTERVAL '800' SECOND)) FROM DUAL;

ESELECT TO_CHAR(INTERVAL '800' SECOND, 'HH24:MM') FROM DUAL;

Show Suggested Answer

Suggested Answer: E

by Joanna at May 03, 2024, 01:49 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

6 months ago

No way. It's definitely not D or E. Maybe B?

upvoted 0 times

...

6 months ago

I agree with User4. E seems the most logical.

upvoted 0 times

...

7 months ago

I think they all seem confusing. Maybe E?

upvoted 0 times

...

7 months ago

I don't know about A. What about D?

upvoted 0 times

...

7 months ago

Statement A looks tricky.

upvoted 0 times

...

7 months ago

Which statement executes successfully?

upvoted 0 times

...