Oracle Database 12c: Advanced Administration — Question 45

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 the ADR's capabilities of storing statspack snapshots for performance analysis and functioning even when the database is inactive. Options A, B, and E are incorrect as they either misrepresent the sharing of the ADR base, the format of stored information, or confuse the ADR's purpose with that of AWR.