1z0-071 Oracle Database 12c SQL 第41题 NVL2

Q41.  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?
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;;

Correct Answer: AC

NVL2(value1,value2,value3)中的value1、value2、value3要保持字段类型相同。