March 20, 2008
Spring is here, and daylight is lasting longer. Why not use the extra time to prepare for the DB2 9 DBA certificiation exam? 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 and reprinted with permission. Check back each week for more, and try past questions here.
QUESTION 23
The following command was executed in an attempt to return a database named SAMPLE to the state it was in at 9:30 AM on July 1, 2007:
ROLLFORWARD DB sample TO 2007-07-01-09.30.00.000000 AND STOP
During execution, the following error was returned:
SQL4970N Roll-forward recovery on database SAMPLE cannot reach the specified stop point (end-of-log or point-in-time) because of missing or corrupted log file(s) on database partition(s) “0”. Roll-forward recovery processing has halted on log file S0000007.LOG.
Which of the following options can be added to the ROLLFORWARD command to resolve the problem?
A. END OF LOGS
B. OVERFLOW LOG PATH
C. ALTERNATE LOG PATH
D. MIRROR LOG PATH
QUESTION 24
User USER1 needs to remove a view named ORDERS_V, which is based on a table named ORDERS, from the SALES database. Assuming user USER1 does not hold any privileges, which of the following privileges must be granted before user USER1 will be allowed to drop the view?
A. DROP privilege on the ORDERS_V view
B. CONTROL privilege on the ORDERS table
C. DROP privilege on the ORDERS_V view
D. CONTROL privilege on the ORDERS_V view
Answers
QUESTION 23
The correct answer is B. The OVERFLOW LOG PATH option of the ROLLFORWARD DATABASE command is used to identify the directory that contains offline archived log files that are to be used to perform the roll-forward operation. The Roll-forward utility looks in the active log directory first, and then in the directory specified with the OVERFLOW LOG PATH option for log files need to perform a roll-forward recovery operation.
QUESTION 24
The correct answer is D. The CONTROL view privilege provides a user with every view privilege available, allows the user to remove (drop) the view from the database, and gives the user the ability to grant and revoke one or more view privileges (except the CONTROL privilege) to/from other users and groups.
Trackback Pings
TrackBack URL for this entry:
http://www.ibmdatabasemag.com/blog/main/archives/2008/03/db2_9_for_linux.html
« DB2 LUW Performance: Direct I/O Times | Main | DB2 LUW Performance: The Death of DB2 »
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.