Multiple choice technology databases

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 future? (Choose three)

  1. Guarantee undo retention

  2. Add one more redo log group.

  3. Configure an appropriate undo retention interval.

  4. Size the UNDO tablespace appropriately.

  5. Size the SYSTEM tablespace appropriately.
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

To prevent 'ORA-01555: snapshot too old' errors, you should size the UNDO tablespace appropriately, configure an adequate undo retention interval, and guarantee undo retention to prevent active undo data from being overwritten.

Keep practicing — related questions