Oracle
1Z0-043 · Question #48
Which two statements are correct regarding the Oracle Flashback Drop feature? (Choose two.)
The correct answer is A. Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces. C. If you drop an index before dropping its associated table, then the recovery of the index is not. See the full explanation below for the reasoning.
Question
Which two statements are correct regarding the Oracle Flashback Drop feature? (Choose two.)
Options
- 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.
- CIf you drop an index before dropping its associated table, then the recovery of the index is not
- DWhen you execute the DROP TABLESPACE ? INCLUDING CONTENTS command, the objects
- EWhen a dropped table is moved to the recycle bin, only the table is renamed to a system-generated
- FIf you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and
How the community answered
(63 responses)- A78% (49)
- B5% (3)
- D2% (1)
- E11% (7)
- F5% (3)
Community Discussion
No community discussion yet for this question.