IBM Certification Question: Download IBM Certification PDF

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

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

A.Equijion predicates

Previous Question	Next Question
Explain What is database administration NOT concerned with? A. indexing B. creating tables C. accessing data D. application building	Suppose a customer is attempting to determine what failed during the last boot sequence of the Linux partition. Which of the following can be used to determine the error condition? A /var/log/messages B /proc/startup C /usr/sbin/log D /etc/boot