Which statement is true regarding undo tablespace?
Question:
Which statement is true regarding undo tablespace?
Options:
Undo tablespace is a temporary tablespace.
Only one undo tablespace can exist in a database.
Undo tablespace can consist of only one data file that is reused in a cyclic fashion.
Multiple undo tablespace can exist in a database but only one can be active at a time.
Correct Answer
The Correct Answer for this Question is
Multiple undo tablespace can exist in a database but only one can be active at a time.