Oracle
1Z0-485 · Question #19
1Z0-485 Question #19: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-485 to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Question
How does partition pruning, a 11g R2 database feature, help to improve performance on an Exadata Database Machine?
Options
- APartition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and
- BUsing partition pruning can force the optimizer to use that method instead of Smart Scan.
- CPartition pruning is not a supported option in the 11gR2 database code that runs on an Exadata
- DPartition pruning allows you to reduce the size of the physical table by reducing fragmentation
- EPartition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and
Unlock 1Z0-485 to see the answer
You've previewed enough free 1Z0-485 questions. Unlock 1Z0-485 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.