Oracle
1Z0-061 · Question #45
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. Option B. 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?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(23 responses)- A9% (2)
- B74% (17)
- C4% (1)
- D13% (3)
Community Discussion
No community discussion yet for this question.

