IBM Certification Question:
Download Questions PDF

The DBA can set the registry variable DB2_HASH_JOIN on or off because:
A. hash joins may require more resources to run.
B. hash joins are not used unless outer joins are requested.
C. If hash joins are enabled, no other join method can be used.
D. Hash joins are only needed when the tables are portioned using hash keys.

Answer:

A.Hash joins may require more resources to run.

Download IBM Certification Interview Questions And Answers PDF

Previous QuestionNext Question
Explain When creating a regular DMS table space, what is the minimum number of extents that must be specified?

A. 1
B. 3
C. 4
D. 6
E. 8
Suppose an application bound with isolation level Uncommitted Read updates a row. Which of the following is true regarding the locking of this row?
A.No row lock is acquired when the row is updated.
B.The row lock is released when the cursor accessing the row is closed.
C.The row lock is released when the application issues a COMMIT statement.
D.The row lock is released when the cursor accessing the row is moved to the next row.