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;
Examine the structure of the INVOICE table:Exhibit:Which two SQL statements would execute successfully? (Choose two.)
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am