单选题 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?（）
Code the application to issue a LOCK TABLE statement.
Code the application to issue a LOCK ROW statement.
Decrease the number of I/O servers.
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? （）
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.
Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.
Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.
A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.
All sorts will be done in a temporary table space.
The shared sort memory allocation will be calculated by DB2
No shared memory is allocated for sorting.
All sorts will be done in shared memory.
When the value of MAX_CONNECTIONS is greater than the value of MAX_COORDAGENTS.
When the value of MAX_AGENTS is greater than the value of MAX_CLIENTS.
When the value of NUM_AGENTS is greater than the value of MAX_AGENTS.
When the value of NUM_CONNECTIONS is greater than the value of NUM_COORDAGENTS.
单选题 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?（）
CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3)
CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3)
CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1)
CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)
IBM System p5 570
IBM System p5 575
IBM System p5 590
IBM System p5 595
PARTITION BY HASH and ORGANIZE BY
PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE
PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE
PARTITION BY RANGE and ORGANIZE BY
多选题 When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?（）
the query transaction rate
numeric data versus character data
the cardinality of the candidate columns
Your network consists of a single Active Directory domain. The domain contains more than 300 group objects. The group objects are divided between several regional organizational units (OUs). You need to create a list of all groups that have names that begin with the word Sales. Which command should you use? （）