When is the UNDO_RETENTIGIl parameter value ignored by a transaction?

When is the UNDO_RETENTIGIl parameter value ignored by a transaction?References: https://docs.oracle.com/cd/B19306_01 /server.102/bl4231/undo.htm(undo retention)

Question:

When is the UNDO_RETENTIGIl parameter value ignored by a transaction?

Options:

when there are multiple undo tablespaces available in a database

when the data file of the undo tablespace is autoextensible

when the undo tablespace is of a fixed size and retention guarantee is not enabled

when Flashback Database is enabled

Correct Answer

The Correct Answer for this Question is

when the undo tablespace is of a fixed size and retention guarantee is not enabled

Leave a Comment