New Features for Administrators - Question 010

What is true regarding a transaction executed in Automatic Undo Management mode?

A. It is possible for the transaction to span different undo segments.

B. It is possible for the transaction to reuse inactive extents from another undo segment.

C. It is possible for the transaction to use inactive extents from another undo tablespace.

D. It is possible for the transaction to extend the undo tablespace, even if defined with AUTOEXTENSIBLE set to FALSE.

Answer: B

Explanation:

It is possible for the transaction to reuse inactive extents from another undo segment in Automatic Undo Management mode.

Incorrect Answers

A: It is not possible for the transaction to span different undo segments. It can be assigned only to the one undo segment.

C: It is not possible for the transaction to use inactive extents from another undo tablespace. It can only REUSE inactive extents from another undo segment, not from another undo tablespace.

D: It’s not possible for the transaction to extend the undo tablespace, if defined with AUTOEXTENSIBLE set to FALSE.

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

Chapter 3: Manageability Enhancements

Oracle 9i New Features, Robert Freeman, p. 53-54

Chapter 2: Oracle9i Architecture Changes