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.？（）<br>A:Perform point-in-time recovery to 2： 00 p.m.<br>B:Use Flashback Table feature to revert the changes.<br>C:Restore the entire database from the recent backup and open it.<br>D:Issue the rollback statement with system change number （SCN）.

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:Use Flashback Table feature to revert the changes.
C:Restore the entire database from the recent backup and open it.
D:Issue the rollback statement with system change number （SCN）.

出自：Oracle认证

提示：
同一【IP】的非会员用户每天可免费获取10次答案

收藏本站【zk.995w.com】，下次访问不迷路

本站试题总数:【10243620】个 (题库试题定时更新)