ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

90 / 120

Question 90:

View the Exhibit and examine the structure of the CUSTOMERS table. 
image
Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers. Customers with no credit limit should have "Not Available" displayed. Which SQL statement would produce the required result? 

Answer options:

A. SELECT NVL(TO_CHAR(cust_credit_limit*.15), "˜Not Available`) "NEW CREDIT" FROM customers;
B. SELECT TO_CHAR(NVL(cust_credit_limit*.15, "˜Not Available`)) "NEW CREDIT" FROM customers;
C. SELECT NVL(cust_credit_limit*.15, "˜Not Available`) "NEW CREDIT" FROM customers;
D. SELECT NVL(cust_credit_limit, "˜Not Available`)*.15 "NEW CREDIT" FROM customers;