多选题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题：

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.

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

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

第4题：

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 EMPLOYEES table. 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

第5题：

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

第6题：

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.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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 changes made to the EMP table since the specified time will be undone.
• C、The EMP table that was dropped by mistake from the database will be restored.
• D、The FLASHBACK TABLE statement will be executed within a single transaction.
• E、The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. 
• F、The list of transactions that have modified the EMP table since the specified time will be displayed.

第14题：

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

第15题：

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.

第16题：

Which two statements are correct regarding the Oracle Flashback Drop feature？ （）

• A、 Recycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.
• B、 You can flash back a dropped table provided row movement has been enabled on the table.
• C、 If you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.
• D、 When you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.
• E、 When a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.
• F、 If you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

第17题：

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

• A、The EMPLOYEES table will be changed to read-only mode during the shrink operation.
• B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
• C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
• D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

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