nerdexam
Oracle

1Z0-043 · Question #200

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…

The correct answer is B. You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use. See the full explanation below for the reasoning.

Question

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?

Options

  • AYou cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table
  • BYou can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use
  • CYou cannot restore the DEPT table by using the Oracle Flashback Drop feature because the
  • DYou can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated

How the community answered

(39 responses)
  • A
    10% (4)
  • B
    82% (32)
  • C
    3% (1)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice