Oracle Discussions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam

Go to Exam

Exam 1z0-071 topic 1 question 210 discussion

Actual exam question from Oracle's 1z0-071

Question #: 210
Topic #: 1

[All 1z0-071 Questions]

Which statement executes successfully?

A. SELECT TO_NUMBER(INTERVAL ‘800’ SECOND, ‘HH24:MM’) FROM DUAL;
B. SELECT TO_CHAR(INTERVAL ‘800’ SECOND, ‘HH24:MM’) FROM DUAL;
C. SELECT TO_NUMBER(TO_DATE(INTERVAL ‘800’ SECOND)) FROM DUAL;
D. SELECT TO_DATE(TO_NUMBER(INTERVAL ‘800’ SECOND)) FROM DUAL;
E. SELECT TO_DATE(INTERVAL ‘800’ SECOND, ‘HH24:MM’) FROM DUAL;

Show Suggested Answer

Suggested Answer: B 🗳️

by jfc1 at Feb. 16, 2023, 2:34 p.m.

Comments

Submit Cancel

amizh

8 months, 1 week ago

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

upvoted 1 times

...

amizh

8 months, 1 week ago

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

upvoted 1 times

...

yaya32

11 months, 1 week ago

Selected Answer: B

B is correct

upvoted 1 times

...

lucemqy

1 year, 1 month ago

Selected Answer: B

B is correct

upvoted 1 times

...

zouve

1 year, 5 months ago

B tested

upvoted 2 times

...

MooonLight

1 year, 8 months ago

Can please explain?

upvoted 1 times

Rik92

1 year, 7 months ago

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.

upvoted 1 times

...

jfc1

1 year, 10 months ago

Selected Answer: B

B is correct

upvoted 4 times

...