Oracle
1Z0-514 · Question #32
1Z0-514 Question #32: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-514 to reveal the answer and full explanation for question #32. The question stem and answer options stay visible for context.
Question
You are a performance-sensitive DBA, and you are nervous about gathering new statistics, since they may alter optimization plans in an unexpected way. To avoid this potential outcome, your best course of action would be to:
Options
- Arefrain from collecting statistics
- Buse Real Application Testing to capture the workload and the worked and then run the worked on a
- Cuse hints to create fixed plans for SQL statements
- Duse deferred publishing of statistics to allow you to test execution plans before making the statistics
- Euse invisible indexes to dominate execution plans
Unlock 1Z0-514 to see the answer
You've previewed enough free 1Z0-514 questions. Unlock 1Z0-514 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.