当前分类： IBM(000-734)
问题：单选题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 new...
查看答案
问题：单选题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...
问题：单选题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 th...
问题：单选题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...
问题：多选题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...
问题：单选题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 ...
问题：单选题Which action(s) will cause a compression dictionary to be removed from a table?（）A Set the table COMPRESS attribute to NO. B Set the table COMPRESS attribute to NO; run REORG against the table. C Set the table COMPRESS attribute to NO; run INSPECTRES...
问题：单选题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...
问题：单选题What would indicate intra-partition parallelism in an Optimizer Plan?（）A BTQ B LTQ C IP D DTQ...
问题：单选题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 DB2C No shared memory is allocated for sortin...
问题：单选题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...
