单项选择题
At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）
A. DBA_PENDING_TRANSACTIONS
B. DBA_AUDIT_STATEMENT
C. V$FLASHBACK_DATABASE_STATS
D. FLASHBACK_TRANSACTION_QUERY
点击查看答案
相关考题
-
多项选择题
YouaremaintainingadatabasethatisinARCHIVELOGmode.Youhaveconfiguredtheflashrecoveryareainyourdatabase.ThedatabaseisinMOUNTEXCLUSIVEmode，andyouwanttoconfiguretheFlashbackDatabasefeature.WhichtwooptionsareNOTrequiredtoconfiguretheFlashbackDatabasefeature？（）
A. Open the database in read-only mode.
B. Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
C. Enable the block change tracking feature.
D. Execute the ALTER DATABASE FLASHBACK ON statement. -
单项选择题
You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema. Which process writes the before images of the physical database blocks to the flashback database logs？（）
A. LGWR
B. DBWR
C. MMON
D. RVWR -
单项选择题
Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation？（）
A. Query the V$FLASHBACK_DATABASE_LOG view.
B. Query the V$FLASHBACK_DATABASE_STAT view.
C. Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
D. Query the V$RECOVERY_FILE_DEST view.
