單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

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？（）

A.perform pointintime recovery
B.perform a Flashback Table operation to restore the table to the state it was in two days ago
C.perform a Flashback Database operation to restore the database to the state it was in two days ago
D.perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

單項(xiàng)選擇題

Why would you use the following FLASHBACK TABLE command？（）
FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）;

A.to undo the changes made to the EMP table since the specified time
B.to restore the EMP table that was wrongly dropped from the database
C.to view the transactions that have modified the EMP table since the specified time
D.to view the changes made to the EMP table for one or more rows since the specified time
E.to recover the EMP table to a point in time in the past by restoring the most recent backup

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

你可能感興趣的試題

Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）;

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

Why would you use the following FLASHBACK TABLE command？（）
FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）;