What will be the result of executing this statement?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *