Sawaal
  • Home/
  • Searching for B

 Searching for "B"

Q:

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 & Explanation Answer: A) hash joins may require more resources to run.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

Which of the following extenders allows data to be presented in a three dimensional format?

A) DB2 AVI Extender B) DB2 XML Extender
C) DB2 Text Extender D) DB2 Spatial Extender
 
Answer & Explanation Answer: D) DB2 Spatial Extender

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

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
 
Answer & Explanation Answer: A) /var/log/messages

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

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

Q:

Suppose a System z customer has a new CIO. The CIO is concerned about continuing operations and recovery following a catastrophe.Which of the following addresses this issue?

A) GDPS B) TAM
C) DR D) WASS
 
Answer & Explanation Answer: A) GDPS

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

 Which isolation level does a database without logging default to?

A) committed read B) dirty read
C) mode ANSI D) repeatable read
 
Answer & Explanation Answer: B) dirty read

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

Which of the following tools can be used to identify inefficient SQL statements without executing them?

A) QMF B) Task Center
C) Visual Explain D) Development Center
 
Answer & Explanation Answer: C) Visual Explain

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

Which of the following tools is used to create subscription sets and add subscription?set members to subscription sets?

A) Journal B) License Center
C) Replication Center D) Development Center
 
Answer & Explanation Answer: C) Replication Center

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification