Which two are prerequisites for performing Flashback Tr…

Which two are prerequisites for performing Flashback Transaction?

Which two are prerequisites for performing Flashback Transaction?

A.
A supplemental log must be enabled for the primary key.

B.
Undo retention guarantee must be configured for the database.

C.
Fast Recovery Area must be enabled for the database.

D.
The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

E.
Row movement must be enabled.

Explanation:

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *