Examine the structure of the INVOICE table: Exhibit: 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;
Why C is correct ? Is the value ‘sysdate’ implicitly convertible to ‘number’ ?