Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

© examsnet.com

Question : 24 of 50

Marks: +1, -0

Examine the structure of the INVOICE table.

Which two SQL statements would execute successfully?

SELECT inv_no, NVL2(inv_date, 'Pending', 'Incomplete') FROM invoice;
SELECT inv_no, NVL2(inv_amt, inv_date, 'Not Available') FROM invoice;
SELECT inv_no, NVL2(inv_date, sysdate-inv_date, sysdate) FROM invoice;
SELECT inv_no, NVL2(inv_amt, inv_amt*.25, 'Not Available') FROM invoice;

Go to Question:

Advertisements