How would you revert the table to its state at 2:00 p.m.?

You are working on an online transaction processing (OLTP) system. You notice that a PL/SQL procedure got executed twice at 2:00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2:00 p.m.?

You are working on an online transaction processing (OLTP) system. You notice that a PL/SQL procedure got executed twice at 2:00 p.m. This has incorrectly updated the EMP_SAL table.

How would you revert the table to its state at 2:00 p.m.?

A.
Perform point-in-time recovery to 2:00 p.m.

B.
Issue the rollback statement with system change number (SCN).

C.
Restore the entire database from the recent backup and open it.

D.
Use Flashback Table feature to revert the changes.



Leave a Reply 0

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