Oracle
1Z0-082 · Question #111
In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties: 1. A size of 100 MB 2. AUTOEXTEND is off 3. UNDO_RETENTION is set to 15 minutes 4. It has RETENTION GUARANTEE…
The correct answer is C. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the. See the full explanation below for the reasoning.
Administer Undo Data
Question
In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties: 1. A size of 100 MB 2. AUTOEXTEND is off 3. UNDO_RETENTION is set to 15 minutes 4. It has RETENTION GUARANTEE UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens. What will happen when the next update is attempted by any transaction?
Options
- AIt succeeds and the generated undo is stored in SYSTEM.
- BIt fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo
- CIt succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the
- DIt succeeds and the generated undo is stored in SYSAUX.
- EIt succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated
How the community answered
(61 responses)- A2% (1)
- B3% (2)
- C77% (47)
- D7% (4)
- E11% (7)
Topics
#undo tablespace#RETENTION GUARANTEE#AUTOEXTEND#undo retention
Community Discussion
No community discussion yet for this question.