Oracle
1Z0-052 · Question #56
Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee: SQL> ALTER
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #56. The question stem and answer options stay visible for context.
Managing Undo Data
Question
Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What affect would this command have on the database?
Options
- AThe extents in the undo tablespace retain data until the next full database backup
- BThe extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes
- CThe extents containing committed data in the undo tablespace are not overwritten until the instance
- DThe extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#undo retention#RETENTION GUARANTEE#undo tablespace#committed undo