Oracle 11G 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.

答案：（B）

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1250890/，如需轉載，請註明出處，否則將追究法律責任。