ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

41 / 120

Question 41:

Examine the structure of the INVOICE table. 
image
Which two SQL statements would execute successfully? 

Answer options:

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;