移动端

  • 题王微信公众号

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

计算机考试 | IBM认证考试

模式切换

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

章节目录

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

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

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

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

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

单选题 Which server houses the database partitions in the AIX BCU V2.1? ()

A

 IBM System p5 570  

B

 IBM System p5 575  

C

 IBM System p5 590  

D

 IBM System p5 595

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

多选题 When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?()

A

the query transaction rate 

B

numeric data versus character data  

C

extent size  

D

the cardinality of the candidate columns  

E

prefetch size 

1 2 下一页 尾页 /

到第