Oracle Database 12c: Installation and Administration — Question 14

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

Answer options

• A. It calls SQL advisors automatically if required.
• B. It provides recommendations only for poorly performing SQL statements.
• C. Its results are stored in AWR.
• D. It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.
• E. It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.

Correct answer: C, E

Explanation

The correct answers, C and E, are true because ADDM stores its findings in the AWR and indeed requires at least one AWR snapshot to perform analysis. Options A and B are incorrect as ADDM does not automatically call SQL advisors or limit recommendations to just poorly performing SQL statements. Option D is also incorrect because ADDM runs automatically after each snapshot, but it does not require two snapshots for its analysis.