Oracle Database 11g: Administration I — Question 24

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

Answer options

• A. It can assist the DBA in diagnosing database instance startup failures
• B. Its findings are accessible only by using Oracle Enterprise Manager
• C. It provides recommendations to improve database performance
• D. It runs automatically after each Automatic Workload Repository snapshot is created
• E. It improves database performance by automatically implementing Oracle’s best practices
• F. it can be used by executing the PL/SQL procedures in the DBMS_ADDM package

Correct answer: B, C, D

Explanation

The correct answers B, C, and D highlight that ADDM's findings are accessible via Oracle Enterprise Manager, it provides performance improvement recommendations, and it operates automatically after each AWR snapshot. Options A, E, and F are incorrect as they don't accurately represent ADDM's capabilities or functions in the same context.