Oracle Database Administration I — Question 29

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

Answer options

• A. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set
• B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
• C. It supports diagnostics for Automatic Storage Management (ASM)
• D. It supports diagnostics for Oracle Clusterware
• E. It is held inside an Oracle database schema

Correct answer: C, D

Explanation

The correct answers are C and D because the Automatic Diagnostic Repository (ADR) indeed provides diagnostic capabilities for both Automatic Storage Management (ASM) and Oracle Clusterware. Options A and B are incorrect as they describe the default locations for the ADR base, which do not pertain to the support capabilities of ADR. Option E is also incorrect because ADR is not confined to a database schema; it operates independently.