Oracle Exam 1Z0-071 Topic 11 Question 62 Discussion

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

Question #: 62
Topic #: 11

[All 1Z0-071 Questions]

Which two will execute successfully?

ASELECT COALESCR('DATE', SYSDATE) FROM DUAL;

BSELECT NVL('DATE',SYSDATE) FROM DUAL;

CSELECT COALESCE(O,SYSDATE) TRCH DUAL;

DSELECT NVL('DATE',200) FROM (SELECT NULL AS ''DATE'' FROM DUAL);

ESELECT COALESCE('DATE',SYSDATE) FROM (SELECT NULL AS ''DATE'' FROM DUAL) ;

Show Suggested Answer

Suggested Answer: B, D

by Cammy at Aug 21, 2022, 01:39 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!