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.
point-in-time recovery

B.
execute the ROLLBACK command with transaction number

C.
flashback the database to before the transaction was committed

D.
Determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery



Leave a Reply 0

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