IBM 000-544 問題集

質問 1：
When the DBA chooses the dimensions for a multi-dimensional clustering (MDC) table, which two characteristics should be considered? (Choose two.)
A. numeric data versus character data
B. the combined cardinality of the candidate columns
C. prefetch size
D. the query transaction rate
E. extent size
正解：B,E

質問 2：
Which action can be performed by the ALTER TABLESPACE statement?
A. Change an SMS table space to a DMS table space on any database partition.
B. Change the size of a container in an SMS table space.
C. Add a container to an SMS table space on a database partition that currently has no containers.
D. Change the EXTENTSIZE setting for a table space on a database partition that currently has no containers.
正解：C

質問 3：
Table T1 was created by executing the following statement:

Immediately after creation, table T1 was populated with 10 rows. Later, user USER1 ran an application that inserted 100,000 rows into table T1. The following query is frequently ran against the T1 table:
SELECT deptno, empno, deptname FROM t1 WHERE deptno = 'EN' AND empno = '123' Assuming current statics exist for the table and index, which index will provide optimal performance for this query?
A. CREATE INDEX idx1 ON t1 (deptno)
B. CREATE INDEX idx1 ON t1 (deptno, empno)
C. CREATE INDEX idx1 ON t1 (deptno) INCLUDE (empno)
D. CREATE INDEX idx1 ON t1 (deptno, empno) INCLUDE (deptname)
正解：B

質問 4：
Which database manager configuration parameter is used to set an instance-wide soft limit on the total amount of memory that can be consumed by private sorts, within that instance, at any given time?
A. SORTHEAP
B. SORTHEAP_SHR
C. SHEAPTHRES
D. SHEAPTHRES_SHR
正解：C

質問 5：
Which command CANNOT be used to create the compression dictionary for a table?
A. IMPORT
B. LOAD
C. RUNSTATS
D. INSPECT
正解：C

質問 6：
What are the steps required to remove July 2005 data from a partitioned table and replace with it with July 2010 data?
A. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Rebind the partitioned table
B. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Check constraint integrity for the partitioned table
C. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Reorg the partitioned table
D. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Update statistics on the partitioned table
正解：B

質問 7：
If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?
A. Client connections to databases on DB2INST1 will fail unless they are attempted through an LDAP connection.
B. Databases created in DB2INST1 will use KERBEROS authentication if SERVER_ENCRYPT authentication is not available.
C. Client connections from Windows machines to databases on DB2INST1 will flow clear text passwords.
D. Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication is not available.
正解：D

質問 8：
Given a database created as follows:

If each table (T1 and T2) has 50,000 rows, which of the following commands will ensure that the temporary table created by the select statement will fit entirely in the buffer pool, assuming that there is a primary key/foreign key relationship between column C1 in table T1, and column C1 in table T2?
A. CREATE BUFFERPOOL bp1 size 10000 PAGESIZE 8k;
B. CREATE BUFFERPOOL bp1 SIZE 20000 PAGESIZE 4k; ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;
C. CREATE BUFFERPOOL bp1 size 5000 PAGESIZE 16k; ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;
D. CREATE BUFFERPOOL bp1 size 25000 PAGESIZE 32k;
正解：A

質問 9：
If your DB2 server is not responding (hung), and you cannot run DB2 commands from the Command Line Processor, which utility can be used to list the applications currently connected to the database MYDB?
A. db2apptrk
B. db2dart
C. db2pd
D. db2acsutil
正解：C