Oracle Database 12c: Advanced Administration — Question 98

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 prerequisites to fulfill this requirement?

Answer options

• A. Minimal supplemental logging must be enabled.
• B. The database must be running in archivelog mode.
• C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
• D. The flashback any table privilege must be granted to the user.
• E. The select any transaction privilege must be granted to the user.
• F. The recycle bin parameter must be set to on.

Correct answer: C, D, E

Explanation

The correct answer includes C, D, and E because these privileges are necessary for a user to access flashback data and transaction history. Options A and B, while they relate to database configuration, are not directly related to user privileges for accessing metadata. Option F does not impact the ability to retrieve transaction data and is therefore irrelevant.