IBM Certification Question:
Download Questions 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

Answer:

A.Equijion predicates

Download IBM Certification Interview Questions And Answers PDF

Previous QuestionNext 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