多项选择题

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.

单项选择题You receive the following error： ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit Identify the reason for receiving the above error message？（）

A. The sort area is very small.
B. There is no more space in the Undo tablespace.
C. The flash recovery area is full.
D. The online redo log file is full.

多项选择题Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile？（）

A. DB_CREATE_FILE_DEST
B. DB_RECOVERY_FILE_DEST
C. DB_RECOVERY_FILE_DEST_SIZE
D. DB_ONLINE_LOG_DEST_n