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 *