Home » Oracle » 1z0-067 v.2 » Which three are prerequisites to fulfill this requirement?
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?
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: ABE
Explanation/Reference:
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 those objects. To allow queries on all tables, grant the FLASHBACK ANY TABLE privilege.
http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS612
Download Printable PDF. VALID exam to help you PASS.
|
|