Oracle
1Z0-082 · Question #94
Examine the description of the CUSTOMERS table: For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due…
The correct answer is E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Examine the description of the CUSTOMERS table:
For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed. Which query should be used?
Exhibit
Options
- ASELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers
- BSELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers
- CSELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers
- DSELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers
- ESELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers
How the community answered
(46 responses)- A2% (1)
- B7% (3)
- C11% (5)
- D2% (1)
- E78% (36)
Topics
#NULL handling#IS NOT NULL#WHERE clause filtering#credit limit query
Community Discussion
No community discussion yet for this question.