单选题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 auto

第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题：

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

第3题：

第4题：

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）

第5题：

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.

第6题：

You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1：   DROP FLASHBACK ARCHIVE fla1；   What is the effect of this command？（）

• A、 The Flashback Archive FLA1 is dropped only if it is empty.
• B、 The tablespace having Flashback Archive is dropped.
• C、 The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
• D、 The Flashback Data Archive and historical data are dropped.

第7题：

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

第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 have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

• A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
• C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

第10题：

The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

• A、 Enable flashback logging.
• B、 Start the database in the ARCHIVELOG mode.
• C、 Issue the ALTER DATABASE FLASHBACK ON； command.
• D、 Set the FAST_START_MTTR_TARGET initialization parameter.