违法和不良信息举报 联系客服
免费注册 登录

多选题Which two statements are correct regarding the Oracle Flashback Drop feature？ （）ARecycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.BYou can flash back a dropped table provided row movement has been enabled on the table.C

题目
多选题
Which two statements are correct regarding the Oracle Flashback Drop feature？ （）
A

Recycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.

B

You can flash back a dropped table provided row movement has been enabled on the table.

C

If you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.

D

When you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.

E

When a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.

F

If you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

参考答案和解析
正确答案： C,A
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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? ()(Choose two)

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

第2题：

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? （）(Choose two)

  • 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

第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题：

Which two statements are correct regarding the Flashback Versions Query feature？（）

  • A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
  • B、 You can use this feature to identify the versions of V$ views.
  • C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
  • D、 You can use this feature for a table only if row movement is enabled for the table.
  • E、 You can use this feature to identify the versions of external and fixed tables.

正确答案:A,C

第5题：

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

  • A、UPDATE TABLE
  • B、CREATE CLUSTER
  • C、TRUNCATE TABLE
  • D、ALTER TABLE MOVE
  • E、INSERT INTO···VALUES
  • F、ALTER TABLE···DROP COLUMN
  • G、ALTER TABLE···DROP PARTITION

正确答案:A,E

第6题：

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

  • A、 Flashback logs are not archived.
  • B、 Flashback logs are maintained in redo log files.
  • C、 Flashback logs are maintained in the Flash Recovery Area.
  • D、 Flashback logs are used to maintain Flashback Database related errors.
  • E、 Flashback logs need to be cleared manually after you disable Flashback Database.

正确答案:A,C

第7题：

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.

正确答案:B

第8题：

Which two statements regarding the Flashback Table feature are correct?()

A. Flashback Table can be performed on system tables.

B. Flashback Table operation does not shrink the segments.

C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.

D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.


参考答案：B, D

第9题：

You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable：  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about the effect of the command（）

  • A、No flashback is possible to bring back the ITEM table.
  • B、The ORDER table is dropped along with the ITEM table.
  • C、The dependent referential integrity constraints in the ORDER table are disabled.
  • D、The dependent referential integrity constraints in the ORDER table are removed.
  • E、The table definition of the ITEM table and associated indexes are placed in the recycle bin.

正确答案:A,D

第10题：

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.

正确答案:A

更多相关问题
相关内容