• Description: Administration I
• Passing Score: 0%
• Practice Test - Number of questions: 144 questions
• Simulation Test - Number of questions: 144 questions
• Simulation Test Duration: 120 minutes
• Has explanations: No

Which two statements are true regarding undo tablespaces? (Choose two.)

Answer(s)

1. The database can have more than one undo tablespace.
2. The UNDO_TABLESPACE parameter is valid in both automatic and manual undomanagement.
3. Undo segments automatically grow and shrink as needed, acting as circular storage buffer fortheir assigned transactions.
4. An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not setand the UNDO_MANAGEMENT parameter is set to AUTO during the database instance startup.

The database can have more than one undo tablespace.

Undo segments automatically grow and shrink as needed, acting as circular storage buffer fortheir assigned transactions.