IBM DB2 9.7 Advanced DBA for LUW 認定 C2090-544 試験問題:

1. 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) db2acsutil
C) db2dart
D) db2pd

2. Click the Exhibit button.

Refer to the table definition shown in the exhibit.
Which will improve performance based on the query SELECT c6, c9 FROM tab3 WHERE c9 = 123456?

A) CREATE INDEX idx98 ON tab3 (c2 ASC, c6 ASC); CREATE INDEX idx99 ON tab3 (c2 ASC, c9 ASC); RUNSTATS ON TABLE myschema.tab3;
B) CREATE INDEX idx99 ON tab3 (c6 ASC, c9 DESC); REORG TABLE myschema.tab3 AND INDEXES ALL;
C) CREATE INDEX idx99 ON tab3 (c2 ASC, c9 DESC); REORG TABLE myschema.tab3 AND INDEXES ALL;
D) CREATE INDEX idx98 ON tab3 (c6 ASC); CREATE INDEX idx99 ON tab3 (c9 DESC); RUNSTATS ON TABLE myschema.tab3;

3. Which command will prevent prefetching during crash recovery?

A) db2set DB2_RECOVERY_PREFETCHING=NO
B) db2set DB2_AVOID_PREFETCH=OFF
C) db2set DB2_RECOVERY_PREFETCHING=YES
D) db2set DB2_AVOID_PREFETCH=ON

4. Which factor should influence your selection of distribution key(s)?

A) The distribution key(s) should include the most frequently joined column(s).
B) The distribution key(s) should include the most frequently accessed XML column(s).
C) The distribution key(s) should include the longest column(s).
D) The distribution key(s) should include column(s) with the smallest number of distinct values.

5. When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?

A) It terminates immediately.
B) It remains active as long as the MAXAGENTS setting is not exceeded.
C) It is placed in the agent pool if the connection is terminated.
D) It automatically releases the database connection and returns to the pool.

質問と回答：