OCP 11g考试题库详解：1Z0-051-096题

OCP 11g考试题库详解：1Z0-051-096题，完整题库请点击这里联系老师咨询了解

96. Examine the structure of the INVOICE table.

name Null Type

INV_NO NOT NULL NUMBER(3)

INV_DATE DATE

INV_AMT NUMBER(10,2)

Which two SQL statements would execute successfully? (Choose two.)

A. SELECT inv_no,NVL2(inv_date,'Pending','Incomplete')

FROM invoice;

B. SELECT inv_no,NVL2(inv_amt,inv_date,'Not Available')

FROM invoice;

C. SELECT inv_no,NVL2(inv_date,sysdate-inv_date,sysdate)

FROM invoice;

D. SELECT inv_no,NVL2(inv_amt,inv_amt*.25,'Not Available')

FROM invoice;

Answer: AC

试题解析：

此题考NVL2参数类型是否一致的问题。