ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

14 / 120

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? 
image

                
                
            
            
            
                

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;