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

题目

单选题

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 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 can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

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.

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.

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

相似问题和答案

第1题：

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()

A. You cannot roll back this statement.

B. All pending transactions are committed.

C. All views based on the DEPT table are deleted.

D. All indexes based on the DEPT table are dropped.

E. All data in the table is deleted, and the table structure is also deleted.

F. All data in the table is deleted, but the structure of the table is retained.

G. All synonyms based on the DEPT table are deleted.

参考答案：A, B, D, E

第2题：

In which scenario do you use the Flashback Database feature？（）

A、 when a table is dropped and you restore it from the Recycle Bin
B、 when a user’s schema is dropped and you recover the user’s schema
C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

正确答案:B

第3题：

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?（）

A. It retrieves the latest version of the table from the recycle bin

B. It retrieves the oldest version of the table from the recycle bin

C. It retrieves the version of the table for which undo information is available

D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

参考答案：A

第4题：

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement?（）

A、You cannot roll back this statement.
B、All pending transactions are committed.
C、All views based on the DEPT table are deleted.
D、All indexes based on the DEPT table are dropped.
E、All data in the table is deleted, and the table structure is also deleted.
F、All data in the table is deleted, but the structure of the table is retained.
G、All synonyms based on the DEPT table are deleted.

正确答案:A,B,D,E

第5题：

Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

A、It releases the storage space used by the table.
B、It does not release the storage space used by the table.
C、You can roll back the deletion of rows after the statement executes.
D、You can NOT roll back the deletion of rows after the statement executes.
E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

正确答案:A,D,F

第6题：

A、 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.
B、 You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
C、 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.
D、 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.

正确答案:B

第7题：

In which scenario will you use the Flashback Transaction Query feature？（）

A、 when you want to restore an important table that is dropped from the Recycle Bin
B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
C、when you want to restore a dropped user’s schema
D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

正确答案:B

第8题：

Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? ()

A. It releases the storage space used by the table.

B. It does not release the storage space used by the table.

C. You can roll back the deletion of rows after the statement executes.

D. You can NOT roll back the deletion of rows after the statement executes.

E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

参考答案：B, D, F

第9题：

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

第10题：

The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（）

A、You obtain the results retrieved from the public synonym HR created by the database administrator.
B、You obtain the results retrieved from the HR table that belongs to your schema.
C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

正确答案:B

单选题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 cannot restore the DE

题目

相似问题和答案

更多相关问题

相关内容