多选题Which are the prerequisites for performing flashback transactions on your database？（）AUndo retention guarantee for the database must be configured.BSupplemental log must be enabled for the primary key.CSupplemental log must be enabled.DExecute permissi

第1题：

By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）

• A、RMAN only
• B、Flashback Table only
• C、Flashback Versions Query only
• D、Flashback Database and Flashback Transaction Query
• E、Flashback Versions Query and Flashback Transaction Query

第2题：

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

第3题：

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

第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_STATview aretrue？ （）

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

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.

第6题：

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）.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）

• A、 RESETLOGS
• B、 TO TIMESTAMP
• C、 TO BEFORE DROP
• D、 RENAME TO
• E、 TO SCN

第14题：

Which two prerequisites are needed for performing workload capture and replay？（）

• A、Close all sessions performing queries using database links
• B、running the database in shared server mode
• C、The database on which the workload is replayed has to be a restore of the original database to a specific SCN
• D、setting up the directory to capture the workload

第15题：

Which of the following Oracle features utilize the undo tablespace？（） 

• A、 Flashback Query
• B、 Flashback Drop
• C、 Flashback Table
• D、 Flashback Database
• E、 Transaction Processing
• F、 Recycle Bin

第16题：

Which two statements about Flashback Query are true？（）

• A、It is generated by using the redo log files. 
• B、It helps in row-level recovery from user errors.
• C、It can be performed to recover ALTER TABLE statements 
• D、It fails when undo data pertaining to the transaction is overwritten.
• E、The database has to be opened with the resetlogs option after performing Flashback Query.

第17题：

Which three actions are required to configure the Flashback Database？（）  

• A、 set Flash Recovery Area
• B、 enable Flashback logging
• C、 create FLASHBACK tablespace
• D、 start the database in the ARCHIVELOG mode
• E、 start the database in the NOARCHIVELOG mode

第18题：

Which of the following statements is true regarding implementing a Flashback Table recovery？  （）

• A、 An SCN is never used to perform a Flashback Table recovery.
• B、 If a significant number of changes have been made to the table， row movement must be enabled.
• C、 The tablespace must be offline before performing a Flashback Table recovery.
• D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：