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.
flashback the database to before the transaction was committed

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

C.
point-in-time recovery

D.
execute the ROLLBACK command with transaction number

E.
manually enter the appropriate data again

Explanation:



Leave a Reply 0

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