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.
A, B, D
A D E – Flashback Transaction Query refer.
Correct answer is A,B,E.
A,B,E
D not, because you can grant object priviledge FLASHBACK TABLE individually on table
http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS612
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.
Thanks Siegfried!
A,B,E Thanks Siegfried!
http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS612
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.
ABE
ABE
Flashback Transaction Backout: Prerequisites
Before a Flashback Transaction Backout operation can be activated, the DBA must make sure the following prerequisites have been addressed:
The database must be in ARCHIVELOG mode.
Supplemental logging must have been enabled at the database level; in addition, at a minimum, primary key level supplemental logging must be enabled on the tables for which FTB is desired.
Any user accounts other than SYS that will be participating in an FTB operation must have been granted the EXECUTE object privilege on package DBMS_FLASHBACK, and the SELECT ANY TRANSACTION system privilege.
Finally, any user account other than SYS must be granted FLASHBACK privileges on the table(s) on which FTB will be performed. Likewise, any user account that will be performing FTB must also either own the tables on which FTB will be performed, or have complete (SELECT, INSERT, UPDATE, and DELETE) DML privileges on those tables
ABE
ABE (I am with Siegfried and Vonpire)
Metadata => supplemental logging
a transcation or several Transactions in a given time => select any Transaction
there is no need for flashback (noch flashback any table) mentioned. Only ‘retrieve data’ …
no flashback data Archive neccessary because nothing is mentionend that data for a certain table has to be kept for a Long period of time.
CDE IS CORRECT
A- IF NOT at least one archive log is opened, then enable minimal supplemental logging
B-to be able to FLASHBACK TRANSACTION, you must enable ARCHIVELOG WITH DATABASE mounted but not open.
ADE
It is referring to Flashback Transaction Query feature, not Flashback Transaction. They are different things.
– 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 –> A is correct
– Configuring Your Database for “Flashback Transaction”
To configure your database for the Flashback Transaction feature, you or your database administrator must:
•With the database mounted but not open, enable ARCHIVELOG: –> Not applicable to this question. B is wrong
D – Correct. The question doesn’t mention user accessing a single table.
ABE
6.2.3 Configuring Your Database for Flashback Transaction
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;
If you want to track foreign key dependencies, enable foreign key supplemental logging:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS;
This question asks for pre-requisites of :-
Flashback transaction & Flashback version. Note you cannot put Flashback transaction backout here as they need data as well as metadata (like xid_,…)
A,D,E
Use >>Oracle Flashback Transaction Query<< to retrieve metadata and historical data for a given transaction or for all transactions in a given time interval.
Thus we need fullfil requirements for Flashback Transaction Query NOT for Flashback Transaction (A and E).
Probably third corect is D as JC said
WHy E? What does E mean?
ABE