OCP-1Z0-053-200题-90题-666

QUESTION 90

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 flashingback 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 FLASHBACK 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

Answer: D

同666题：http://blog.csdn.net/rlhua/article/details/12425205

Explanation/Reference:

Section: Flashback Operations & Configuration

Undoing a Flashback Table Operation

It is important to note your current SCN before using a Flashback Table operation.

Use the FLASHBACK TABLE statement again to go back to just before you were when you issued the first

statement.