Oracle
1Z0-071 · Question #404
1Z0-071 Question #404: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #404. The question stem and answer options stay visible for context.
Question
Which two will execute successfully? (Choose two.)
Options
- ASELECT COALESCE('DATE', SYSDATE) FROM (SELECT NULL AS "DATE" FROM DUAL);
- BSELECT COALESCE('DATE', SYSDATE) FROM DUAL;
- CSELECT NVL('DATE', SYSDATE) FROM DUAL;
- DSELECT COALESCE(0, SYSDATE) FROM DUAL;
- ESELECT NVL('DATE', 200) FROM (SELECT NULL AS "DATE" FROM DUAL);
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.