Question 14:
View the Exhibit and examine the structure of CUSTOMERS table. Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "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`) "NEW CREDIT" FROM customers;