网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
下列关于CREATE UNIQUE INDEX IDX1 ON T(C1，C2)语句作用的说法，正确的是（）。
- A、在C1和C2列上分别建立一个唯一聚集索引
- B、在C1和C2列上分别建立一个唯一非聚集索引
- C、在C1和C2列的组合上建立一个唯一聚集索引
- D、在C1和C2列的组合上建立一个唯一非聚集索引
参考答案
更多 “下列关于CREATE UNIQUE INDEX IDX1 ON T(C1，C2)语句作用的说法，正确的是（）。A、在C1和C2列上分别建立一个唯一聚集索引B、在C1和C2列上分别建立一个唯一非聚集索引C、在C1和C2列的组合上建立一个唯一聚集索引D、在C1和C2列的组合上建立一个唯一非聚集索引” 相关考题
考题
根据SQL标准，要创建唯一索引该使用下面哪种语句?()A CREATE UNIQUE INDEXB CREATE CLUSTER INDEXC CREATE ONLY INDEXD CREATE PRIMARY INDEX
考题
在SQL Server 2000的某用户数据库中，设有T表，现要在T表的c1列和c2列上建立一个复合唯一聚集索引，其中c1列值重复率为20%，c2列为10%。请补全下列语句建立一个性能最优的索引：CREATE UNIQUE CLUSTERED INDEX Idx1 ON T(______)
考题
下面所列条目中，（ ）不是标准的SQL语句。A．DELETE INDEX B．CREATE INDEXC．DELETE FROM D．CREATE UNIQUE CLUSTER INDEX
考题
Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）A.CREATE UNIQUE INDEX idx_partno ON parts(part_no)B.CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)C.CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)D.CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
考题
在表S中对学号SN按升序建立名为SNINDEX的索引，正确的是______。A．CREATE INDEX SNINDEX WITH S(SN)B．CREATE UNIQUE INDEX SNINDEX ON S(SN)C．CREATE SNNIDEX ON S(SN)D．CREATE SNINDEX INDEX ON S(SN)
考题
在Oracle中,你需要创建索引提高薪水审查的性能,该审查要对员工薪水提高12个百分点后进行分析处理,下面哪个createindex命令能解决此问题()。
A.CREATE INDEX my_idx_1 ON employee（salary*1.12）B.CREATE UNIQUE INDEX my_idx_1 ON employee（salary）C.CREATE BITMAP INDEX my_idx_1 ON employee（salary）D.CREATE INDEX my_idx_1 ON employee（salary）REVERSE
考题
在SQL Server 2008中，设有商品表(商品号，商品名，生产日期，单价，类别)。现经常需要执行下列查询： SELECT 商品号, 商品名, 单价 FROM 商品表 WHERE 类别 IN (′食品′,′家电′) ORDER BY 商品号 现需要在商品表上建立合适的索引来提高该查询的执行效率。下列建立索引的语句，最合适的是( )。A.CREATE INDEX Idx1 ON 商品表(类别)B.CREATE INDEX Idx1 ON 商品表(商品号,商品名,单价)C.CREATE INDEX Idx1 ON 商品表(类别,商品号,INCLUDE (商品名,单价)D.CREATE INDEX Idx1 ON 商品表(商品号,INCLUDE (商品名,单价,WHERE 类别 = '食品' OR 类别 = '家电'
考题
创建索引的语法是什么（）A、CREATE INDEX索引名ON表名（列名）B、CREATE INDEX ON表名（列名）C、CREATE索引名INDEX ON表名.列名D、CREATE OR REPLACE INDEX索引名ON表名（列名）
考题
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?（）A、CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3) B、CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3) C、CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1) D、CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)
考题
Examine the command that is used to create a table： SQL CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）A、A CHECK constraint is created on the OID column.B、A NOT NULL constraint is created on the OID column.C、The ORDERS table is the only object created in the USERS tablespace.D、The ORDERS table and a unique index are created in the USERS tablespace.E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
考题
For which two constraints does the Oracle Server implicitly create a unique index? （）A、NOT NULLB、PRIMARY KEYC、FOREIGN KEYD、CHECKE、UNIQUE
考题
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1 and C2 together, which statement(s) will create index(es) that will provide optimal query performance? （）A、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1) include (c2)B、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c3) INCLUDE (c2) C、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2, c1)D、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1）
考题
SQL语言中建立惟一性索引的命令是（）A、CREATE INDEX索引名ON基本表名（属性名）B、CREATE INDEX UNIQUE索引名ON基本表名（属性名）C、CREATE UNIQUE INDEX索引名ON基本表名（属性名）D、CREATE DISTINCT INDEX索引名ON基本表名（属性名）
考题
Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）A、CREATE UNIQUE INDEX idx_partno ON parts(part_no)B、CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)C、CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)D、CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
考题
Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）A、 It would be created only if a unique index is manually created first.B、 It would be created and would use an automatically created unique index.C、 It would be created and would use an automatically created nonunique index.D、 It would be created and remains in a disabled state because no index is specified in the command.
考题
在Oracle中，你需要创建索引提高薪水审查的性能，该审查要对员工薪水提高12个百分点后进行分析处理，下面哪个createindex命令能解决此问题（）。A、CREATE INDEX my_idx_1 ON employee（salary*1.12）B、CREATE UNIQUE INDEX my_idx_1 ON employee（salary）C、CREATE BITMAP INDEX my_idx_1 ON employee（salary）D、CREATE INDEX my_idx_1 ON employee（salary）REVERSE
考题
Which two statements are true about constraints? （）A、The UNIQUE constraint does not permit a null value for the column.B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.D、The NOT NULL constraint ensures that null values are not permitted for the column.
考题
多选题For which two constraints does the Oracle Server implicitly create a unique index? （）ANOT NULLBPRIMARY KEYCFOREIGN KEYDCHECKEUNIQUE
考题
单选题Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?（）A
CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3) B
CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3) C
CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1) D
CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)
考题
多选题Examine the command that is used to create a table： SQL CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）AA CHECK constraint is created on the OID column.BA NOT NULL constraint is created on the OID column.CThe ORDERS table is the only object created in the USERS tablespace.DThe ORDERS table and a unique index are created in the USERS tablespace.EThe ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.
考题
多选题Which two statements are true about constraints? （）AThe UNIQUE constraint does not permit a null value for the column.BA UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.CThe PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.DThe NOT NULL constraint ensures that null values are not permitted for the column.
考题
单选题Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）A
CREATE UNIQUE INDEX idx_partno ON parts(part_no)B
CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)C
CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)D
CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
考题
单选题Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）A
It would be created only if a unique index is manually created first.B
It would be created and would use an automatically created unique index.C
It would be created and would use an automatically created nonunique index.D
It would be created and remains in a disabled state because no index is specified in the command.
考题
单选题下列关于CREATE UNIQUE INDEX IDX1 ON T(C1，C2)语句作用的说法，正确的是（）。A
在C1和C2列上分别建立一个唯一聚集索引B
在C1和C2列上分别建立一个唯一非聚集索引C
在C1和C2列的组合上建立一个唯一聚集索引D
在C1和C2列的组合上建立一个唯一非聚集索引
热门标签
最新试卷