单选题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
题目
单选题
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).
相似考题