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.
答案：（B）