black

1z0-043

单项选择题

By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： 
a） a list of changes made along with the transaction identifier of each change 
b） the necessary SQL statements to undo the erroneous changes 
Which option would you choose？（）

A.RMAN only
B.Flashback Table only
C.Flashback Versions Query only
D.Flashback Database and Flashback Transaction Query
E.Flashback Versions Query and Flashback Transaction Query

相关考题

单项选择题 You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）

单项选择题 Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）

多项选择题 YouexecutedthefollowingFLASHBACKTABLEcommand：FLASHBACKTABLEempTOTIMESTAMP（’11：45’，’hh12：mi’）Whichtwostatementsarecorrect？（）

All Rights Reserved 版权所有©PP题库网库(pptiku.com)

备案号：湘ICP备14005140号-5

经营许可证号：湘B2-20140064