试题详情
单项选择题 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
  • 关注下方微信公众号,在线模考后查看

热门试题