Oracle Database Administration II — Question 36

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

Answer options

• 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.

Correct answer: A, B, E

Explanation

Options A, B, and E are correct as ADDM has the capability to recommend both shrinking and extending the buffer cache based on workload analysis, and AWR snapshots are set to auto-purge every eight days. Options C, D, and F are incorrect because MMON automatically creates AWR snapshots every 30 minutes without DBA intervention, ADDM performs its analysis continuously, and AWR snapshots are not manually deleted by ADDM.