Oracle

1Z0-062 · Question #278

When is the UNDO_RETENTION parameter value ignored by a transaction?

The correct answer is C. when the undo tablespace is of a fixed size and retention guarantee is not enabled. https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)

Managing Undo Data

Question

When is the UNDO_RETENTION parameter value ignored by a transaction?

Options

Awhen there are multiple undo tablespaces available in a database
Bwhen the data file of the undo tablespace is autoextensible
Cwhen the undo tablespace is of a fixed size and retention guarantee is not enabled
Dwhen Flashback Database is enabled

How the community answered

(36 responses)

A
3% (1)
C
94% (34)
D
3% (1)

Explanation

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

Topics

#UNDO tablespace#Undo retention#Fixed-size undo#Retention guarantee

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-062 Practice