Examine the structure of the INVOICE table:Exhibit:Which two SQL statements would execute successfully? (Choose two.)

[answerhappygod]

Examine the structure of the INVOICE table:Exhibit:Which two SQL statements would execute successfully? (Choose two.)

Examine The Str 1 (1.1 KiB) Viewed 1524 times

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;