Oracle
1Z0-052 · Question #227
You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value?
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #227. The question stem and answer options stay visible for context.
Managing Undo Data
Question
You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value?
Options
- Aby executing the ALTER SYSTEM .. command
- Bby re-creating the control file with a new value for UNDO_RETENTION
- Cby executing the ALTER DATABASE.. command in the MOUNT state
- Dby executing UPDATE.. statement on V$PARAMETER to change the value of
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#ALTER SYSTEM#undo management#read consistency