Oracle
1Z0-071 · Question #58
You want to display 5 percent of the rows from the sales table for products with the lowestAMOUNT_SOLD and also want to include the rows that have the sameAMOUNT_SOLDeven if this causes the output…
The correct answer is B. SELECT prod_id, cust_id, amount_sold. 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 lowestAMOUNT_SOLD and also want to include the rows that have the sameAMOUNT_SOLDeven if this causes the output to exceed 5 percent of the rows. Which query willprovide the required result?
Options
- ASELECT prod_id, cust_id, amount_sold
- BSELECT prod_id, cust_id, amount_sold
- CSELECT prod_ id, cust_id, amount_sold
- DSELECT prod_id, cust_id, amount_sold
How the community answered
(29 responses)- A10% (3)
- B79% (23)
- C3% (1)
- D7% (2)
Community Discussion
No community discussion yet for this question.