Which two SQL statements would execute successfully?

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

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;



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Stefano

Stefano

Why C is correct ? Is the value ‘sysdate’ implicitly convertible to ‘number’ ?