多项选择题
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）
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. -
多项选择题
In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；
A. when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago
B. when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
C. when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago
D. when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
E. never， because FLASHBACK TABLE is not a valid command in Oracle 10g.
