OCP-1Z0-053-200题-152题-56

QUESTION 152

You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a

table named MY_TABLE in your schema.

You execute the following statement:

FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;

What will be the result of executing this statement?

A. One of the tables is recovered from the Recycle Binusing a First In First Out (FIFO) approach.

B. One of the tables is recovered from the Recycle Binusing a Last In First Out (LIFO) approach.

C. Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other

to a system-generated name.

D. None of the tables are recovered from the RecycleBin, and the statement returns an error.

Answer: B

同56题：http://blog.csdn.net/rlhua/article/details/14105935

Explanation/Reference:

Section: Flashback Operations & Configuration

One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach. If you use the

FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; statement to recover a table in a

scenario where your Recycle Bin has multiple copies of the MY_TABLE table, then only the latest copy of the

table will be recovered. The table that is moved tothe Recycle Bin most recently is recovered first using a

LIFO algorithm. In this scenario, you also includeda RENAME TO clause in your FLASHBACK TABLE

statement. Therefore, the restored table will be given the new name MY_TABLE2.

The option that states one of the tables is recovered from the Recycle Bin using a First In First Out (FIFO)

approach is incorrect because the last table moved to the Recycle Bin is flashed back. The FIFO approach is

used when you purge a table from the Recycle Bin using the PURGE TABLE statement. The oldest table

moved to the Recycle Bin is purged first.

The option that states both the tables are recovered is incorrect. Using the FLASHBACK TABLE my_table TO

BEFORE DROP RENAME TO my_table2; statement, you cannot recover both tables. Only the latest table will

be recovered.

The option that states none of the tables are recovered from the Recycle Bin is incorrect because the latest

copy of the table will be recovered from the Recycle Bin without returning any error.