Prev Question
Next Question

When is the UNDO_RETENTION parameter value ignored by a transaction?

A.
when there are multiple undo tablespaces available in a database

B.
when the data file of the undo tablespace is autoextensible

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

D.
when Flashback Database is enabled

Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)

Prev Question
Next Question

Leave a Reply

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