Youareworkingonanonlinetransactionprocessing(OLTP)system.YounoticethataPL/SQLpro
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
词条内容仅供参考,如果您需要解决具体问题
(尤其在法律、医学等领域),建议您咨询相关领域专业人士。
