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?()
第1题:
在SQL中,建立索引的命令是
A.CREATE TABLE
B.CREATE INDEX
C.CREATE VIEW
D.INDEX ON
第2题:
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?()
第3题:
下面所列条目中,( )不是标准的SQL语句。A.DELETE INDEX B.CREATE INDEXC.DELETE FROM D.CREATE UNIQUE CLUSTER INDEX
第4题:
SQL中使用()语句创建索引。
第5题:
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?()
第6题:
在SQL中,建立表用的命令是()。
A.CREATE SCHEMA
B.CREATE TABLE
C.REATE VIEW
D.CREATE INDEX
第7题:
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?()
第8题:
不属于数据定义功能的SQL语句是______。
A.CREATE TABLE
B.CREATE VIEW
C.UPDATE
D.CREATE INDEX
第9题:
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? ()
第10题:
在SQL中,建立视图用的命令是()。