单选题In which scenario would an index be most useful?（）A The indexed column is declared as NOT NULL.B The indexed columns are used in the FROM clause.C The indexed columns are part of an expression.D The indexed column contains a wide range of values.

第1题：

In which of the following situations should correlation names be used?（）

• A、A table referenced in the FROM clause has no indexed column.
• B、The table referenced in the FROM clause has more than 200 columns.
• C、Two or more tables in the FROM clause have identical column names.
• D、The FROM clause contains two or more tables in the SELECT statement.

第2题：

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.

第3题：

Which two statements are true about a bitmap index？ （）

• A、It is recommended for the columns that have unique values.
• B、It can be converted to a B-tree index by using the ALTER INDEX command.
• C、It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.
• D、Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

第4题：

36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）

• A、Rows 
• B、Totals 
• C、Columns 
• D、Cells 
• E、Data

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

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. You find a problem that when the following query is executed， a SQL Server 2005 application will perform slowly. SELECT * FROM Orders WHERE OrderStatus = ’InProgress’ This query is executed by the application as an ad hoc query. In most occasions， this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless， the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However， the application that executes the query should not be changed. In addition， the effect on end users should be cut to the least.  Which action should be performed to finish the task？（）

• A、To finish the task， the index should be built by utilizing a FILLFACTOR of 10 percent.
• B、To finish the task， the index should be recreated to have all of the columns in the table included.
• C、To finish the task， an indexed view of the Orders table should be viewed.
• D、To finish the task， the statistics should be updated on the index.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which of the following abilities does a view NOT provide？（）

• A、Change which columns show
• B、Open a view from another database
• C、Contain custom controls
• D、Identify a column to act as a link

第14题：

Which two statements are true about the primary key constraint in a table？ （）

• A、It is not possible to disable the primary key constraint.
• B、It is possible to have more than one primary key constraint in a single table.
• C、The primary key constraint can be referred by only one foreign key constraint.
• D、The primary key constraint can be imposed by combining more than one column.
• E、The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.

第15题：

Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）

• A、An update in a leaf row takes place.
• B、The index becomes invalid after the update.
• C、The leaf block containing the row to be updated is marked as invalid.
• D、A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted

第16题：

In which scenario would index be most useful?（）

• A、The indexed column is declared as NOT NULL.
• B、The indexed columns are used in the FROM clause.
• C、The indexed columns are part of an expression.
• D、The indexed column contains a wide range of values.

第17题：

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.

第18题：

You need to ensure that the Cust_CalcData column is implemented appropriately. What should you do?（）

• A、Specify that the Cust_CalcData column must be implemented as a computed column of the table. 
• B、Specify that the Cust_CalcData column must be indexed using a non-clustered index.
• C、Specify that the Cust_CalcData column must be implemented as a column that uses a user-defined data type.
• D、Specify that the Cust_CalcData column must be updated by a SQL Server Agent job that runs nightly.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：