单选题Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A  DBWnB  RECOC  RVWRD  LGWR

第1题：

Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）

• A、 DBWn
• B、 RECO
• C、 RVWR
• D、 LGWR

第2题：

Flashback Database relies on which technologies to recover to a point in time？（）  

• A、 Flashback Data Archive
• B、 Flashback logs in the flash recovery area
• C、 FlashbUndo tablespace
• D、 RMAN command line
• E、 None of the above

第3题：

第4题：

These are the details about V$FLASHBACK_DATABASE_STAT：  SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type  ------------- -------- --------------  BEGIN_TIME DATE END_TIME DATE  FLASHBACK_DATA NUMBER  DB_DATA NUMBER REDO_DATA NUMBER  ESTIMATED_FLASHBACK_SIZE NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true？ （）

• A、BEGIN_TIME is the time at which Flashback logging is enabled.
• B、END_TIME is the time at which the query is executed on the view.
• C、REDO_DATA is the number of bytes of redo data written during the interval.
• D、This view contains information about flashback data pertaining to the last 24 hours.
• E、FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

第5题：

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

第6题：

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

第7题：

You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

• A、SYSDATE should not be used with TIMESTAMP.
• B、The database must have multiplexed redo log files.
• C、The database must be in the MOUNT state to execute the command.
• D、The database must be opened with the RESETLOGS option after the flashback operation.
• E、The entire database needs to be restored from the most recent backup before the flashback operation.

第8题：

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

• A、 Flashback logs are not archived.
• B、 Flashback logs are maintained in redo log files.
• C、 Flashback logs are maintained in the Flash Recovery Area.
• D、 Flashback logs are used to maintain Flashback Database related errors.
• E、 Flashback logs need to be cleared manually after you disable Flashback Database.

第9题：

You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF；  What would be the effect of this command on the existing flashback logs？（）

• A、 Flashback logs are not deleted.
• B、 Flashback logs are deleted automatically.
• C、 Flashback logs are deleted only if you are using Recovery Manager （RMAN）
• D、 Flashback logs are deleted only if you are using Oracle Manager Files （OFM）
• E、 Flashback logs are deleted only if you are using Automatic Storage Management （ASM）

第10题：

Which three statements are true about Flashback Database?（）

• A、Flashback logs are written sequentially, and are archived.
• B、Flashback Database uses a restored control file to recover a database.
• C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
• D、Flashback Database can recover a database to the state that it was in before a reset logs operation.
• E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.