Oracle
1Z0-060 · Question #169
1Z0-060 Question #169: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-060 to reveal the answer and full explanation for question #169. The question stem and answer options stay visible for context.
Question
You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?
Options
- AA TOP-N query is created during execution and a filter is added to the query dynamically using
- BA view is created during execution and a filter on the view limits the rows to 20 percent of the total
- CAll the rows are returned to the client or middle tier but only the first 20 percent are returned to the
- DA filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of
Unlock 1Z0-060 to see the answer
You've previewed enough free 1Z0-060 questions. Unlock 1Z0-060 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.