Which SQL statement would produce the required result?

View the Exhibit and examine the structure of the 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?

A.
Option A

B.
Option B

C.
Option C

D.
Option D

Explanation:

NVL Function
Converts a null value to an actual value:

Data types that can be used are date, character, and number.
Data types must match:
– NVL(commission_pct, 0)
– NVL(hire_date, ’01-JAN-97′)
– NVL(job_id, ‘No Job Yet’)