单选题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

题目

单选题

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?（）

One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.

One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.

Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.

None of the tables are recovered from the Recycle Bin, and the statement returns an error.

如果没有搜索结果，请直接联系老师获取答案。

更多相关问题

相关问题 1：

单选题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.

点击查看答案
相关问题 2：

单选题You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQL> FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）AYou must configure OMF in your database.BYou must enable block change tracking feature in your database.CYou must enable ROW MOVEMENT feature on the ORDERS table.DYou must use the Flashback Version Query before using the Flashback Table feature.

点击查看答案
相关问题 3：

单选题On Monday， you dropped the DEPT table from your schema and then you re/x7fcreated the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）A You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.B You can restore the DEPT table by using the Oracle Flashback Drop feature and a systemgenerated name will be assigned to the restored table.C You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.D You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.

点击查看答案
相关问题 4：

单选题On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）AYou cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.BYou can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.CYou cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.DYou can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

点击查看答案
相关问题 5：

单选题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.

点击查看答案
相关问题 6：

单选题Before a Flashback Table operation，you execute the following command： ALTER TABLE employees ENABLE ROW MOVEMENT； Why would you need this to be executed？（）ABecause row IDs may change during the flashback operationBBecause the object number changes after the flashback operationCBecause the rows are retrieved from the recycle bin during the flashback operationDBecause the table is moved forward and back to a temporary during the flashback opertion

点击查看答案
相关问题 7：

单选题Your Oracle Database 10g is online when you execute the following statement： SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF； What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）AThe database does not record flashback logs for MY_TABLESPACEBThe tables residing in MY_TABLESPACE are not protected by the Recycle Bin.CAll the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.DNone of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

点击查看答案

OCP 11G认证考试

单选题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

题目

更多相关问题

相关问题 1：

相关问题 2：

相关问题 3：

相关问题 4：

相关问题 5：

相关问题 6：

相关问题 7：

相关内容