Oracle
1Z0-054 · Question #34
1Z0-054 Question #34: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #34. The question stem and answer options stay visible for context.
Question
You observe that suboptimal execution plans for the queries are being generated on a table that previously used less resources. You have collected statistics on these tables two days ago. The optimizer statistics retention period is set to 31 days. You are able to find the timestamp information about statistics update from the DBA_TAB_STATS_HISTORY view. Because it is a frequently queried table, you would like the optimizer to generate better plans. Which action would enable you to use the previous set of statistics on the objects that may lead to better execution plans?
Options
- Arestoring statistics from statistics history up to the desired time
- Bdeleting all AWR snapshots collected after the time of desired statistics collection
- Capplying the flashback table technique until the time of desired statistics collection
- Dsetting the OPTIMIZER_PENDING_STATISTICS parameter to TRUE to use the previous version
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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.