Oracle Database 11g: Administration I — Question 17

Which two are true about undo tablespaces? (Choose two.)

Answer options

• A. They must have only one data file
• B. Single instance databases can have only one active undo tablespace
• C. They always retain undo for the time period defined by UNDO_RETENTION
• D. They can be recovered only when an instance is in MOUNT state
• E. Tables can be created in undo tablespaces by SYS

Correct answer: C, E

Explanation

Option C is correct because undo tablespaces are designed to hold undo data for the duration specified by the UNDO_RETENTION parameter. Option E is also correct as SYS has the privileges to create tables in these spaces. Options A, B, and D are incorrect as they misrepresent the characteristics and functionalities of undo tablespaces.