Oracle

1Z0-071 · Question #404

Which two will execute successfully? (Choose two.)

The correct answer is A. SELECT COALESCE('DATE', SYSDATE) FROM (SELECT NULL AS "DATE" FROM DUAL); D. SELECT COALESCE(0, SYSDATE) FROM DUAL. See the full explanation below for the reasoning.

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);

How the community answered

(35 responses)

A
77% (27)
B
6% (2)
C
6% (2)
E
11% (4)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-071 Practice