Which three statements are true about the Automatic Diagnostic Repository (ADR)? (Choose three.)
Which three statements are true about the Automatic Diagnostic Repository (ADR)? (Choose three.)
The Automatic Diagnostic Repository (ADR) can be used for problem diagnosis of a database when the database's instance is down, as it stores diagnostic data outside the database. The ADR base is specified in the DIAGNOSTIC_DEST database parameter. Additionally, ADR is a file-based repository held outside any database, not inside an Oracle database schema, ensuring diagnostic information is available even if the database instance cannot be accessed.
ABD A - The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down. B - They are replaced by the initialization parameter DIAGNOSTIC_DEST, which identifies the location of the ADR. D - The data is then stored in the Automatic Diagnostic Repository (ADR)—a file-based repository outside the database—where it can later be retrieved by incident number and analyzed. https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/diagnosing-and-resolving-problems.html#GUID-43A0C671-CE6F-492F-9032-A010E96DC257
I agree ABD
Provided answer are wrong: The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down. The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/diagnosing-and-resolving-problems.html#GUID-EA97EEF6-9207-4536-B808-3B91DACA7AD6
A B D are correct