Which three statements are true about Flashback Database?

Question

Options

• AFlashback logs are written sequentially, and are archived.
• BFlashback Database uses a restored control file to recover a database.
• CThe Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
• DFlashback Database can recover a database to the state that it was in before a reset logs operation.
• EFlashback Database can recover a data file that was dropped during the span of time of the flashback.
• FFlashback logs are used to restore to the blocks' before images, and then the redo data may be used to

• A
  3% (1)
• B
  8% (3)
• C
  84% (32)
• E
  5% (2)

Explanation

Oracle-generated logs used to perform flashback database operations. The database can only write flashback logs to the fast recovery area. Flashback logs are written sequentially and are not archived. They cannot be backed up to disk. If the database control file is restored from backup or re-created, all accumulated flashback log information is discarded. You cannot use FLASHBACK DATABASE to return to a point in time before the restore or re-creation of a control file. Flashback Database can only undo changes to a data file made by Oracle Database. It cannot be used to repair media failures, or to recover from accidental deletion of data files.

No community discussion yet for this question.