3
Q:

Suppose an installed z/OS customer also has Power6 Servers. They are investigating consolidation of both types of servers to z/OS.Which of the following will establish the capacity for a new z/OS server?

A) AD Tools B) CP3000
C) Estimate the AIX load and add to CP3000 results. D) Run AIX in a z/OS LPAR to establish the loadWArialTimes New RomanZ

Answer:   C) Estimate the AIX load and add to CP3000 results.

Explanation:
Q:

With database logging, where are transaction records first placed?

A) in the logical log buffer B) in the primary chunk
C) in the physical buffer D) in a temporary database table
 
Answer & Explanation Answer: A) in the logical log buffer

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: IBM Certification

4 741
Q:

Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?

A) CLOB B) TIME
C) VARCHAR D) TIMESTAMP
 
Answer & Explanation Answer: B) TIME

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Filed Under: IBM Certification

4 836
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 Workspace Report Error Discuss

Filed Under: IBM Certification

4 754
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 Workspace Report Error Discuss

Filed Under: IBM Certification

3 866
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 Workspace Report Error Discuss

Filed Under: IBM Certification

2 553