February 26, 2008
Here are more sample certification questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted with permission. Check back each week for more, and try past questions here.
QUESTION 17
Which of the following commands will ensure that index creation, recreation, and reorganization operations against a database named SAMPLE will be logged so that indexes can be reconstructed during roll-forward recovery operations or high availability disaster recovery (HADR) log replay procedures?
A. UPDATE DB CFG FOR sample USING INDEXREC ON
B. UPDATE DB CFG FOR sample USING LOGINDEXMAINT ON
C. UPDATE DB CFG FOR sample USING INDEXOPS ON
D. UPDATE DB CFG FOR sample USING LOGINDEXBUILD ON
QUESTION 18
Which of the following privileges allows a user to generate a package for an embedded SQL application and store it in a database?
A. BIND
B. BINDADD
C. CREATE_EXTERNAL_ROUTINE
D. CREATE_NOT_FENCED_ROUTINE
Answers
QUESTION 17
The correct answer is D. While the indexrec parameter of the database or the DB2 Database Manager configuration file can be used to control when indexes are rebuilt as part of a crash recovery operation, it has no affect on how indexes are rebuilt during roll-forward recovery operations. To control that behavior, you must assign the appropriate value to the logindexbuild database configuration parameter. There are two possible settings for this parameter:
ON. Index creation, recreation, and reorganization operations are to be recorded in the database’s transaction log files so indexes can be reconstructed during roll-forward recovery operations or high availability disaster recovery (HADR) log replay operations.
OFF. Index creation, recreation, and reorganization operations will not be rec-orded in the database’s transaction log files.
QUESTION 18
The correct answer is B. The BINDADD database privilege allows a user to create packages in the database (by precompiling embedded SQL application source code files against the database or by binding application bind files to the database).
The BIND package privilege allows a user to rebind or add new package versions to a package that has already been bound to a database. (In addition to the BIND package privilege, a user must hold the privileges needed to execute the SQL statements that make up the package before the package can be successfully rebound.) The CREATE_EXTERNAL_ROUTINE database privilege allows a user to create user-defined functions (UDFs) and/or procedures and store them in the database so that they can be used by other users and applications. The CREATE_NOT_FENCED_ROUTINE database privilege allows a user to create unfenced UDFs and/or procedures and store them in the database. (Unfenced UDFs and stored procedures are UDFs/procedures that are considered “safe” enough to be run in the DB2 Database Manager operating environment’s process or address space. Unless a UDF/procedure is registered as unfenced, the DB2 Database Manager insulates the UDF/procedure’s internal resources in such a way that they cannot be run in the DB2 Database Manager’s address space.)
Trackback Pings
TrackBack URL for this entry:
http://www.ibmdatabasemag.com/blog/main/archives/2008/02/post_3.html
« DB2 Magazine is now IBM Database Magazine | Main | DB2 DBA asks: Is database administrator the right title for the job? »
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.