1Z0-067 · Question #27
In which situation can you use Flashback Database?
The correct answer is D. when returning to a point in time before the most recent open resetlogs operation. TO BEFORE RESETLOGS Returns the database to its state including all changes up to the SCN of the most recent OPEN RESETLOGS. Note: FLASHBACK DATABASE can only return the database to a point before the most recent OPEN RESETLOGS operation if your database has been upgraded to…
Question
In which situation can you use Flashback Database?
Options
- Awhen undoing a shrink data file operation
- Bwhen retrieving a dropped tablespace
- Cwhen returning to a point in time before the restoration or re-creation of a control file
- Dwhen returning to a point in time before the most recent open resetlogs operation
How the community answered
(28 responses)- A14% (4)
- B4% (1)
- C7% (2)
- D75% (21)
Explanation
TO BEFORE RESETLOGS Returns the database to its state including all changes up to the SCN of the most recent OPEN RESETLOGS. Note: FLASHBACK DATABASE can only return the database to a point before the most recent OPEN RESETLOGS operation if your database has been upgraded to Oracle Database 10g Release 2 or later.
Topics
Community Discussion
No community discussion yet for this question.