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.
Restore the entire database from the recent backup and open it.

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

D.
Use Flashback Table feature to revert the changes.



Leave a Reply 0

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