Upgrade to Oracle Database 12c — Question 36

The current system change number (SCN) for a live database is 663571.
You decide to use the FLASHBACK TABLE statement to flash back the CUSTOMERS table to SCN 662116.
After flashing back the CUSTOMERS table, you query it and decide to undo the effects of the FLASHBACK TABLE command.
Which is the fastest way to do this?

Answer options

• A. Execute the RMAN RECOVER BLOCK command by specifying the table name and SCN 663571 because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.
• B. Execute another FLASHBACK TABLE statement to restore the CUSTOMERS table to SCN 663571.
• C. Perform table point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.
• D. Perform tablespace point-in-time recovery because FLASHBACK TABLE cannot be performed on a table that has already been flashed back.

Correct answer: B

Explanation

The correct answer is B because issuing another FLASHBACK TABLE command allows you to restore the CUSTOMERS table to its state at SCN 663571 quickly. Options A, C, and D are incorrect because they suggest methods that are not necessary or applicable after a FLASHBACK TABLE operation has been conducted; only a subsequent FLASHBACK TABLE can revert the table to its previous state.