OCP 1Z0 053 56

56.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 Bin using a First In First Out (FIFO) approach. 
B. One of the tables is recovered from the Recycle Bin using 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 Recycle Bin, and the statement returns an error. 
Answer: B

闪回被删除的表，用后进先出的顺序


http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmflash.htm#BRADV344

The most recently dropped table with this original name is retrieved from the recycle bin, with its original name. Example 18-2shows the retrieval from the recycle bin of all three dropped temp_employees tables from the previous example, with each assigned a new name.

Example 18-2 Renaming Dropped Tables

FLASHBACK TABLE temp_employees TO BEFORE DROP   RENAME TO temp_employees_VERSION_3;FLASHBACK TABLE temp_employees TO BEFORE DROP   RENAME TO temp_employees_VERSION_2;FLASHBACK TABLE temp_employees TO BEFORE DROP   RENAME TO temp_employees_VERSION_1;

Because the original name in FLASHBACK TABLE refers to the most recently dropped table with this name, the last table dropped is the first retrieved.