问题

Table TAB1 was creat

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?（）

ACREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3)
BCREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3)
CCREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1)
DCREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)

参考答案

参考解析：

分类：IBM(000-734)题库

相关推荐

1、若a=5，b=3，c=4，逻辑表达式!（a+b）&；&；!c的值

若a=5，b=3，c=4，逻辑表达式!（a+b）&；&；!c的值为（）A0B-1C1D2

2、Table TAB1 was creat

Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2&#81...

3、AMPS属于（）。

AMPS属于（）。A1GB2GC3GD4G

4、cAMP（cyclic AMP）

cAMP（cyclic AMP）