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 *