Oracle
1Z0-052 · Question #216
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you preve
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #216. The question stem and answer options stay visible for context.
Managing Undo Data
Question
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error:
ORA-01555: snapshot too old How would you prevent such an error in the future? (Choose three.)
Options
- Aguarantee undo retention
- Badd one more redo log group
- Csize the redo log files appropriately
- Dsize the UNDO tablespace appropriately
- Esize the SYSTEM tablespace appropriately
- Fconfigure an appropriate undo retention interval
- Gchange automatic undo management to manual
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
#ORA-01555#undo retention#snapshot too old#undo tablespace sizing