移动端

  • 题王微信公众号

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

计算机考试 | IBM认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

单选题 Which data organization schemes are supported?()

A

PARTITION BY HASH and ORGANIZE BY  

B

PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE  

C

PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE 

D

PARTITION BY RANGE and ORGANIZE BY

单选题 Which action(s) will cause a compression dictionary to be removed from a table?()

A

Set the table COMPRESS attribute to NO.  

B

Set the table COMPRESS attribute to NO; run REORG against the table.  

C

Set the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table.  

D

Set the table COMPRESS attribute to NO; run RUNSTATS against the table.

单选题 When is the connection concentrator enabled?()

A

When the value of MAX_CONNECTIONS is greater than the value of MAX_COORDAGENTS.  

B

When the value of MAX_AGENTS is greater than the value of MAX_CLIENTS.  

C

When the value of NUM_AGENTS is greater than the value of MAX_AGENTS. 

D

When the value of NUM_CONNECTIONS is greater than the value of NUM_COORDAGENTS.

多选题 In which two environments would intra-partition parallelism be used? ()

A

Single database partition, single processor  

B

Single database partition, multiple processors  

C

Multiple database partitions, single processor  

D

Multiple database partitions, multiple processors

单选题 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)

单选题 If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?()

A

All sorts will be done in a temporary table space.  

B

The shared sort memory allocation will be calculated by DB2

C

No shared memory is allocated for sorting.  

D

All sorts will be done in shared memory.

单选题 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)

单选题 If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? ()

A

All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.  

B

Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.  

C

Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.  

D

A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.

多选题 Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful?()

A

INTRA_PARALLEL NO  

B

MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100  

C

MAX_AGENTS 100, MAX_CONNECTIONS 2000 

D

MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000  

E

INTRA_PARALLEL YES 

1 2 下一页 尾页 /

到第