Oracle Database 11g: Administration I — Question 5

Which two are true about transactions, UNDO segments, and UNDO tablespaces? (Choose two.)

Answer options

• A. UNDO segments grow or shrink automatically
• B. UNDO tablespaces are created and dropped automatically
• C. UNDO segments are created and dropped automatically
• D. UNDO tablespaces are brought ONLINE or OFFLINE as required
• E. All transactions belonging to a single session use the same UNDO segment

Correct answer: A, B

Explanation

Option A is correct because UNDO segments do adjust their size based on the needs of the transactions. Option B is also accurate as UNDO tablespaces are managed by the database and can be created or dropped without manual intervention. Options C, D, and E are incorrect as UNDO segments are not automatically created or dropped, the ONLINE or OFFLINE state of tablespaces is not automatically managed, and individual sessions may use different UNDO segments.