单选题While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the

第1题：

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.

第2题：

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

第3题：

In your test database， you have created the ORDERS table as an index-organized 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

第4题：

While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

• A、the CREATE TABLE .. command
• B、sorting of the SYSTEM tablespace’s data
• C、sorting of data required by recursive SQL statements
• D、the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
• E、sorting of data if the users have not been allocated temporary tablespace explicitly
• F、sorting of data if the users have been allocated temporary tablespace explicitly

第5题：

You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）

• A、 create a hash cluster to store the data
• B、 create an index cluster to store the data
• C、 create a partitioned table to store the data
• D、 create a sorted hash cluster to store the data
• E、 create a heap table with rowid to store the data

第6题：

You work in a company which is named Wiikigo Corp. The company 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 which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products. The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should you perform to achieve this goal?（）  

• A、On the Products table, you should create a view. 
• B、On the RadioSize column, you should create a clustered index 
• C、On the RadioSize column, you should create a filtered index 
• D、On the RadioSize column, you should create a unique clustered index

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

• A、You must have started the database instance in restricted mode.
• B、You must have started the database instance inNORMALmode.
• C、You must have started the database instance with server parameter file.
• D、You must have started the database instance but must not have mounted.
• E、You must have started the database instance but must not have opened.

第14题：

While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

• A、 A primary key must have been created.
• B、 A mapping table must have been created.
• C、 An overflow tablespace must have been specified.
• D、 The PCTTHRESHOLD option must have been specified.

第15题：

You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）

• A、 The index can be changed from NOLOGGING to LOGGING
• B、 The index cannot be recovered even in the ARCHIVELOG mode.
• C、 The index can only be created if the base table is created with the NOLOGGING option.
• D、 The index can be recovered if you perform a backup after the CREATE INDEX statement.

第16题：

You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）

• A、 Index cluster
• B、 Hash cluster
• C、 Sorted Hash cluster
• D、 Real Application Cluster

第17题：

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. A SQL Server 2005 computer is managed by you， and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement， rows which duplicate CustName values are included should be moved from the CustInfo table every year. However， the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates. Since you are the technical support， you are required to think out a method to have potential duplicate rows identified for manual examination. The minimum amount of administrative effort should be utilized.  Which action should be performed to finish the task？（）

• A、A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.
• B、A new unique index should be created on the CustName column. And then， IGNORE_DUP_KEY = ON should be specified when creating index.
• C、On the CustName column， a foreign key constraint should be created， and a distinct list of CustName values is referenced by the foreign key constraint.
• D、A SELECT INTO query should be utilized， and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：