Oracle Database Administration 2019 Certified Professional — Question 35

Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)

Answer options

• A. It can analyze performance over any given time period.
• B. It can diagnose skew in response time.
• C. It can analyze performance using data captured on all instances.
• D. It can only analyze performance on the instance running the ADDM job.
• E. It can diagnose latency problems in the Cluster Interconnect.
• F. It runs automatically in Instance ADDM mode after each AWR snapshot is created.

Correct answer: A, B, C

Explanation

The correct options A, B, and C highlight ADDM's capabilities, allowing it to analyze performance over any time period, diagnose response time skew, and utilize data from all instances. Option D is incorrect since ADDM can analyze across all instances, not just the one executing the job. Options E and F, while relevant to ADDM, do not accurately reflect its primary functions in the context of performance analysis.