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 IFNULL(cust_credit_limit * 0.15, 'Not Available') "NEW CREDIT" FROM customers;
C
SELECT NULLIF(cust_credit_limit*.15, 'Not Available') "NEW CREDIT" FROM customers;
D
SELECT cust_credit_limit * 0.15 "NEW CREDIT" FROM customers;
Correct answer: SELECT NVL(TO_CHAR(cust_credit_limit*.15), 'Not Available') "NEW CREDIT" FROM customers;
Explanation
Quick AnswerThe correct answer is SELECT NVL(TO_CHAR(cust_credit_limit*.15), 'Not Available') "NEW CREDIT" FROM customers; because it directly addresses the core logic of Database Management.
This question has been retained as-is due to its unique context.