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:A
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;