1Z0-072 · Question #24
Which two are true about complete recovery? (Choose two.)
The correct answer is C. Uncommitted transactions will be rolled back after it completes. D. Incremental backups can be used to roll forward the database while performing it. See the full explanation below for the reasoning.
Question
Options
- AThe database must have FLASHBACK enabled in order to perform it.
- BIt is possible only when the database is in MOUNT state.
- CUncommitted transactions will be rolled back after it completes.
- DIncremental backups can be used to roll forward the database while performing it.
- EOnly RMAN backupsets can be used to restore a database as part of it.
How the community answered
(42 responses)- A2% (1)
- B5% (2)
- C86% (36)
- E7% (3)
Community Discussion
4
Yusuf A.Dec 29, 2025Saw this exact question, almost picked B, but my senior drilled C and D into me the week before, uncommitted transactions roll back and incrementals roll forward, passed first try.
Brenda K.Jan 2, 2026C and D are your two keepers here. Uncommitted transactions always get rolled back at the end of complete recovery, that is just RMAN doing its job via the undo segments, and incremental backups absolutely can be applied to roll the datafiles forward, which is exactly why incremental backup strategies exist for large databases where full restores would eat too much of your exam clock to even think about.
Orla P.Jan 4, 2026Brenda has C right but watch the wording on D, because incremental backups roll forward the datafile blocks that changed, not the redo-based roll forward you get from archived logs, so a candidate who blurs that line might pick the right answer for a fuzzy reason and get burned on a follow-up question about media recovery sequencing.
Orla P.Jan 20, 2026Got this exact question on my attempt last March and almost second-guessed C because I kept conflating complete recovery with flashback, but the rollback of uncommitted transactions is just standard instance recovery kicking in at the end, no flashback required. D held up the moment I remembered RMAN rolling forward with level 1 incrementals in a practice restore I had done the week before, so C and D it was.