多选题Which two statements regarding the Flashback Table feature are correct?（）AFlashback Table can be performed on system tables.BFlashback Table operation does not shrink the segments.CFlashback Table uses log mining to extract SQL_REDO and SQL_UNDO statem

第1题：

Which two statements regarding the Flashback Table feature are correct?（）

• A、Flashback Table can be performed on system tables.
• B、Flashback Table operation does not shrink the segments.
• C、Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
• D、Flashback Table operation acquires exclusive data manipulation language (DML) locks.

第2题：

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

第3题：

Which two statements are correct regarding the Flashback Versions Query feature？（）

• A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
• B、 You can use this feature to identify the versions of V$ views.
• C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
• D、 You can use this feature for a table only if row movement is enabled for the table.
• E、 You can use this feature to identify the versions of external and fixed tables.

第4题：

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.

第5题：

Which statements are true regarding the Query Result Cache? （）

• A、It can be set at the system, session, or table level.
• B、It is used only across statements in the same session.
• C、It can store the results from normal as well as flashback queries.
• D、It can store the results of queries based on normal, temporary, and dictionary tables.

第6题：

You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）

• A、 The FLASHBACK TABLE statement will not be written to the alert log file.
• B、 The EMP table that was dropped by mistake from the database will be restored.
• C、 The changes made to the EMP table since the specified time will be undone.
• D、 The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
• E、 The FLASHBACK TABLE statement will be executed within a single transaction.
• F、 The list of transactions that have modified the EMP table since the specified time will be displayed.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

• A、All the related indexes and views are automatically dropped
• B、The flashback drop feature can recover only the table structure
• C、Only the related indexes are dropped whereas views are invalidated
• D、The flashback drop feature can recover both the table structure and its data

第14题：

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

• A、UPDATE TABLE
• B、CREATE CLUSTER
• C、TRUNCATE TABLE
• D、ALTER TABLE MOVE
• E、INSERT INTO···VALUES
• F、ALTER TABLE···DROP COLUMN
• G、ALTER TABLE···DROP PARTITION

第15题：

The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

• A、 All the related indexes and views are automatically dropped
• B、 The flashback drop feature can recover only the table structure
• C、 Only the related indexes are dropped whereas views are invalidated
• D、 The flashback drop feature can recover both the table structure and its data

第16题：

You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）

• A、 perform point-in-time recovery
• B、 perform a Flashback Table operation to restore the table to the state it was in two days ago
• C、 perform a Flashback Database operation to restore the database to the state it was in two days ago
• D、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

第17题：

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.

第18题：

You have just performed a FLASHBACK TABLE operation using the following command：   flashback table employees to scn 123456；   The employees table has triggers associated with it.  Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（）  

• A、 All the triggers are disabled.
• B、 All the triggers are enabled by default.
• C、 Enabled triggers remain enabled and disabled triggers remain disabled.
• D、 Triggers are deleted when a Flashback Table operation is performed.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：