Which two statements are correct regarding the Oracle Flashback Drop feature?

Which two statements are correct regarding the Oracle Flashback Drop feature?
(Choose two.)

Which two statements are correct regarding the Oracle Flashback Drop feature?
(Choose two.)

A.
Recycle bin exists for the tables only in non-SYSTEM, locally managedtablespaces.

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *