默认题库 - IBM(000-734)

多选题

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&e

查看答案

单选题

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 partitio

查看答案

单选题

When is the connection concentrator enabled?（）

A. When the value of MAX_CONNECTIONS is greater than the value of MAX_COORDAGENT
B. When the value of MAX_AGENTS is greater than the value of MAX_CLIENT
C. When the value of NUM_AGENTS is greater than the value of MAX_AGENT
D. When the value of NUM_CONNECTIONS is greater than the value of NUM_COORDAGENT

查看答案

多选题

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 processor

查看答案

单选题

A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）

A. db2advis -d proddb -i workload.sql -P
B. db2advis -d proddb -i workload.sql -partitioning
C. db2advis -d proddb -i workload.sql -m P
D. db2advis -d proddb -i workload.sql -m ALL&e

查看答案

单选题

If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）

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.

查看答案

单选题

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.&e

查看答案

多选题

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&e

查看答案