Oracle
1Z0-082 · Question #106
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. E. Only incremental backups can be used to roll forward the database while performing complete. See the full explanation below for the reasoning.
Perform Backup and Recovery
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
How the community answered
(40 responses)- A78% (31)
- B5% (2)
- C5% (2)
- D13% (5)
Topics
#complete recovery#incomplete recovery#uncommitted transactions#incremental backups
Community Discussion
No community discussion yet for this question.