Which statement is true regarding undo tablespace?

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.

Leave a Comment