移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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? ()

发布日期:2022-07-16

Table TAB1 was created using the following stateme...
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)

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

IBM认证考试

IBM(000-734)

去刷题