Oracle
1Z0-054 · Question #33
1Z0-054 Question #33: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #33. The question stem and answer options stay visible for context.
Question
You have the automatic optimizer statistics gathering enabled for a 24x7 database as part of the automatic maintenance task. Because the automatic optimizer statistics collection runs during maintenance window(in the night), the statistics on tables that are significantly modified throughout the day becomes stale. This leads to poor query performance on these tables and you want to minimize the overhead in statistics collection. Identify a solution to this problem.
Options
- AChange the STALE_PERCENT preference to zero for the tables.
- BSet the OPTIMIZER_USE_PENDING parameter statistics to TRUE.
- CSet the OPTIMIZER_DYNAMIC_SAMPLING parameter to zero during day time.
- DGather statistics on the table when the tables have a representative number of rows, and then
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.