Oracle 11G OCP 1Z0-053 666

（666）You are working in an online transaction processing（OLTP）environment.

You use 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.Now,you need to reverse the effects of the FLASHBACK TABLE command.

Which is the fastest and the most efficient option to reverse the effects of the LASHBACK TABLE command?

A. Restore the backup control file and open the database with RESETLOGS option.

B. Perform point-in-time recovery because flashback cannot be performed again on this table

C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

答案：（D）

解析：

（题目要求最快的最有效率的方法闪回表到之前的某个状态，由于之前已经闪回过了，这一次只要把某个部分的内容给补上就行了，所以只要执行另外的flashback table命令然后加上scn 663571选项即可，但是会报错unable to read data-table definition has changed）

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1339752/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1339752/