Oracle Exam 1Z0-082 Topic 13 Question 32 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 32
Topic #: 13

[All 1Z0-082 Questions]

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?

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 tablespace 'UNDOTBS1'''.

CIt succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

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 undo.

Show Suggested Answer

Suggested Answer: B

To guarantee the success of long-running queries or Oracle Flashback operations, you can enable retention guarantee. If retention guarantee is enabled, the specified minimum undo retention is guaranteed; the database never overwrites unexpired undo data even if it means that transactions fail due to lack of space in the undo tablespace. If retention guarantee is not enabled, the database can overwrite unexpired undo when space is low, thus lowering the undo retention for the system. This option is disabled by default.

by Ilene at May 09, 2022, 09:14 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!