多选题You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Fla

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

On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）

• A、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
• B、 You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
• C、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
• D、 You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

第3题：

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.

第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 maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

• A、 VERSIONS_STARTSCN
• B、 VERSIONS_STARTTIME
• C、 VERSIONS_XID
• D、 VERSIONS_OPERATION

第6题：

By using the transaction identifier provided by（）for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction. 

• A、 Flashback Table
• B、 Flashback Database
• C、 Flashback Version Query
• D、 The RMAN REPORT command
• E、 The DBA_PENDING_TRANSACTIONS view

第7题：

On Jan 11， 2005 at 2：30 P.M.， an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator， and you want to return the original values in the table. To do so， you decided to flash back the table. Which two options can you use to flash back a table？（）

• A、 by using Oracle Enterprise Manager
• B、 by issuing the FLASHBACK TABLE statement at the RMAN prompt
• C、 by issuing the FLASHBACK TABLE statement at the SQL prompt
• D、 by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt

第8题：

You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

• A、 You must use automatic undo management in the database.
• B、 You must configure OMF in your database.
• C、 You must configure ASM for storing the datafiles.
• D、 You must multiplex the online redo log file.

第9题：

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.

第10题：

You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

• A、Oracle Flashback uses undo information to construct consistent data. 
• B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
• C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
• D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.