New Features for Administrators - Question 008

You can use Oracle Flashback to look at past activity in your database.

What are two other characteristics of Oracle Flashback? (Choose two.)

A. Oracle Flashback uses undo information to construct consistent data.

B. You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.

C. You can only use an Oracle Flashback view of the data if the required records are still in the online redo log files.

D. Oracle Flashback lists the DML that was executed during the period you identify when initiating your session

Answer: A, B

Explanation:

To perform DML operations while using an Oracle Flashback image you can use a cursor. Oracle Flashback uses undo information to construct consistent data. The UNDO_RETENTION parameter must be set and the UNDO tablespace must be large enough so that undo generated during the period we want to query will not be overwritten.

Incorrect Answers

C: You can use an Oracle Flashback view of the data if the required records are in the online redo log files or there is information in the UNDO tablespace about required records.

D: Oracle Flashback does not list the DML that was executed during the period you identify when initiating your session.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 45-47

Chapter 2: Availability Enhancements

Oracle 9i New Features, Robert Freeman, p. 64-68

Chapter 3: New Oracle9i Availability and Recoverability Features