多选题On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id

第1题：

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 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.

第2题：

SQL中使用（）语句创建索引。

• A、CREATE PROC
• B、CREATE VIEW
• C、CREATE TABLE
• D、CREATE INDEX

第3题：

在SQL中，建立索引用（）

• A、CREATE SCHEMA命令
• B、CREATE TABLE命令
• C、CREATE VIEW命令
• D、CREATE INDEX命令

第4题：

You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

• A、 SQL scripts
• B、 Recovery Manager （RMAN） script
• C、 Data Pump
• D、 SQL*Loader
• E、 Flashback database

第5题：

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.

第6题：

On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）

• A、Only the ORD_CUSTOMER_IX1 index created.
• B、Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
• C、Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
• D、The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
• E、Both the indexes are created and used by the optimizer for queries on the ORDERS table.
• F、Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

第7题：

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

第8题：

A Windows Azure application retrieves data from SQL Azure.   You need to recommend an approach for improving application query performance.  What should you recommend？（）

• A、 Create a database view to retrieve the data.
• B、 Use a clustered index on the SQL Azure database tables.
• C、 Open a new database connection when an operation times out.
• D、 Create SQL Azure database table indexes basedon application queries

第9题：

第10题：

第11题：

第12题：

第13题：

Your company Web site includes a page that customers use to send feedback about the company and its products. You use a SQL Server 2005 database to store the comments in the Comments column of a table named Feedback. You need to implement full-text searching so that you can run reports on the comments. Which two actions should you perform? （）

• A、 Create a nonclustered index on the Comments column. 
• B、 Execute the USE Master Transact-SQL statement. 
• C、 Create a full-text catalog. 
• D、 Create a full-text index on the Comments column.

第14题：

在SQL中，建立视图用的命令是（）。

• A、CREATE SCHEMA
• B、CREATE TABLE
• C、CREATE VIEW
• D、CREATE INDEX

第15题：

在SQL中，建立表用的命令是（）。

• A、CREATE SCHEMA
• B、CREATE TABLE
• C、REATE VIEW
• D、CREATE INDEX

第16题：

You lost the index tablespace in your database. You decided to re/x7fcreate the index tablespace and the indexes in the tablespace.  What methods can you use to re/x7fcreate the indexes？（）

• A、Data Pump
• B、SQL scripts
• C、SQL*Loader
• D、Flashback database
• E、Recovery Manager （RMAN） script

第17题：

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

• A、 ONLINE
• B、 REVERSE
• C、 PARALLEL
• D、 COMPRESS
• E、 NOLOGGING
• F、 COMPUTE STATISTICS

第18题：

On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）

• A、Both the indexes are created; however, only the ORD_COSTOMER index is visible.
• B、The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
• C、Only the ORD_CUSTOMER_IX1 index is created.
• D、Only the ORD_CUSTOMER_IX2 index is created.
• E、Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

第19题：

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

第20题：

在SQL中，建立视图用（）

• A、CREATE SCHEMA命令
• B、CREATE TABLE命令
• C、CREATE VIEW命令
• D、CREATE INDEX命令

第21题：

第22题：

第23题：

第24题：