nerdexam
Oracle

1Z0-514 · Question #42

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

The correct answer is D. recommends solutions and quantifies expected benefits E. retains snapshots in the SYSAUX tablespace until the database is restarted F. analyzes the snapshots stored in the Automatic Workload Repository (AWR). See the full explanation below for the reasoning.

Question

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

Options

  • Arequires the database to be open
  • Banalyses the performance of specified objects
  • Cimplements all recommendations automatically
  • Drecommends solutions and quantifies expected benefits
  • Eretains snapshots in the SYSAUX tablespace until the database is restarted
  • Fanalyzes the snapshots stored in the Automatic Workload Repository (AWR)

How the community answered

(41 responses)
  • A
    2% (1)
  • B
    7% (3)
  • C
    12% (5)
  • D
    78% (32)

Community Discussion

No community discussion yet for this question.

Full 1Z0-514 Practice