单选题The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）A ALTER TABLE employees monitor index employee_idx_fk; B ALTER INDEX

第1题：

Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）

• A、Oracle Data Pump.
• B、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
• C、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
• D、Online Table Redefinition.
• E、Edition-Based Table Redefinition.

第2题：

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

第3题：

An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command：   SQL>CREATE INDEX ord_custname_ix ON orders（custname）；   The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.  Which is the most efficient method of performing this task？（）

• A、 disabling the index
• B、 making the index invisible
• C、 making the index unusable
• D、 using the MONITORING USAGE clause for the index

第4题：

The EMPLOYEES table is stored in the SAMPLE tablespace.  The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace.  Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace.  Which object will be exported by this command？（）   exp system/manager tablespaces=SAMPLE

• A、Only the EMPLOYEES table.
• B、Only the EMPLOYEES table and its corresponding primary key index.
• C、The EMPLOYEES table and partition P1.
• D、The EMPLOYEES table， IPK_EMP index， and the SALES table.

第5题：

An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）

• A、EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.
• B、ALTER TABLE … COALESCE ；
• C、ALTER INDEX …REBUILD ONLINE；
• D、CREATE TABLE …AS SELECT_ONLINE；

第6题：

You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）

• A、The index remains invisible.
• B、The index is not updated by the DML statements on the indexed table.
• C、The index automatically becomes visible in order to have it updated by DML on the table.
• D、The index becomes unusable but the table is updated by the DML.
• E、The index is updated by the DML on the table.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX：   SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE；   Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（） 

• A、 Index-organized table
• B、 Mapping Table
• C、 Clustered Table
• D、 Journal Table

第14题：

You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）

• A、 Rebuild the index.
• B、 Coalesce the index.
• C、 Drop and re-create the index in the new tablespace.
• D、 Relocate the index using the ALTER INDEX...MOVE statement.

第15题：

You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）

• A、enable index monitoring and query the DBA_OBJECTS view
• B、enable index monitoring and query the DBA_INDEXES view
• C、enable index monitoring and query the V$OBJECT_USAGE view
• D、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view

第16题：

The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）

• A、ALTER TABLE employees monitor index employee_idx_fk; 
• B、ALTER INDEX employee_idx_fk monitoring on; 
• C、ALTER TABLE employees monitor all indexes; 
• D、ALTER INDEX employee_idx_fk monitoring usage; 

第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 work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes， making sure that you reduce the effect on database availability to the least.  In the ALTER INDEX statement， which option should be included？（）

• A、Sort in tempdb 
• B、Online 
• C、Fill factor 
• D、Pad index 

第19题：

第20题：

第21题：

第22题：

第23题：