单项选择题
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？（）
A. multiplexed control files
B. RMAN obsolete backups
C. multiplexed online redo log files
D. archived redo logs that have not been copied to tape
相关考题
-
单项选择题
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.
