Oracle
1Z0-071 · Question #108
View the Exhibit and examine the structure of the CUSTOMERS table. Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers. Customers…
The correct answer is A. SELECT NVL(TO_CHAR(cust_credit_limit*.15), `Not Available') "NEW CREDIT" FROM. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the CUSTOMERS table. 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?
Exhibit
Options
- ASELECT NVL(TO_CHAR(cust_credit_limit*.15), `Not Available') "NEW CREDIT" FROM
- BSELECT TO_CHAR(NVL(cust_credit_limit*.15, `Not Available')) "NEW CREDIT" FROM
- CSELECT NVL(cust_credit_limit*.15, `Not Available') "NEW CREDIT" FROM customers;
- DSELECT NVL(cust_credit_limit, `Not Available')*.15 "NEW CREDIT" FROM customers;
How the community answered
(27 responses)- A74% (20)
- B15% (4)
- C4% (1)
- D7% (2)
Community Discussion
No community discussion yet for this question.
