April 16, 2008
As conference season approaches, it's time to step up your studying. Try these sample questions to help you prepare for the DB2 9 DBA certificiation exam. The questions originally appeared in 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, and try past questions here.
QUESTION 29
Which of the following commands can be used to backup a database named PAYROLL, in such a way that workloads against the database are not impacted by more than 25%?
A. BACKUP DATABASE payroll ONLINE TO D:\backups UTIL_IMPACT_PRIORITY 25
B. BACKUP DATABASE payroll ONLINE TO D:\backups UTIL_IMPACT_LIM 25
C. BACKUP DATABASE payroll ONLINE TO D:\backups UTIL_IMPACT_PRIORITY 75
D. BACKUP DATABASE payroll ONLINE TO D:\backups UTIL_IMPACT_PRIORITY 75
QUESTION 30
A user named USER1 is granted DBADM authority. Assuming no other authorities/privileges have been granted and all privileges have been revoked from the group PUBLIC, if the following SQL statement is executed:
REVOKE DBADM ON DATABASE FROM user1
What authorities/privileges will user USER1 have?
A. None
B. CONNECT
C. SYSCTRL
D. CREATETAB
Answers
QUESTION 29
The correct answer is A. The UTIL_IMPACT_PRIORITY option of the BACKUP DATABASE command is used to indicate that the execution of a backup operation is to be throttled such that its affect on concurrent database activity can be controlled. This parameter can be assigned a numerical value within the range of 1 to 100, with 100 representing the highest priority and 1 representing the lowest. (Backup operations that have been assigned a UTIL_IMPACT_PRIORITY value of 25 will impact database workloads by 25% and will take longer to complete; backup operations that have been assigned a UTIL_IMPACT_PRIORITY value of 75 will impact database workloads by 75% and will finish sooner.)
QUESTION 30
The correct answer is B. When a user is given Database Administrator (DBADM) au-thority for a particular database, they automatically receive all database privileges available for that database as well (CONNECT, CONNECT_QUIESCE, IMPLICIT_SCHEMA, CREATETAB, BINDADD, CREATE_EXTERNAL_ROUTINE, CREATE_NOT_FENCED_ROUTINE, and LOAD). When Database Administrator authority is revoked, all other database authorities that were implicitly and automatically granted when DBADM authority was granted are not automatically revoked. The same is true for privileges held on objects in the database.
Trackback Pings
TrackBack URL for this entry:
http://www.ibmdatabasemag.com/blog/main/archives/2008/04/r_sanders_12.html
« DB2 LUW Performance: Write I/O Optimization | Main | Configurable Page Size (CPS) and Informix »
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.