Oracle
1Z0-052 · Question #166
1Z0-052 Question #166: Real Exam Question with Answer & Explanation
The correct answer is A: Lock statistics for the tables.. See the full explanation below for the reasoning.
Question
You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?
Options
- ALock statistics for the tables.
- BChange STALE_PERCENT to zero for the tables.
- CSet the TIMED_STATISTICS parameter to TRUE.
- DSet the STATISTICS_LEVEL parameter to BASIC.
- ESet the OPTIMIZER_USE_PENDING parameter statistics to TRUE.
Community Discussion
No community discussion yet for this question.