How would you prevent such an error in the future?

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.)

A.
change automatic undo management to manual

B.
guarantee undo retention

C.
add one more redo log group

D.
size the redo log files appropriately

E.
size the UNDO tablespace appropriately

F.
size the SYSTEM tablespace appropriately

G.
configure an appropriate undo retention interval