Oracle
1Z0-052 · Question #56
1Z0-052 Question #56: Real Exam Question with Answer & Explanation
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.
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.