IBM Certified System Programmer - IBM IMS - C2090-549 Exam Practice Test

Question 1

Click the Exhibit button.
Referring to the exhibit, which statement related to DB2 storage usage is correct?

A. The system is doing ok on virtual storage but is clearly short on real storage because the total amount of real storage is more than 2 G

B. DB2 statistics do not provide accurate information about the real storage usage. The only reliable source of information are RMF statistics.

C. The DBM1 address space does not seem to do any paging, but the MSTR address space seems to suffer from paging.

D. The system is over committed on virtual storage as it has more than 2 GB of real storage allocated in the DBM1 address space.

Correct Answer: C

Question 2

An accounting trace shows a high get page per SQL ratio for a query which retrieves just one row each time it is executed. Which two situations could account for the high ratio? (Choose two.)

A. Use of an index with high cardinality.

B. Use of a single column index that is a GENERATED ALWAYS identity column.

C. Use of an index with low cardinality.

D. Use of a matching unique index scan.

E. Use of a nonmatching index scan.

Correct Answer: C,E

Question 3

The command -START DB2 LIGHT(YES) was entered. Which two main objectives were achieved by this command? (Choose two.)

A. to use less storage

B. to quickly bring up DB2 for the user access

C. to prohibit access to any users other than installation SYSADM and SYSOPR

D. to release retained locks

E. to start DB2 without allowing for in-doubt thread resolution

Correct Answer: A,D

Question 4

The group buffer pool structures, GBP0, GBP1, and GPB2 reside in CF1 for a data sharing group DG0P. The LOCK and the LIST structures reside in CF2. AUTOREC is set to YES. The group buffer pools are not duplexed. CF1 fails due to a microcode problem and noneof the GBPs are available. Which statement is true?

A. DB2 is able to continue without the GBPs.

B. DB2 automatically rebuilds the GBPs based on information kept in the local buffer pools.

C. DB2 initiates automatic GRECP recovery, after it has been restarted.

D. DB2 automatically recovers since AUTOREC is set to YES.

Correct Answer: D

Question 5

The DISPLAY DATABASE command is issued and you see that there are several objects in GRECP status. What should you do to correct the problem?

A. Run the REPAIR utility against the objects with GRECP status to change the status.

B. Run the MODIFY utility against the objects with GRECP to correct the status.

C. Issue a START DATABASE command specifying the objects with GRECP status.

D. Set the DSNZPARM AUTOREC to YES and DB2 will automatically correct the status.

Correct Answer: C

Question 6

What are three characteristics of DB2 9 native SQL procedures? (Choose three.)

A. Requires SPAS.

B. Runs entirely within DB2.

C. Ability to define multiple versions.

D. Could be zIIP eligible if it is a DDF request using DRDA.

E. Requires a WLM-managed address space.

Correct Answer: B,C,D

Question 7

What does the STRINGMX statement in the DSFVSMxx member specify?

A. The number of VSAM requests that can be concurrently active.

B. The characteristics of the buffers in the VSAM pool.

C. The length of the DASD channel supported.

D. The characteristics of the buffers in the OSAM pool.

Correct Answer: A

Question 8

A customer is performing a traditional image copy disaster recovery test. The systems programmer creates a conditional restart control record (CRCR) but detects an error before starting DB2. Which action should be performed to correct the CRCR record?

A. First use CRESTART,DELETE to delete the error CRCR record then CRESTART,CREATE to add a new one.

B. Use CRESTART,MODIFY to modify the parameters of the error CRCR record.

C. Use CRESTART,CREATE to create a new CRCR record.

D. Start DB2, reply "M" to the WTOR that is displayed from the first CRCR record to modify the CRCR parameters.

Correct Answer: C

IBM Certified System Programmer - IBM IMS - C2090-549 Exam Practice Test

Latest Update

Useful Links

Contact Us