Which two are prerequisites for performing Flashback Transaction?

The correct answer is A. A supplemental log must be enabled for the primary key. D. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package. https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01003

Configuring for Recoverability

Question

Which two are prerequisites for performing Flashback Transaction?

Options

AA supplemental log must be enabled for the primary key.
BUndo retention guarantee must be configured for the database.
CFast Recovery Area must be enabled for the database.
DThe EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
ERow movement must be enabled.

How the community answered

(33 responses)

A
82% (27)
B
3% (1)
C
9% (3)
E
6% (2)

Explanation

https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01003

Topics

#Flashback Transaction#supplemental logging#DBMS_FLASHBACK#prerequisites

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice