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 84 discussion

Actual exam question from Oracle's 1z0-071

Question #: 84
Topic #: 1

[All 1z0-071 Questions]

Which two will execute successfully? (Choose two.)

A. SELECT COALESCE(0, SYSDATE) FROM DUAL;
B. SELECT NVL('DATE', SYSDATZ) FROM DUAL;
C. SELECT COALESCE('DATE', SYSDATE) FROM DUAL;
D. SELECT NVL('DATE', 200) FROM (SELECT NULL AS "DATE" FROM DUAL);
E. SELECT COALESCE('DATE', SYSDATE) FRCM (SELECT NULL AS "DATE" FROM DUAL);

Show Suggested Answer

Suggested Answer: BD 🗳️

by Babi265 at Dec. 5, 2022, 2:10 p.m.

Comments

Submit Cancel

62d4f30

9 months, 1 week ago

why isnt C correct?

upvoted 1 times

...

ArslanAltaf

1 year, 2 months ago

BD is correct provided there is a type on Question B, sysdate

upvoted 1 times

...

Omar116

1 year, 8 months ago

Selected Answer: BD

checked

upvoted 3 times

...

Sangiii

1 year, 10 months ago

B and D is correct answers.

upvoted 2 times

...

zouve

2 years ago

Selected Answer: BD

checked for E -> ORA-00932: inconsistent datatypes: expected CHAR got DATE

upvoted 1 times

...

Nelita

2 years ago

Selected Answer: BD

BD are correct

upvoted 2 times

...

kuff

2 years, 1 month ago

Selected Answer: BD

BD is the answer

upvoted 2 times

...

kaplanek

2 years, 2 months ago

Selected Answer: BD

verified, only BD is correct, E will throw an error ORA-00932

upvoted 1 times

...

jfc1

2 years, 5 months ago

E is wrong ORA-00932: inconsistent datatypes: expected CHAR got DATE BD is the correct one

upvoted 1 times

...

cadcadley

2 years, 5 months ago

BD IS 100% IF YOU GO TO CHEK

upvoted 1 times

...

Viviana3184

2 years, 5 months ago

B D if B is SELECT NVL('DATE', SYSDAte) FROM DUAL;

upvoted 1 times

...

Babi265

2 years, 6 months ago

Checked should be B D. E is wrong "inconsistent data type"

upvoted 1 times

...