IBM(000-734) 题目列表
单选题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)? （）Aone server having at least two processors Btwo servers having one processor and one logical database partition Cone server having four processors and two logical database partitions Dtwo 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）
单选题If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）AAll 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. BDatabase partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition. CAny single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance. DA database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.
单选题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?（）ACode the application to issue a LOCK TABLE statement. BCode the application to issue a LOCK ROW statement. CDecrease the number of I/O servers. DIncrease the locklist parameter.
单选题Which data organization schemes are supported?（）APARTITION BY HASH and ORGANIZE BY BPARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE CPARTITION BY HASH and ORGANIZE BY KEY SEQUENCE DPARTITION BY RANGE and ORGANIZE BY
单选题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?（）Adb2advis -d proddb -i workload.sql -P Bdb2advis -d proddb -i workload.sql -partitioning Cdb2advis -d proddb -i workload.sql -m P Ddb2advis -d proddb -i workload.sql -m ALL
单选题Which registry variable should be set to keep the buffer pools in memory on AIX and Linux?（）ADB2_KEEP_BP BDB2_PINNED_BP CDB2MEMDISCLAIM DDB2MEMMAXFREE
多选题In which two environments would intra-partition parallelism be used? （）ASingle database partition, single processorBSingle database partition, multiple processorsCMultiple database partitions, single processorDMultiple database partitions, multiple processors
多选题Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful?（）AINTRA_PARALLEL NOBMAX_CONNECTIONS 2000, MAX_COORDAGENTS 100CMAX_AGENTS 100, MAX_CONNECTIONS 2000DMAX_CONNECTIONS 500, MAX_COORDAGENTS 1000EINTRA_PARALLEL YES
单选题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?（）ACREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3) BCREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3) CCREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1) DCREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)
多选题When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?（）Athe query transaction rateBnumeric data versus character dataCextent sizeDthe cardinality of the candidate columnsEprefetch size
单选题If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）AAll sorts will be done in a temporary table space. BThe shared sort memory allocation will be calculated by DB2CNo shared memory is allocated for sorting. DAll sorts will be done in shared memory.
单选题Which action(s) will cause a compression dictionary to be removed from a table?（）ASet the table COMPRESS attribute to NO. BSet the table COMPRESS attribute to NO; run REORG against the table. CSet the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table. DSet the table COMPRESS attribute to NO; run RUNSTATS against the table.
单选题When is the connection concentrator enabled?（）AWhen the value of MAX_CONNECTIONS is greater than the value of MAX_COORDAGENTS. BWhen the value of MAX_AGENTS is greater than the value of MAX_CLIENTS. CWhen the value of NUM_AGENTS is greater than the value of MAX_AGENTS. DWhen the value of NUM_CONNECTIONS is greater than the value of NUM_COORDAGENTS.