Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)
- A. ADDM can recommend shrinking the buffer cache.
- B. ADDM can recommend extending the buffer cache.
- C. By default, MMON creates an AWR snapshot every 30 minutes.
- D. ADDM performs its analysis only when a DBA requests it.
- E. By default, AWR snapshots are automatically purged after eight days.
- F. AWR snapshots must be deleted when no longer required by ADDM.
AWR Snapshot's default interval is 1 hour and retention is 8 days. It means All AWR statistics are collected every 1 hour and they are kept 8 days by default. That means E is correct and F is wrong… so final correct answers are A; B; E