December 04, 2007
Practice for the DB2 9 DBA certification exam by trying your hand at these two sample questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted here with permission. Check back each week for more, and try past questions here.
QUESTION 3
A user issues the following commands:
UPDATE DBM CFG USING DFT_MON_SORT ON;
UPDATE MONITOR SWITCHES USING UOW ON;
UPDATE DBM CFG USING DFT_MON_TIMESTAMP ON;
UPDATE MONITOR SWITCHES USING BUFFERPOOL ON;
Assuming no other monitor switches have been set, if the DB2 instance is stopped and restarted, which of the following database monitor switches will be set?
A. SORT, UOW
B. UOW, BUFFERPOOL
C. SORT, TIMESTAMP
D. TIMESTAMP, BUFFERPOOL
QUESTION 4
Which of the following is NOT a true statement about the Import utility?
A. Worksheet Format (WSF) formatted files are supported.
B. All row transactions are recorded in the database’s transaction log files.
C. System catalog tables can be targets.
D. Data can be imported into a host database through DB2 Connect.
Answers
QUESTION 3
The correct answer is C. Snapshot monitor switch settings can be changed at the instance level by modifying the appropriate DB2 Database Manager configuration parameters with the UPDATE DATABASE MANAGER CONFIGURATION command. Snapshot monitor switch settings made at the instance level remain persistent across instance restarts.
Snapshot monitor switch settings can be changed at the application level by executing the UPDATE MONITOR SWITCHES command. Switch settings made at the application level are not persistent across instance restarts.
QUESTION 4
The correct answer is C. System catalog tables cannot be modified directly by any operation, including an IMPORT operation.
Trackback Pings
TrackBack URL for this entry:
http://www.ibmdatabasemag.com/blog/main/archives/2007/12/post_10.html
« DB2 9 DBA Exam Sample Questions: Disabling the Task Center and understanding CREATE TABLESPACE options | Main | Informix Updates: New wiki, conference registration open, upcoming Webinar »
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.