本套题库是OCP考试中的071(中文版)试题,由CUUG整理。
11、请选择两项。
哪两项将成功执行?
A) SELECT NVL(‘DATE‘, 200) FROM (SELECT NULL AS "DATE" FROM DUAL) ;
B) SELECT COALESCE(0, SYSDATE) FROM DUAL;
C) SELECT NVL(‘DATE‘, SYSDATE) FROM DUAL;
D) SELECT COALESCE(‘DATE‘, SYSDATE) FROM DUAL;
E) SELECT COALESCE (‘DATE‘, SYSDATE) FROM (SELECT NULL AS "DATE" FROM DUAL) ;