单选题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 can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.BYou can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.CYou cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.DYou 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.
单选题
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 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 system-generated 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 with the 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.
参考解析
解析：
暂无解析
相关考题：
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?() A. All the related indexes and views are automatically droppedB. The flashback drop feature can recover only the table structureC. Only the related indexes are dropped whereas views are invalidatedD. The flashback drop feature can recover both the table structure and its data
Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? () A. An error is generated.B. You will have two identical tables in the HR schema with different names.C. You create a table called employees in the HR schema based on you EMP table.D. You create an alternative name for the employees table in the HR schema in your own schema.
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 binB. It retrieves the oldest version of the table from the recycle binC. It retrieves the version of the table for which undo information is availableD. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
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.
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;
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.
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;
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.
In which scenario do you use the Flashback Database feature？（）A、 when a table is dropped and you restore it from the Recycle BinB、 when a user’s schema is dropped and you recover the user’s schemaC、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
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 BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 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
In which scenario will you perform a user-managed incomplete recovery？（）A、 when a table is dropped and stored in the Recycle BinB、when a table is dropped and purged from the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when you are required to view all the versions of a row of an existing table between a specific time period
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）A、 To recover a dropped table.B、 To recover a dropped schema.C、 To recover data from a truncated table.D、 To view changes made by all the transactions during a given period of time.E、 To view changes made by a single transaction during a given period of time.
The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）A、 All the related indexes and views are automatically droppedB、 The flashback drop feature can recover only the table structureC、 Only the related indexes are dropped whereas views are invalidatedD、 The flashback drop feature can recover both the table structure and its data
In which scenario will you use the Flashback Version Query feature？（）A、 when you want to restore a table that has been dropped from the Recycle BinB、 when you want to identify the transaction ID of the transaction that deleted some important records from a tableC、 when you want to recover the schema of a dropped userD、when you want to restore a dropped tablespace
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.
单选题In which scenario do you use the Flashback Database feature？（）A when a table is dropped and you restore it from the Recycle BinB when a user’s schema is dropped and you recover the user’s schemaC when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
单选题In which scenario will you use the Flashback Version Query feature？（）A when you want to restore a table that has been dropped from the Recycle BinB when you want to identify the transaction ID of the transaction that deleted some important records from a tableC when you want to recover the schema of a dropped userDwhen you want to restore a dropped tablespace
多选题You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）ATo recover a dropped table.BTo recover a dropped schema.CTo recover data from a truncated table.DTo view changes made by all the transactions during a given period of time.ETo view changes made by a single transaction during a given period of time.
单选题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;（）AYou obtain the results retrieved from the public synonym HR created by the database administrator.BYou obtain the results retrieved from the HR table that belongs to your schema.CYou get an error message because you cannot retrieve from a table that has the same name as a public synonym.DYou obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.EYou obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
多选题The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）AAll the related indexes and views are automatically droppedBThe flashback drop feature can recover only the table structureCOnly the related indexes are dropped whereas views are invalidatedDThe flashback drop feature can recover both the table structure and its data
单选题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.
单选题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 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.
单选题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？（）A by using the Flashback Table featureB by using the Flashback Database featureC by performing incomplete recovery using RMAN utilityD by performing incomplete recovery using user-managed recovery
单选题Which describes the default behavior when you create a table? （）AThe table is accessible to all users.BTables are created in the public schema.CTables are created in your schema.DTables are created in the DBA schema.EYou must specify the schema when the table is created.
单选题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？（）AImplement a stored procedure that writes data about schema changes to a log table.BImplement DDL AFTER triggers that write user and schema information to a log table.CImplement a DML INSTEAD OF trigger that writes data about schema changes to a log table.DImplement a DML AFTER trigger that writes data about schema changes to a log table.
单选题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?（）AOne of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.BOne of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.CBoth the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.DNone of the tables are recovered from the Recycle Bin, and the statement returns an error.
单选题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？（）AYou can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.BYou can restore the DEPT table by using the Oracle Flashback Drop feature and a systemgenerated name will be assigned to the restored table.CYou cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.DYou 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.
单选题Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）ADROP emp_dept_uv;BDELETE emp_dept_uv;CREMOVE emp_dept_uv;DDROP VIEW emp_dept_uv;EDELETE VIEW emp_dept_uv;FREMOVE VIEW emp_dept_uv;