Oracle
1Z0-071 · Question #219
The CUSTOMERS table has the following structure: You need to write a query that does the following tasks: 1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit…
The correct answer is B. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE. See the full explanation below for the reasoning.
Question
The CUSTOMERS table has the following structure: You need to write a query that does the following tasks: 1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit. 2. Only those customers whose income level has a value should be considered. 3. Customers whose tax amount is null should not be considered. Which statement accomplishes all the required tasks?
Exhibit
Options
- AWhich statement accomplishes all the required tasks? SELECT cust_first_name, cust_credit_limit
- BSELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE
- CSELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE
- DSELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE
How the community answered
(27 responses)- A4% (1)
- B78% (21)
- C7% (2)
- D11% (3)
Community Discussion
No community discussion yet for this question.