Oracle
1Z0-067 · Question #200
Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start? Choose the best answer.
The correct answer is E. from the last complete checkpoint position. See the full explanation below for the reasoning.
Question
Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start? Choose the best answer.
Options
- Afrom the most recent incremental checkpoint
- Bfrom the beginning of the current redo log file to the checkpoint position
- Cfrom the last committed transaction
- Dfrom the beginning of the current redo log file until the instance failure
- Efrom the last complete checkpoint position
How the community answered
(15 responses)- C7% (1)
- D7% (1)
- E87% (13)
Community Discussion
No community discussion yet for this question.