New Features for Administrators - Question 027

Which two are true regarding the Automatic Undo Management feature? (Choose two).

A. PMON is responsible for shrinking undo segments as needed.

B. SMON is responsible for shrinking undo segments as needed.

C. To use this feature, you must create undo segments into an undo tablespace.

D. Oracle9i automatically creates a fixed number of undo segments per undo tablespace.

E. In a Real Application Clusters environment, you must create one undo tablespace per opened instance.

Answer: B, D

Explanation:

If you are using the Automatic Undo Management feature, SMON is responsible for shrinking undo segments as needed and Oracle9i automatically creates a fixed number of undo segments per undo tablespace.

Incorrect Answers

A: SMON, not PMON background process, is responsible for shrinking undo segments as needed.

C: You have not to create undo segments into an undo tablespace: it will be done by Oracle automatically.

E: You don’t have to create one undo tablespace per open instance in a Real Application Clusters environment.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 160-164

Chapter 3: Manageability Enhancements

Oracle 9i New Features, Robert Freeman, p. 19-25

Chapter 1: Oracle9i Database Administration and Management Features