Which three statements are true about the database inst…

Which three statements are true about the database instance startup after an instance failure?

Which three statements are true about the database instance startup after an instance failure?

A.
The RECO process recovers the uncommitted transactions at the next instance startup.

B.
Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

C.
Uncommitted changes are rolled back to ensure transactional consistency.

D.
The SMON process automatically performs the database recovery.

E.
Media recovery is required to complete the database recovery.

F.
Changes committed before the failure, which were not written to the data files, are re-applied.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


realDBA

realDBA

A is wrong. Reco is for distributed transactions
C. D, F

DBABOG

DBABOG

C – D – F