Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

Which method would you use to undo the changes made by a particular transaction without
affecting the changes made by other transactions?

Which method would you use to undo the changes made by a particular transaction without
affecting the changes made by other transactions?

A.
manually enter the appropriate data again

B.
flashback the database to before the transaction was committed

C.
determine all the necessary undo SQL statements from
FLASHBACK_TRANSACTION_QUERY and use them for recovery

D.
point-in-time recovery

E.
execute the ROLLBACK command with transaction number



Leave a Reply 0

Your email address will not be published. Required fields are marked *