Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval. Which three are…

Question

Options

• AMinimal supplemental logging must be enabled.
• BThe database must be running in archivelog mode.
• CFlashback Data Archive must be created and the flashback archive administer system privilege
• DThe flashback any table privilege must be granted to the user.
• EThe select any transaction privilege must be granted to the user.
• FTherecycle binparameter must be set to on.

• A
  83% (19)
• C
  4% (1)
• D
  9% (2)
• F
  4% (1)

Explanation

To configure your database for the Flashback Transaction feature, you or your database administrator must: With the database mounted but not open, enable ARCHIVELOG: ALTER DATABASE ARCHIVELOG; Open at least one archive log: ALTER SYSTEM ARCHIVE LOG CURRENT; If not done, enable minimal and primary key supplemental logging: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS; Granting Necessary Privileges For Oracle Flashback Transaction Query Grant the SELECT ANY TRANSACTION privilege. For Oracle Flashback Query and Oracle Flashback Version Query To allow access to specific objects during queries, grant FLASHBACK and SELECT privileges on To allow queries on all tables, grant the FLASHBACK ANY TABLE privilege.

No community discussion yet for this question.