移动端

  • 题王微信公众号

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

计算机考试 | IBM认证考试

模式切换

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

章节目录

多选题 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 

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

单选题 Which registry variable should be set to keep the buffer pools in memory on AIX and Linux?()

A

DB2_KEEP_BP  

B

DB2_PINNED_BP  

C

DB2MEMDISCLAIM  

D

DB2MEMMAXFREE

多选题 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

单选题 A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? ()

A

one server having at least two processors  

B

two servers having one processor and one logical database partition  

C

one server having four processors and two logical database partitions  

D

two servers each having four processors and two logical database partitions

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

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

单选题 A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?()

A

Code the application to issue a LOCK TABLE statement.  

B

Code the application to issue a LOCK ROW statement.  

C

Decrease the number of I/O servers.  

D

Increase the locklist parameter. 

1 2 下一页 尾页 /

到第