CE read this:
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/diagnosing-repairing-failures-dra.html#GUID-636EA9BE-2DFB-4FA0-959E-B1290C774ABD
A is NOT correct - DB can be even NOT MOUNTED.
B is NOT correct - you can close it whenever you want, eventually new check will find the failure again.
C has to be CORRECT despite it is not fully clear, anyway Recovery Advisor can be used when database is even NOT mounted, hence it is CLOSED while instance is STARTED.
D is NOT correct because of ONLY word. Change Failure can CLOSE or CHANGE PRIORITY.
E is CORRECT - Data Recovery Advisor can potentially detect, analyze, and repair data failures BEFORE a database process discovers the corruption and signals an error. Early warnings help limit damage caused by corruption.
The health assessment is known as a data integrity check and can be invoked reactively or PROACTIVELY.
Why is E true? I think it is False:
"Failures are normally detected reactively. A database operation involving corrupted data results in an error, which automatically invokes a data integrity check that searches the database for failures related to the error. If failures are diagnosed, then they are recorded in the Automatic Diagnostic Repository (ADR), which is a directory structure stored outside of the database. You can use Data Recovery Advisor to generate repair advice and repair failures only after failures have been detected by the database and stored in ADR. "
(https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/diagnosing-repairing-failures-dra.html)
... And in this situation, the only valid answer is C, that's why ssseee's comment makes a lot of sense
D is incorrect due to only word:
The CHANGE FAILURE command changes the failure priority or closes one or more failures. You can change a failure priority only for HIGH or LOW priorities. Open failures are closed implicitly when a failure is repaired. However, you can also explicitly close a failure.
D is wrong...quote from your link:
You can use CHANGE FAILURE to change the status of an open failure to CLOSED if you have fixed it manually. However, it makes sense to use CHANGE FAILURE ... CLOSED only if for some reason the failure was not closed automatically. If a failure still exists when you use CHANGE to close it manually, then Data Recover Advisor re-creates it with a different failure ID when the appropriate data integrity check is executed.
D is incorrect as CHANE FAILURE command is used both for changing priorities and changing status of the failure. "only" word in the statement makes it false.
C & E are definitely correct.
change failure can be used to close a failure, does it count as a priority cahnge? or option D can be discarted?
option B i think is incorrect because you can close a failure even if you haven't solved it
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ald85
Highly Voted 4 years, 1 month agomonad2006
4 years, 1 month agojanw
Highly Voted 3 years, 11 months agodancymonkey
Most Recent 6 months, 2 weeks ago_gio_
1 year, 1 month agovkra
1 year, 5 months agoObserverPL
3 years, 2 months agoRogazan
3 years, 2 months agossseee
3 years, 3 months agoJatindra
3 years, 4 months agogon20
3 years, 6 months agoproact
3 years, 9 months agoSchmeili
3 years, 8 months agosenator
3 years, 11 months agotaotsumiau
4 years agonavingupta52
3 years, 1 month agojulica
3 years, 12 months agoveginha
4 years, 1 month ago