Which two statements are true regarding undo tablespaces?

Which two statements are true regarding undo tablespaces? (Choose two.)

Question:

Which two statements are true regarding undo tablespaces?

Options:

The database can have more than one undo tablespace

The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management

Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions

An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up

Correct Answer

The Correct Answer for this Question is

The database can have more than one undo tablespace
Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *