In the ORCL database, UNDOTBS1 is the active undo tablespace with a fixed size of 70 MB and RETENTION GUARANTEE.
UNDO_RETENTION is set to 15 minutes and the tablespace does not have AUTOEXTEND on.
Which statement is true about a transaction if UNDOTBS1 fills with uncommitted undo within 10 minutes of the transaction’s first update?
A. It succeeds and the generated undo is stored in SYSAUX.
B. It succeeds and the generated undo is stored in TEMP.
C. It fails and returns the error message “Snapshot too old”.
D. It succeeds and the generated undo is stored in SYSTEM.
E. It fails and returns the error message “ORA=30036″: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1′”.
F. It succeeds and the least recently used undo block UNDOTBS1 is overwritten by the generated undo.
|
Download Printable PDF. VALID exam to help you PASS. |
 |