Oracle Database Administration II — Question 84

Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)

Answer options

• A. The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.
• B. The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.
• C. Flashback commands help with repairing physical errors.
• D. RMAN can always repair corrupt blocks.
• E. The ADR can store metadata in an Oracle Database repository.
• F. The Data Recovery Advisor uses the ADR.

Correct answer: A, B, F

Explanation

The correct answers A, B, and F accurately describe the functionalities of the ADRCI, ADR, and Data Recovery Advisor in diagnosing Oracle Database failures. Options C and D are incorrect because Flashback commands primarily help in logical data recovery rather than physical errors, and RMAN cannot guarantee the repair of all corrupt blocks. Option E is also incorrect as it doesn't accurately represent the ADR's metadata handling capabilities.