Oracle Database Administration I — Question 117

Which three statements are true about the Automatic Diagnostic Repository (ADR)? (Choose three.)

Answer options

• A. It can be used for problem diagnosis of a database when that database's instance is down.
• B. The ADR base is specified in the DIAGNIOSTIC_DEST database parameter.
• C. It is held inside an Oracle database schema.
• D. It is a file-based repository held outside any database.
• E. It is only used for Oracle Database diagnostic information.

Correct answer: A, B, D

Explanation

The correct answers are A, B, and D because ADR provides diagnostic capabilities even when a database instance is down (A), the ADR base is indeed set by the DIAGNOSTIC_DEST parameter (B), and it is a file-based repository external to any database (D). Option C is incorrect as the ADR is not contained within an Oracle database schema, and option E is misleading since ADR can also handle diagnostics for other Oracle products, not just the database.