nerdexam
Oracle

1Z0-052 · Question #261

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…

The correct answer is F. On Wednesday, the retention period has been set to two days. Exam Questions, Study Guides, Practice Tests. Lead the way to help you pass any IT Certification exams, 100% Pass Guaranteed or Full Refund. Especially Cisco, CompTIA, Citrix, EMC, HP, Oracle, VMware, Juniper, Check Point, LPI, Nortel, EXIN and so on. Our Slogan: First Test…

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.

How the community answered

(33 responses)
  • A
    3% (1)
  • D
    15% (5)
  • E
    3% (1)
  • F
    70% (23)
  • G
    9% (3)

Explanation

Exam Questions, Study Guides, Practice Tests. Lead the way to help you pass any IT Certification exams, 100% Pass Guaranteed or Full Refund. Especially Cisco, CompTIA, Citrix, EMC, HP, Oracle, VMware, Juniper, Check Point, LPI, Nortel, EXIN and so on. Our Slogan: First Test, First Pass. Help you to pass any IT Certification exams at the first try. You can reach us at any of the email addresses listed below. Any problems about IT certification or our products, you could rely upon us, we will give you satisfactory answers in 24 hours.

Topics

#AWR retention period#Automatic Workload Repository#Memory Advisor#statistics purging

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice