1z0-043

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

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

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

第1题：

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

第2题：

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;


参考答案：D

第3题：

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 dropped

B. The flashback drop feature can recover only the table structure

C. Only the related indexes are dropped whereas views are invalidated

D. The flashback drop feature can recover both the table structure and its data


参考答案：C, D

第4题：

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

第5题：

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;

正确答案:D

第6题：

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.


参考答案：C

第7题：

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

第8题：

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.


参考答案：D

第9题：

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

第10题：

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

更多相关问题
相关内容