The DBA can set the registry variable DB2_HASH_JOIN on or off because: – McqOptions

MCQOPTIONS

1.	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» B. hash joins are not used unless outer joins are requested.

Discussion

No Comment Found

Related MCQs

With database logging, where are transaction records first placed?
Which statement fragments a table as round robin?
Which of the following tools can be used to identify inefficient SQL statements without executing them?
Which statement correctly changes the next extent size?
which of the following represents a set of properties that guarantee that database transactions are processed reliably in computer science ?
Which of the following tools is used to create subscription sets and add subscription?set members to subscription sets?
Which of the following extenders allows data to be presented in a three dimensional format?
Which of the following commands will allow a Linux on iSeries administrator to quickly scan backup tapes for files saved via a tar command on a Linux system?
Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?
Where is fragment information stored?