QUESTION 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.
Correct Answer: B
你发现你的回收站中包含两个同名的表,my_table。你也
有一个表在您的架构命名my_table。你执行以下语句:
FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2
B. 表是从回收站中使用后进先出(LIFO)的方法 恢复。