Which of the following determines the location of the Automatic Diagnostic Repository (ADR)?

Answer: D

Explanation: Answer option D is correct. utomatic Diagnostic Repository (ADR) is a special central storage point for all diagnostic reports. t is automatically maintained into memory by Oracle 11g. It enables database components to apture diagnostic data at its first failure for critical errors. It is a file base storage point. All nstances such as RDBMS and ASM instances maintain a separate directory structures within DR. he DIAGNOSTIC_DEST instance parameter determines the location of the Automatic iagnostic epository (ADR). C, A, and B are incorrect. Flash Recovery Area is used to store backup and ecovery data, and not problem diagnosis data. ADR_BASE is neither a directory nor an nvironment variable.