分类：
2011-01-24 10:22:00
IBM DB2认证之考试题库由我们专业IT认证讲师及产品专家精心打造，包括了当前最新的全真考试试题，全部附有正确答案。
KillTest 000-544试题是考试原题的完美组合，覆盖率达96%以上，答案由多位专业资深讲师原版破解得出，正确率100%。并且随着考试认真厂商对考题做出的变化而及时更新，最终确保考生能一次通过考试！
题库的部分题目分享如下：
1. A DBA needs to create a federated database and configure access to join data from three Oracle instances and one DB2 database.
Which objects are needed to establish the specified connections?
A. 1 Oracle server , 1 DB2 server , 3 Oracle wrappers , and nicknames for each database
B. 1 Oracle server , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each database
C. 3 Oracle servers , 1 DB2 server , 3 Oracle wrappers , 1 DB2 wrapper , and nicknames for each database
D. 3 Oracle servers , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each database
Answer: D
2. How can you change an existing non-partitioned index for a partitioned table to a partitioned index?
A. Use the ALTER INDEX command.
B. Use the DROP INDEX and CREATE INDEX commands.
C. Use the REORG INDEX command.
D. Use the ALTER INDEX and REORG INDEX commands.
Answer: B
3. Database DB1 is defined on partitions 1 through 4, with the system catalog defined on partition 2. This database is configured with LOGRETAIN=YES and TRACKMOD=YES. On Sunday evening, a full online database backup completes successfully on all partitions. On Monday afternoon, a new table space is created in a database partition group defined on partitions 3 and 4. On Monday evening a backup is executed as follows :
BACKUP DATABASE db1 ONLINE INCREMENTAL
What are the results of this operation?
A. The backup completes successfully on the catalog partion only.
B. The backup completes successfully on database partitions 1 and 2, but fails on database partitions 3 and 4.
C. The backup completes successfully on database partitions 3 and 4, but fails on database partitions 1 and 2.
D. The backup completes successfully on all database partitions.
Answer: B
4. Which command produced the result shown below?
Tracking Memory on: 2010/02/18 at 21:18:19
Memory for database: SAMPLE
bph (2) utilh pckcacheh catcacheh bph (1) bph (S32K) bph (S16K)
4.2M 64.0K 256.0K 64.0K 288.0M 704.0K 448.0K
bph (S8K) bph (S4K) shsorth lockh dbh other
320.0K 256.0K 64.0K 10.0M 4.7M 128.0K
A. db2mtrk -i
B. db2mtrk -d
C. db2mtrk -p
D. db2mtrk -a
Answer: B
5. Considering you have an OLTP workload consisting of similar queries that are repeatedly generated and differ only in their predicate values, what can be done to reduce compilation overhead?
A. UPDATE DB CFG USING STMT_CONC LITERALS
B. UPDATE DB CFG USING SQL_CONC LITERALS
C. UPDATE DB CFG USING SQL_CONC YES
D. UPDATE DB CFG USING STMT_CONC OFF
Answer: A
6. A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?
A. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it.
B. The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.
C. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary.
D. The index will automatically be enabled for compression because the associated table is compressed;
however, the index will not be compressed until it is REORGed.
Answer: B
如需下载更多完整的DB2认证方面的题库，可登陆！
