which of these steps are required?

In order to perform Flashback Transaction Query operations, which of these steps are required?
(Choose all that apply.)

In order to perform Flashback Transaction Query operations, which of these steps are required?
(Choose all that apply.)

A.
Ensure that database is running with version 10.1 compatibility.

B.
Enable Flashback Logging.

C.
Enable Supplemental Logging.

D.
Ensure that the database is running with version 10.0 compatibility.

E.
Ensure that the database is in ARCHIVELOG mode



Leave a Reply 1

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


Helcio

Helcio

Configuring Your Database for Oracle Flashback Transaction Query

To configure your database for the Oracle Flashback Transaction Query feature, you or your database administrator must:

Ensure that Oracle Database is running with version 10.0 compatibility.
Enable supplemental logging:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;