Oracle
1Z0-072 · Question #12
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)
The correct answer is B. ADDM can recommend shrinking the buffer cache. E. By default, AWR snapshots are automatically purged after eight days. F. ADDM performs its analysis only whenever a DBA requests it. See the full explanation below for the reasoning.
Question
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)
Options
- AAWR snapshots must be deleted when no longer required by ADDM.
- BADDM can recommend shrinking the buffer cache.
- CBy default, MMON creates an AWR snapshot every 30 minutes.
- DADDM can recommend extending the buffer cache.
- EBy default, AWR snapshots are automatically purged after eight days.
- FADDM performs its analysis only whenever a DBA requests it.
How the community answered
(63 responses)- A6% (4)
- B79% (50)
- C3% (2)
- D11% (7)
Community Discussion
No community discussion yet for this question.