nerdexam
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)
  • A
    78% (49)
  • B
    5% (3)
  • D
    2% (1)
  • E
    11% (7)
  • F
    5% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice