|
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: 3: 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. 4: Oracle Flashback does not list the DML that was executed during the period you identify when initiating your session. Reference: 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
|