IBM认证考试
单选题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)? ()
单选题Which server houses the database partitions in the AIX BCU V2.1? ()
单选题If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? ()
多选题In which two environments would intra-partition parallelism be used? ()
单选题What would indicate intra-partition parallelism in an Optimizer Plan?()
单选题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?()
单选题Which registry variable should be set to keep the buffer pools in memory on AIX and Linux?()
单选题Which action(s) will cause a compression dictionary to be removed from a table?()
单选题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?()
多选题Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful?()
多选题When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?()
单选题When is the connection concentrator enabled?()
单选题Which data organization schemes are supported?()
单选题If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?()
单选题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? ()
单选题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?()