Oracle
1Z0-063 · Question #86
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…
The correct answer is C. Flashback Data Archive must be created and the flashback archive administer system privilege D. The flashback any table privilege must be granted to the user. E. The select any transaction privilege must be granted to the user. See the full explanation below for the reasoning.
Question
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?
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.
- FThe recycle bin parameter must be set to on.
How the community answered
(43 responses)- A7% (3)
- B2% (1)
- C77% (33)
- F14% (6)
Community Discussion
No community discussion yet for this question.