Question

Which operations can be performed using the Data Recovery Ad-visor?

(a) Diagnosing data failure

(b) It is a percentage of rows in which the statistics are collected incrementally for partitions

(c) Presenting appropriate repair options

(d) Generating reports for possible causes of failure

The question was asked during an interview.

Question is from Installing Oracle Database 11g and Creating a Database in portion Oracle Database 11g Architecture Options of Oracle

Answer 1

The correct option is (a) Diagnosing data failure

Explanation: The Data Recovery Ad-visor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user’s request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).