Oracle
1Z0-071 · Question #240
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. 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
- ASELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers
- BSELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers
- CSELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers
- DSELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers
How the community answered
(28 responses)- A7% (2)
- B75% (21)
- C4% (1)
- D14% (4)
Community Discussion
No community discussion yet for this question.