November 25, 2008
Here are the latest sample questions to help you prepare for DB2 9 DBA certification testing. Once you've mastered these, browse past questions here. Several recent entries contain additional clarification in the comments section; reading through the comments might add to your own understanding.
All questions are from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, and are reprinted with permission. Check back each week for more.
QUESTION 55
Which of the following commands can be used to obtain information about how memory has been allocated for a database named SAMPLE?
A. GET DB CFG FOR sample SHOW DETAIL
B. GET MEMORY USAGE FOR sample
C. GET DBM CFG
D. GET CFG DETAILS FOR sample
QUESTION 56
Which of the following options can be used with the REORG command to construct a new compression dictionary before compressing data stored in a table?
A. KEEPDICTIONARY
B. RESETDICTIONARY
C. GENERATEDICTIONARY
D. NEWDICTIONARY
Answers
QUESTION 55
The correct answer is A. The contents of the database configuration file for a particular database can be displayed by executing the GET DATABASE CONFIGURATION command. The syntax for this command is:
GET [DATABASE | DB] [CONFIGURATION | CONFIG | CFG]
FOR [DatabaseAlias]
<SHOW DETAIL>
where:
DatabaseAlias identifies the alias assigned to the database that configuration information is to be displayed for.
Thus, if you want to view the contents of the database configuration file for a database named SAMPLE, you could do so by executing a GET DATABASE CONFIGURATION command that looks like this:
GET DB CFG FOR sample SHOW DETAIL
QUESTION 56
The correct answer is B. A compression dictionary is built (and data in a table is compressed) by performing an offline table reorganization operation; such an operation is initiated by executing the REORG command with either the KEEPDICTIONARY or the RESETDICTIONARY option specified. If the REORG command is executed with either option specified and a compression dictionary does not exist, a new dictionary will be built; if the REORG command is executed with either option specified and a dictionary already exists, data in the table will be reorganized/compressed and the existing dictionary will either be recreated (RESETDICTIONARY) or left as it is (KEEPDICTIONARY).
Trackback Pings
TrackBack URL for this entry:
http://www.ibmdatabasemag.com/blog/main/archives/2008/11/db2_9.html
« IBM Database Magazine gets social on Facebook | Main | DB2 LUW Performance: A Self Tuning Memory Manager Case Study »
This is a public forum. CMP Media and its affiliates are not responsible for and do not control what is posted herein. CMP Media makes no warranties or guarantees concerning any advice dispensed by its staff members or readers.
Community standards in this comment area do not permit hate language, excessive profanity, or other patently offensive language. Please be aware that all information posted to this comment area becomes the property of CMP Media LLC and may be edited and republished in print or electronic format as outlined in CMP Media's Terms of Service.
Important Note: This comment area is NOT intended for commercial messages or solicitations of business.