多选题Online index rebuild functionality has been extended to include which four index structures？（）ABitmap indexes.BReverse key indexes.CFunction-based indexes.DKey-compressed indexes on regular tables.EKey-compressed indexes on IOT （including secondary ind

第1题：

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

第2题：

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

第3题：

Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table：  ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）

• A、 Drop and re-create the inbox.
• B、 Coalesce the ORDERS_IND index.
• C、 Coalesce the INDEXES tablespace.
• D、 Drop and re-create the ORDERS table.
• E、 Rebuild the index online and move it to another tablespace.

第4题：

Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES  While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available.  Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）

• A、drop and re-create the index
• B、coalesce the ORDERS_IND index
• C、coalesce the INDEXES tablespace
• D、drop and re-create the ORDERS table
• E、rebuild the index online and move it to another tablespace

第5题：

A bitmap join index is defined as（）.

• A、An index used to join two bitmap indexes on a table.
• B、A bitmap index created for the join of two or more tables.
• C、A bitmap index created on the join of two or more indexes.
• D、A bitmap index created on the join of two or more indexed-organized tables.

第6题：

The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?（）

• A、A primary key must exist for creation of a clustered index
• B、A clustered index allows fulltext searching within InnoDB
• C、The first unique index is always used as a clustered index and not a primary key
• D、A clustered index provides direct access to a page containing row data
• E、If no indexes exist, a hidden clustered index is generated based on row IDs
• F、A primary key is used as a clustered index
• G、A clustered index is a grouping of indexes from different tables into a global index for faster searching

第7题：

You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）

• A、DBCC DBREINDEX
• B、SELECT * FROM sys.dm_db_index_physical_stats
• C、DBCC INDEXDEFRAG
• D、SELECT * FROM sys.indexes

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Online index rebuild functionality has been extended to include which four index structures？（）

• A、Bitmap indexes.
• B、Reverse key indexes.
• C、Function-based indexes.
• D、Key-compressed indexes on regular tables.
• E、Key-compressed indexes on IOT （including secondary indexes）

第14题：

Which two statements are TRUE regarding Coherence Indexes ？ （）

• A、 indexes are maintained by cache entry ownes
• B、 an application should not suggest an index that another aplication had suggested
• C、 indexes cannot be sorted
• D、 each application using Coherence may suggest the same set of indexes when it starts

第15题：

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; 

第16题：

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；

第17题：

The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday， you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command：    SQL>DROP TABLESPACE INDEXES INCLUDING CONTENTS；    SQL> CREATE TABLESPACE INDEXES DATAFILE   ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m；   After that， you issued the following command to recreate the index：    CREATE UNIQUE INDEX sales_index_pk ON sales （order_id）   PCTFREE 10   INITRANS 2   MAXTRANS 255   TABLESPACE indexes   STORAGE （   INITIAL 1m  NEXT 1m   PCTINCREASE 0   MINEXTENTS 1   MAXEXTENTS 8192  ）   NOLOGGING   PARALLEL（ degree 4）   Which two clauses are responsible for reducing the time for the recreation of the index？（）

• A、 PCTFREE
• B、 MAXTRANS
• C、 PCTINCREASE
• D、 INITIAL
• E、 NOLOGGING
• F、 PARALLEL

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

You manage a SQL Server 2005 database that contains a table with many indexes.  You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use？（）

• A、sys.dm fts index population
• B、sys.dm exec query stats
• C、sys. dm db index usage stats
• D、sys.dm db index physical stats

第20题：

第21题：

第22题：

第23题：