Oracle Database 12c: Advanced Administration — Question 144

One of the four database suffered an instance failure.
At the next startup, from which point in the redo logs does instance recovery begin?

Answer options

• A. from a point corresponding to the most recent successful transaction commit
• B. from a point corresponding to the most recent log instance checkpoint
• C. from a point corresponding to the most recent incremental checkpoint
• D. from a point corresponding to the most recent checkpoint of any kind
• E. from a point corresponding to the most recent log switch checkpoint

Correct answer: A

Explanation

The correct answer is A because instance recovery begins from the last successful transaction commit to ensure all committed changes are applied. The other options, while related to checkpoints and logs, do not guarantee that all successful transactions are accounted for during recovery.