单选题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？（）A You can restore the DEPT

题目内容(请给出正确答案)

单选题

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

You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.

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.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

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

点击查看答案
第2题

单选题You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday. How will you recover the dropped table， SCOTT.EMPLOYEE？（）Aby using the Flashback Table featureBby using the Flashback Database featureCby performing incomplete recovery using RMAN utilityDby performing incomplete recovery using user-managed recovery

点击查看答案
第3题

单选题Which describes the default behavior when you create a table? （）A The table is accessible to all users.B Tables are created in the public schema.C Tables are created in your schema.D Tables are created in the DBA schema.E You must specify the schema when the table is created.

点击查看答案
第4题

单选题You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database. What should you do？（）A Implement a stored procedure that writes data about schema changes to a log table.B Implement DDL AFTER triggers that write user and schema information to a log table.C Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.D Implement a DML AFTER trigger that writes data about schema changes to a log 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题

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

点击查看答案
第7题

单选题Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）A DROP emp_dept_uv;B DELETE emp_dept_uv;C REMOVE emp_dept_uv;D DROP VIEW emp_dept_uv;E DELETE VIEW emp_dept_uv;F REMOVE VIEW emp_dept_uv;

点击查看答案

On Monday， you dropped the DEPT table from your schema and t

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容