Oracle Database Administration II — Question 37

Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)

Answer options

• A. Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.
• B. A failure can be closed only when it has been repaired.
• C. Data Recovery Advisor can be used if a database is closed.
• D. The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.
• E. Data Recovery Advisor can proactively check for failures.

Correct answer: D, E

Explanation

The correct answers are D and E. Option D is accurate because the CHANGE FAILURE command is specifically designed to adjust failure priorities. Option E is also true, as Data Recovery Advisor can perform proactive checks for failures, enhancing the database's reliability. Options A, B, and C are incorrect as they either misstate the requirements for the LIST FAILURE command, incorrect closure criteria for failures, or the usage constraints regarding closed databases.