Oracle
1Z0-071 · Question #58
1Z0-071 Question #58: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #58. The question stem and answer options stay visible for context.
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
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.