Which two are prerequisites for performing Flashback Transaction?

Question

Options

• AFast Recovery Area must be enabled for the database
• BThe EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
• CUndo retention guarantee must be configured for the database.
• DA supplemental log must be enabled for the primary key.
• ERow movement must be enabled.

• A
  12% (5)
• B
  62% (26)
• C
  21% (9)
• E
  5% (2)

Explanation

Performing Flashback Transaction requires both the ability to call the relevant package and enough logging data to reconstruct reverse SQL. Option B is correct because the DBMS_FLASHBACK package is the programmatic interface used to execute flashback transaction operations, and without EXECUTE privilege a user cannot invoke it. Option D is correct because Flashback Transaction uses LogMiner internally to generate compensating (undo) SQL - without supplemental logging on primary keys, Oracle cannot uniquely identify rows to reverse DML statements.

The distractors fail because: A (Fast Recovery Area) is needed for Flashback Database, not Flashback Transaction; C (undo retention guarantee) ensures undo isn't overwritten prematurely but is not a stated prerequisite - undo data just needs to be present; E (row movement) is a prerequisite for Flashback Table, not Flashback Transaction.

Memory tip: Think "Permission + Paper trail" - you need Both the privilege (EXECUTE) and a supplemental Data trail (primary key logging) to backout a transaction.

No community discussion yet for this question.