nerdexam
Oracle

1Z0-052 · Question #64

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

The correct answer is B. The ADDM runs after each AWR snapshot is collected automatically by MMON C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR). This question tests how ADDM is triggered, what it produces, and where its output is persisted.

Performing Database Maintenance

Question

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

Options

  • AThe ADDM requires at least four AWR snapshots for analysis
  • BThe ADDM runs after each AWR snapshot is collected automatically by MMON
  • CThe results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
  • DThe ADDM analysis provides only diagnostics information but does not provide recommendations
  • EThe ADDM calls other advisors if required, but does not provide recommendations about the advisors

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    91% (21)
  • D
    4% (1)

Why each option

This question tests how ADDM is triggered, what it produces, and where its output is persisted.

AThe ADDM requires at least four AWR snapshots for analysis

ADDM analyzes the period between exactly two consecutive AWR snapshots; only two snapshots are required, not four.

BThe ADDM runs after each AWR snapshot is collected automatically by MMONCorrect

MMON (Manageability Monitor) automatically invokes ADDM after each AWR snapshot is collected, analyzing the interval between the latest and previous snapshots without requiring any manual DBA action.

CThe results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)Correct

ADDM stores its findings - including identified bottlenecks and actionable recommendations - in the AWR repository, making them queryable via DBMS_ADDM or viewable in Enterprise Manager.

DThe ADDM analysis provides only diagnostics information but does not provide recommendations

ADDM provides both diagnostic findings and concrete recommendations, such as increasing the buffer cache size or running the SQL Tuning Advisor.

EThe ADDM calls other advisors if required, but does not provide recommendations about the advisors

ADDM does call sub-advisors such as SQL Tuning Advisor and Segment Advisor, and it surfaces their recommendations as part of its own output to the DBA.

Concept tested: ADDM automatic invocation and AWR result storage

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/automatic-database-diagnostic-monitor.html

Topics

#ADDM#AWR snapshots#MMON#performance diagnostics

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice