Oracle Database Administration I — Question 108

Which two statements are true about UNDO and UNDO tablespaces? (Choose two.)

Answer options

• A. There can be only one UNDO tablespace created in a database.
• B. UNDO segments are owned by SYSTEM.
• C. UNDO segments are owned by SYSBACKUP.
• D. An UNDO tablespace may be owned by only one instance.
• E. An instance will crash if the active undo tablespace is lost.

Correct answer: D, E

Explanation

Option D is correct because an UNDO tablespace can only be associated with a single instance at a time. Option E is also correct, as losing the active undo tablespace can lead to an instance crash due to the inability to manage transactions properly. Options A, B, and C are incorrect because multiple UNDO tablespaces can exist, UNDO segments are not owned by SYSTEM or SYSBACKUP specifically.