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

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

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

A.
point-in-time recovery

B.
manually enter the appropriate data again

C.
execute the ROLLBACK command with transaction number

D.
flashback the database to before the transaction was committed

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



Leave a Reply 1

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


mr_tienvu

mr_tienvu

I have the same idea. E