nerdexam
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

1Z0-071 question #108 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)
  • A
    74% (20)
  • B
    15% (4)
  • C
    4% (1)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice