多选题Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）AALTER TABLE SPLIT PARTITIONBALTER TABLE MERGE PARTITIONCALTER TABLE TRUNCATE PARTITIONDALTER TABLE ADD PARTITIONEALTER TABLE DROP

第1题：

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）

• A、Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
• B、Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
• C、Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
• D、Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
• E、Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
• F、Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

第2题：

You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）

• A、Drop the table.
• B、Partition the table
• C、Truncate the table.
• D、Add a column to the table.
• E、Rename a column in the table.

第3题：

第4题：

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

第5题：

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

• A、 Drop the table.
• B、 Partition the table.
• C、 Truncate the table.
• D、 Add a column to the table.
• E、 Rename a column in the table.

第6题：

In your test database， you have created the ORDERS table as an index/x7forganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）

• A、export and import the mapping table
• B、drop and re­create the mapping table
• C、truncate the mapping table and reinsert the values
• D、use the ALTER TABLE .. REBUILD command to defragment the mapping table

第7题：

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）

• A、ALTER TABLE SPLIT PARTITION
• B、ALTER TABLE MERGE PARTITION
• C、ALTER TABLE TRUNCATE PARTITION
• D、ALTER TABLE ADD PARTITION
• E、ALTER TABLE DROP PARTITION
• F、ALTER TABLE MOVE PARTITION

第8题：

第9题：

Which two operations can be flashed back using the Flashback technology？（）

• A、DROP USER SMITH；
• B、DROP TABLE EMPLOYEES；
• C、DROP TABLESPACE USERS；
• D、ALTER TABLE SALES_REP DROP PARTITION P1；
• E、ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；

第10题：

You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable：  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about the effect of the command（）

• A、No flashback is possible to bring back the ITEM table.
• B、The ORDER table is dropped along with the ITEM table.
• C、The dependent referential integrity constraints in the ORDER table are disabled.
• D、The dependent referential integrity constraints in the ORDER table are removed.
• E、The table definition of the ITEM table and associated indexes are placed in the recycle bin.