Which two statements are true about UNDO and UNDO tablespaces? (Choose two.)
Which two statements are true about UNDO and UNDO tablespaces? (Choose two.)
An UNDO tablespace may be owned by only one instance, making the option about single ownership correct. Additionally, if the active undo tablespace is lost, the instance will crash because the undo information is critical for the recovery and consistency of transactions in the database. Therefore, these two statements about UNDO and UNDO tablespaces are true.
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
I know that Undo segment is owned by SYS user, not SYSTEM. B - false
D and E are the correct answers
A-FALSE:In a database there can be more than one undo tablespace created, but only one will be active at that time B-FALSE: There is no system user, there is a sys user. System is the name of a tablespace C-FASE:Undo segment is not owned by SYSBACKUP. D-TRUE E-TRUE
Agree with D and E.
D (RAC) E are correct