New Features for Administrators - Question 036

When enabling Flashback using a wall-clock time, within what period does the database choose a System Commit Number (SCN)?

A. One minute of the time specified

B. One second of the time specified

C. Five minutes of the time specified

D. Five seconds of the time specified

Answer: C

Explanation:

The database chooses a System Commit Number within a five minutes of the time specified.

Incorrect Answers

A: It chooses a SCN within a five, not one minute, of the time specified.

B: The database does not choose a System Commit Number within an one second of the time specified.

D: The database chooses a System Commit Number within a five minutes of the time specified, not 5 seconds.

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

Chapter 2: Availability Enhancements

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

Chapter 3: New Oracle9i Availability and Recoverability Features