多选题What are the prerequisites for enabling Flashback Database？ （）AThe database must be started in the MOUNT EXCLUSIVE state.BThe database must have multiplexed control files.CThe database must be opened by using a text-based parameter file instead of a se

第1题：

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

第2题：

You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）

• A、 DB_RECOVERY_FILE_DEST only
• B、 DB_FLASHBACK_RETENTION_TARGET only
• C、 DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only
• D、 DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only
• E、 DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST and
• F、 DB_FLASHBACK_RETENTION_TARGET

第3题：

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.

第4题：

What are the prerequisites for performing flashback transactions? （）(Choose all that apply)

• A、Supplemental log must be enabled
• B、Supplemental log must be enabled for the primary key
• C、Undo retention guarantee for the database must be configured
• D、”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user

第5题：

You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）

• A、the time when the last flashback operation in your database was performed
• B、the time when the first flashback operation in your database was performed
• C、a list of flashback operations performed in your database using SCN and time
• D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

第6题：

Which two are prerequisites for performing a flashback transaction?（）

• A、Flashback Database must be enabled.
• B、Undo retention guarantee for the database must be configured.
• C、EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
• D、Supplemental logging must be enabled.
• E、Recycle bin must be enabled for the database.
• F、Block change tracking must be enabled tor the database.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

What two are the prerequisites for enabling Flashback Database?（） (Choose two)

• A、The database must be in ARCHIVELOG mode
• B、The database must be in MOUNT EXCLUSIVE mode
• C、The database must be opened in RESTRICTED mode
• D、The database instance must be started in the NOMOUNT state
• E、The database instance must have the keep buffer pool defined

第14题：

What two are the prerequisites for enabling Flashback Database？（） 

• A、 The database must be in ARCHIVELOG mode
• B、 The database must be in MOUNT EXCLUSIVE mode
• C、 The database must be opened in RESTRICTED mode
• D、 The database instance must be started in the NOMOUNT state
• E、 The database instance must have the keep buffer pool defined

第15题：

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

• A、 The time when the last flashback operation in your database was performed.
• B、 The time when the first flashback operation in your database was performed.
• C、 A list of flashback operations performed in your database using SCN and time.
• D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

第16题：

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 Managed Files （OMF）.
• E、Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.

第17题：

What are the prerequisites for enabling Flashback Database？ （）

• A、 The database must be started in the MOUNT EXCLUSIVE state.
• B、 The database must have multiplexed control files.
• C、 The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.
• D、 The database must be in ARCHIVELOG mode.
• E、 The database must be in the NOMOUNT state.
• F、 The database must be opened in RESTRICTED mode.

第18题：

Which two are the prerequisites to enable Flashback Data Archive？（）

• A、 Database must be running in archivelog mode.
• B、 Automatic undo management must be enabled.
• C、 Undo retention guarantee must be enabled.
• D、 The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment  Space Management （ASSM）.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：