Which two are prerequisites for performing a flashback …

Which two are prerequisites for performing a flashback transaction?

Which two are prerequisites for performing a flashback transaction?

A.
Flashback Database must be enabled.

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

C.
EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back
transaction.

D.
Supplemental logging must be enabled.

E.
Recycle bin must be enabled for the database.

F.
Block change tracking must be enabled tor the database.

Explanation:
Oracle Database Advanced Application Developer’s Guide 11g, Using Oracle Flashback
Technology

Show Hint

Leave a Reply 3

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

DrTube

DrTube

C & D.

Oracle 12C Study Guide – Biju Thomas

Using Flashback Transaction
You can use the Flashback Transaction technology to undo a transaction and its dependent
transactions. The DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure is used to accomplish
this task.
You must meet the following prerequisites to perform a Flashback Transaction on an
Oracle Database 12c database:
■■ The database must be in ARCHIVELOG mode.
■■ Supplemental logging must be enabled in the database using ALTER DATABASE ADD
SUPPLEMENTAL LOG DATA.
■■ A supplemental log data primary key should be created using the statement ALTER
DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS.
■■ The user performing the Flashback Transaction must have the SELECT ANY
TRANSACTION privilege.
■■ The user should have the EXECUTE privilege on DBMS_FLASHBACK.
■■ The user should also have appropriate DML privileges on the tables (such as
INSERT/UPDATE/DELETE).
Using EM Cloud Control, you can perform the Flashback Transaction. Choose
Transactions from the Backup and Recovery menu under Availability.

Reply