单选题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
题目
单选题
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.
相似考题
参考答案和解析
正确答案：
C
解析：
暂无解析