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

C.
Execute the ROLLBACK command with transaction number

D.
Flashback the database to before the transaction was committed



Leave a Reply 0

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