Question 41:
Examine the structure of the INVOICE table.
Which two SQL statements would execute successfully?
Answer options:
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;