Which two statements regarding the Flashback Table feature a

第1题：

第2题：

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.

第3题：

第4题：

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.

第5题：

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

第6题：

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.

第7题：

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

第8题：

第9题：

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

第10题：

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