Oracle
1Z0-052 · Question #261
1Z0-052 Question #261: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #261. The question stem and answer options stay visible for context.
Performing Database Maintenance
Question
Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However, when you observe the Memory Advisor on a Friday, you find that the statistics are available only for two days, Thursday and Friday, of that week. What would have caused the statistics to be removed?
Options
- AOn Wednesday, the statistics have been purged.
- BOn Wednesday, the retention period has been set to zero.
- COn Wednesday, the collection interval has been set to zero.
- DOn Wednesday, the collection level has been changed to All.
- EOn Wednesday, the retention period has been set to one day.
- FOn Wednesday, the retention period has been set to two days.
- GOn Wednesday, the collection level has been changed to Typical.
- HOn Wednesday, the collection interval has been set to 1440 minutes.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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.
Topics
#AWR retention period#Automatic Workload Repository#Memory Advisor#statistics purging