You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）

单项选择题Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）

A. The database does not record flashback logs for MY_TABLESPACE
B. The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
C. All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
D. None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

单项选择题At10：30A.M.，youranabatchjobbymistake，whichexecutedatransactioninthedatabase.Thetransactionidentifierofthetransactionthatmadetothechangesinthedatabaseis0500A00627B000.At11：10A.M.，youstoppedthebatchjob.Now，youwanttoidentifythechangesmadetothedatabasetablesbythebatchjob.Whichviewwillyouquery？（）

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.