oracle · 1z0-082 · Q605 · multiple_response · topic_1

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

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.

Explanation

When an undo tablespace is created, the corresponding undo segments are created as well. The ownership of the undo segments is then given to the user who creates the undo tablespace. Therefore, the ownership of the undo segments belongs to the user, not to the SYS or SYSTEM user. so the correct answer are D and E

Reference: examtopics_top_comment

Practice with progress tracking

Start tracked practice Pricing