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.
determine all the necessary undo SQL statements from
FLASHBACK_TRANSACTION_QUERY and use them for recovery

B.
flashback the database to before the transaction was committed

C.
point-in-time recovery

D.
execute the ROLLBACK command with transaction number



Leave a Reply 0

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