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 Version Query only.
D. Flashback Database and Flashback Transaction Query.
E. Flashback Version Query and Flashback Transaction Query.

相关考题

多项选择题 Inyourproductiondatabase,youhavemultipleresourceplandirectivesthatrefertothecustomergroupDB_GRP.Whichtwostatementsarecorrect?()

单项选择题 Becauseofhardwarefailure,youdecidedtodroparedologmemberfromthedatabase.Whichconditionshouldbemettodroparedologfile?()

单项选择题 You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that:  a) No other user data in the database is affected.  b) The operation takes the minimum possible time.  Which option would you choose?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064