IBM Certification Questions

Q:

Where is fragment information stored?

A) in the physical logs B) in the reserved pages
C) in the system catalog tables D) in the first page of the database tblspace
 
Answer & Explanation Answer: C) in the system catalog tables

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

1 2224
Q:

 Which of the following is required for the DB2 optimizer to consider a hash join strategy?

A) Optimization level 1 or above B) Equijion predicates
C) Registry variable DB_ANTIJOIN=YES D) SORTHEAP large enough to contain the tables being joined
 
Answer & Explanation Answer: B) Equijion predicates

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

1 2178
Q:

What help ensure that the XIV Systems cache does not become a bottleneck?

A) central cache locking mechanism B) use of industry standard chip technology
C) each module is responsible for caching the data in that module D) having all modules understand what is held cache at all times
 
Answer & Explanation Answer: C) each module is responsible for caching the data in that module

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

1 2159
Q:

A solution developer needs to configure the HTTP listener of an Integration Server on a Linux Server.

Which operating system privileges does the developer need to modify Integration node
properties and properties of integration node resources?

A) root user B) mqm
C) mqbrks D) mqm and mqbrks
 
Answer & Explanation Answer: A) root user

Explanation:
Report Error

View Answer Report Error Discuss

7 1619