최신 DB2 000-544 무료샘플문제:

1. 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 create index(es) that will provide optimal query performance?

A) CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1);
B) CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3);
C) CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3);
D) CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3);

2. A journaling application inserts data with continually increasing sequential keys while a clean up process randomly deletes erroneous rows. What can be done to maximize insert performance?

A) Issue a db2set DB2SKIPDELETED=ON command.
B) Issue a db2set DB2MAXFSCRSEARCH=1024 command.
C) Issue an ALTER TABLESPACE EXTEND statement.
D) Issue an ALTER TABLE APPEND ON statement.

3. Setting the DB2_FMP_COMM_HEAPSZ=0 will result in which the following?

A) In a partitioned environment, communications will not be buffered.
B) User-defined function calls will be disabled.
C) Non-fenced routines can be invoked, however automatic database maintenance will be disabled.
D) In a partitioned environment, infinite communications will be enabled between partitions.

4. 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) INCLUDE (deptname)
C) CREATE INDEX idx1 ON t1 (deptno, empno)
D) CREATE INDEX idx1 ON t1 (deptno) INCLUDE (empno)

5. An active partitioned instance named DB2INST1 uses the following db2nodes.cfg file:
1 server1 0
2 server1 1
3 server1 2
4 server1 3
The following command is issued to add a new database partition:
db2start DBPARTITIONNUM 5 ADD DBPARTITIONNUM HOSTNAME server1 PORT 4
Upon successful completion of the db2start command, which statement is true regarding the status of the instance DB2INST1?

A) Partitions 1, 2, 3, 4, and 5 are active and available.
B) DB2 responds to the configuration change by stopping all partitions.
C) Partitions 1, 2, 3, and 4 are active, but partition 5 is not.
D) All partitions are active but partition 5 is not available until a temporary table space is defined.

질문과 대답: