Oracle
1Z0-061 · Question #34
You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the…
The correct answer is D. Option D. See the full explanation below for the reasoning.
Question
You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows. Which query will provide the required result?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(44 responses)- A7% (3)
- B5% (2)
- C18% (8)
- D70% (31)
Community Discussion
No community discussion yet for this question.