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


相似考题