Oracle Database Administration II — Question 179

Which two are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

Answer options

• A. It analyzes a period of time corresponding to the 12 hours of activity.
• B. It runs automatically after each AWR snapshot.
• C. A DBA can run it manually.
• D. Results are written to the alert log.
• E. It analyzes a period of time corresponding to the last day of activity.

Correct answer: B, C

Explanation

The correct answers are B and C because ADDM is designed to run automatically after each AWR snapshot and can also be initiated manually by a DBA. Options A and E are incorrect as ADDM does not specifically analyze a fixed 12-hour period or the last day of activity, and option D is incorrect since results are not written to the alert log.