Youareworkingonanonlinetransactionprocessing(OLTP)system.YounoticethataPL/SQLproceduregotexecutedtwiceat2)00p.m.ThishasincorrectlyupdatedtheEMP_SALtable.Howwouldyourevertthetabletoitsstateat2)00p.m.?()
A.Performpoint-in-timerecoveryto2:00p.m.
B.UseFlashbackTablefeaturetorevertthechanges.
C.Restoretheentiredatabasefromtherecentbackupandopenit.
D.Issuetherollbackstatementwithsystemchangenumber(SCN).
正确答案:参考B



