Oracle Exam 1Z0-071 Topic 16 Question 4 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 4
Topic #: 16

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?

ASELECT NVL (TO CHAR(cust_credit_limit * .15), 'Not Available') 'NEW CREDIT'FROM customers;

BSELECT TO_CHAR (NVL(cust_credit_limit * .15), 'Not Available') 'NEW CREDIT'FROM customers;

CSELECT NVL(cust_credit_limit * .15), 'Not Available') 'NEW CREDIT'FROM customers;

DSELECT NVL(cust_credit_limit), 'Not Available') 'NEW CREDIT'FROM customers;

Show Suggested Answer

Suggested Answer: A

by Judy at May 03, 2022, 07:45 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!