Oracle
1Z0-063 · Question #14
Which three statements are true about the database instance startup after an instance failure?
The correct answer is A. The RECO process recovers the uncommitted transactions at the next instance startup. C. Uncommitted changes are rolled back to ensure transactional consistency. D. The SMON process automatically performs the database recovery. See the full explanation below for the reasoning.
Question
Which three statements are true about the database instance startup after an instance failure?
Options
- AThe RECO process recovers the uncommitted transactions at the next instance startup.
- BOnline redo log files and archived redo log files are required to complete the rollback stage of
- CUncommitted changes are rolled back to ensure transactional consistency.
- DThe SMON process automatically performs the database recovery.
- EMedia recovery is required to complete the database recovery.
- FChanges committed before the failure, which were not written to the data files, are reapplied.
How the community answered
(23 responses)- A83% (19)
- B4% (1)
- E9% (2)
- F4% (1)
Community Discussion
No community discussion yet for this question.