Oracle Exam 1Z0-083 Topic 7 Question 73 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 73
Topic #: 7

Which two are true about Oracle instance recovery? (Choose three.)

ARecovery begins from the beginning of the CURRENT redo log group.

BRecovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

CRecovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.

DRecovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.

ERecovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

FRecovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Show Suggested Answer

Suggested Answer: A

by Cecily at Apr 03, 2023, 12:27 PM

Limited Time Offer

25%

24 days ago

I think option B is true because the checkpoint position is crucial for recovery.

upvoted 0 times

...