Upgrade Oracle DBA 11g to Oracle Database 12c — Question 33

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

Answer options

• A. The ADR base is shared across multiple instances.
• B. The ADR base keeps all diagnostic information in binary format.
• C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
• D. The ADR can be used for problem diagnosis even when the database instance is down.
• E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

Correct answer: C, D

Explanation

The correct answers, C and D, highlight that the ADR is capable of storing statspack snapshots for performance diagnostics and can be utilized for problem diagnosis when the database instance is down. Options A, B, and E are incorrect as they misrepresent the functionality or scope of the ADR.