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.
Explanation:
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 to the Recycle Bin most recently is recovered first using a LIFO algorithm. In this scenario, you also included a 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.