IBM Certification Questions

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 2039
Q:

which of the following represents a set of properties that guarantee that database transactions are processed reliably in computer science ?

A) Buffer Cache B) ACID
C) Foreign Key D) None
 
Answer & Explanation Answer: B) ACID

Explanation:

ACID means (Atomicity, Consistency, Isolation, Durability) is a set of properties of database transactions intended to guarantee validity even in the event of errors, power failures, etc.

In the context of databases, a sequence of database operations that satisfies the ACID properties and, thus, can be perceived as single logical operation on the data, is called a transaction. For example, a transfer of funds from one bank account to another, even involving multiple changes such as debiting one account and crediting another, is a single transaction.

Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification
Job Role: Analyst , IT Trainer

5 2026
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 1997
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

6 1365