1Z0-182 practice - PrepKeys

Q5 Single choice

An undo tablespace has AUTOEXTEND disabled, UNDO_RETENTION set, and RETENTION GUARANTEE enabled. The tablespace fills with uncommitted undo. What happens when the next transaction attempts an update?

A
The update succeeds and the generated undo is stored in SYSTEM.
B
The update fails because the undo tablespace cannot be extended.
C
The update succeeds by overwriting the least recently written undo block.
D
The update succeeds and the generated undo is stored in SYSAUX.
E
The update succeeds by overwriting the least recently read undo block.