Oracle
1Z0-072 · Question #43
Which two are true about complete and incomplete recovery? (Choose two.)
The correct answer is A. Uncommitted transactions will be rolled back after complete recovery completes. See the full explanation below for the reasoning.
Question
Which two are true about complete and incomplete recovery? (Choose two.)
Options
- AUncommitted transactions will be rolled back after complete recovery completes.
- BThe database must have FLASHBACK enabled in order to perform incomplete recovery.
- CUncommitted transactions will be rolled back after incomplete recovery completes.
- DIncomplete recovery is possible only when the database is open.
- EOnly incremental backups can be used to roll forward the database while performing complete recovery.
How the community answered
(24 responses)- A71% (17)
- C8% (2)
- D17% (4)
- E4% (1)
Community Discussion
No community discussion yet for this question.