Only the ORD_CUSTOMER_IX1 index created.
Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
Both the indexes are created and used by the optimizer for queries on the ORDERS table.
Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
第1题:
While designing your database, you have created the EMPLOYEES table as an index/x7forganized 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?()
第2题:
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?()
第3题:
不属于数据定义功能的SQL语句是______。
A.CREATE TABLE
B.CREATE VIEW
C.UPDATE
D.CREATE INDEX
第4题:
在SQL中,建立索引用()
第5题:
SQL中使用()语句创建索引。
第6题:
At database startup, you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes?()
第7题:
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? ()
第8题:
在SQL中,建立索引的命令是
A.CREATE TABLE
B.CREATE INDEX
C.CREATE VIEW
D.INDEX ON
第9题:
在SQL中,建立视图用的命令是()。
第10题:
在SQL中,建立表用的命令是()。