Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Oracle 1Z0-182 Exam - Topic 3 Question 16 Discussion

Which three statements are true about Automatic Diagnostic Repository (ADR)?
A) It is a file-based repository held outside any database. and D) It can be used for the problem diagnosis of a database when that database's instance is down. and E) The ADR base is specified in the DIAGNOSTIC_DEST database parameter.
B) It is only used for Oracle database diagnostic information.
C) It is held inside an Oracle database schema.

Oracle 1Z0-182 Exam - Topic 3 Question 16 Discussion

Actual exam question for Oracle's 1Z0-182 exam
Question #: 16
Topic #: 3
[All 1Z0-182 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: A, D, E

A .True. ADR is a file system directory structure (e.g., /u01/app/oracle/diag), external to the database.

B .False. ADR also stores diagnostics for non-database components (e.g., ASM, listener).

C .False. It's file-based, not schema-based.

D .True. ADR logs (e.g., alert logs, trace files) are accessible even if the instance is down.

E .True. DIAGNOSTIC_DEST sets the ADR base directory.


by Ricarda at Nov 24, 2025, 03:56 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-182 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Tammara
2 months ago
I’m not sure about B. ADR is more than just Oracle info.
upvoted 0 times
...
Melita
2 months ago
E sounds correct too. DIAGNOSTIC_DEST is important.
upvoted 0 times
...
Louvenia
2 months ago
Definitely D! It’s crucial for diagnosing issues.
upvoted 0 times
...
Dante
2 months ago
C) sounds wrong to me, ADR isn't in a schema.
upvoted 0 times
...
Oliva
2 months ago
E) is spot on, that's how you set it up!
upvoted 0 times
...
Quentin
3 months ago
Wait, B) can't be right, can it?
upvoted 0 times
...
Leanora
3 months ago
I agree, D) is also true!
upvoted 0 times
...
Laurel
3 months ago
A) is definitely true, it's file-based.
upvoted 0 times
...
Alyce
4 months ago
Haha, the ADR is like a detective agency for your database issues, even when the database is MIA!
upvoted 0 times
...
Michael
4 months ago
C is wrong. The ADR is not held inside a database schema, it's a file-based repository.
upvoted 0 times
...
Leontine
4 months ago
B is incorrect. The ADR can be used for diagnostic information for other Oracle products, not just the database.
upvoted 0 times
...
Aaron
4 months ago
A, D, and E are correct. The ADR is a file-based repository, can be used for problem diagnosis even when the database is down, and the location is specified in the DIAGNOSTIC_DEST parameter.
upvoted 0 times
...
Brandon
4 months ago
I vaguely remember that ADR can help diagnose issues even when the database is down, so D might be correct.
upvoted 0 times
...
Cyril
4 months ago
I feel like ADR is used for more than just Oracle database diagnostics, but I can't recall the specifics.
upvoted 0 times
...
Trevor
5 months ago
I think option E is definitely true since the DIAGNOSTIC_DEST parameter is often mentioned in practice questions.
upvoted 0 times
...
Ty
5 months ago
I remember that ADR is related to diagnostics, but I'm not sure if it's file-based or schema-based.
upvoted 0 times
...
Son
5 months ago
The DIAGNOSTIC_DEST parameter is the clue I need to figure out where the ADR is held. I just need to double-check the other details.
upvoted 0 times
...
Fidelia
5 months ago
This is a good opportunity to demonstrate my knowledge of Oracle database diagnostics. I'm confident I can identify the three true statements.
upvoted 0 times
...
Annelle
5 months ago
Okay, I think I've got a handle on this. The key is to focus on the specific statements about the ADR's location and usage.
upvoted 0 times
...
Coral
5 months ago
What about D? It helps when the instance is down.
upvoted 0 times
...
Mireya
6 months ago
Yeah, I agree. A makes sense.
upvoted 0 times
...
Sunshine
6 months ago
Wait, so the ADR is like a secret file club for Oracle products? Sounds like a cool club to be a part of.
upvoted 0 times
...
Deonna
6 months ago
I think A is true. It's file-based, right?
upvoted 0 times
...
Joanna
6 months ago
Hmm, I'm a bit confused about where exactly the ADR is stored. Is it inside or outside the database?
upvoted 0 times
...
Maynard
7 months ago
This question seems straightforward, but I want to make sure I understand the key details about ADR before answering.
upvoted 0 times
Blossom
1 month ago
Right, C is definitely false. It's not inside a schema.
upvoted 0 times
...
Twana
1 month ago
B is misleading; ADR can be broader than that.
upvoted 0 times
...
Sharika
1 month ago
What about B? Isn't it just for Oracle databases?
upvoted 0 times
...
Talia
2 months ago
Agreed, but D is also a key point.
upvoted 0 times
...
Jenifer
6 months ago
I think A and E are definitely true.
upvoted 0 times
...
...

Save Cancel