IBM 000-732 from pass4sure

Pass4sure provides free demos for all exams sell on the website, it’s the interactive test engine shows the Q&As, the users can download IBM 000-732 demo from pass4sure and install it to test the quality. If one knows the test well, he will know how great the quality is, but for those who have little idea about IBM 000-732, they can also weigh the qulity after wrote the exam!
Try some samples here:
1.Which of the following DSNZPARMs is necessary to influence access path selection for certain queries?

A: STDSQL
B: OPTHINTS
C: PARTKEYU
D: DESCSTAT
Correct Answers: B

2.What is the most efficient way to determine successful completion, end of file, and number of rows returned after a multi-row fetch operation?

A: Use the GET DIAGNOSTICS statement.
B: Count the number of present values in the result set array.
C: Interpret the SQLCODE and SQLERRD3 fields of the SQLCA.
D: Use the GET DIAGNOSTICS FOR CONDITION 1 statement.
Correct Answers: C

3.The key indicator “Prefetch disabled – No read engine” is an important performance metric. What does it indicate?

A: The sequential prefetch threshold has been reached
B: A need to increase the # of read engines in the dsnzparm to a higher value
C: The size of the buffer is small thus does not accommodate minimum prefetch quantity
D: I/O subsystem contention that is not allowing prefetch to complete fast enough and all the engines have requests queued waiting for completion
Correct Answers: D

4.Exception processing is an efficient way to monitor DB2 subsystems for performance problems. When exception processing is active, a DBA is informed when certain events occur, or when specific thresholds have been exceeded. In which of the following options can a DBA performance specialist set up exception processing?

A: RMF
B: Tivoli NetView
C: DB2 PE/OMEGAMON
D: DSNC DISPLAY STATISTICS
Correct Answers: C