1.
After using the lock event monitor to capture binary lock event data in an unformatted event table, you can convert the data into an XML or text document using which of the following Java-based tools?
2.
Which of the following is NOT a valid workload name?
3.
If the statement concentrator is enabled and dynamic SQL is running, which statement is correct?
4.
A database administrator wants to prune the Recovery History file for the SAMPLE database so that all objects older than February 1, 2008 (including those marked DB2HISTORY_STATUS_DO_NOT_DELETE) are removed from the file. Which commands will ensure all related recovery objects are automatically removed by DB2?
5.
Which command will enable reads on an High Availability and Disaster Recovery (HADR) standby server?
6.
The SAMPLE database is backed up and the recovery logs are included in the backup image. Which of the following actions is required to restore the database to the end of the backup?
7.
Which of the following SQL statements will return monitoring information of all indexes in the DB2USER schema that have greater than 100 index scans?
8.
Which command is utilized to deactivate the CognosAPP statistics event monitor and stop it from collecting extended aggregate activity data for a given workload?
9.
Which command/statement is used to implement Currently Committed (CC) semantics behavior on an application-by-application basis?
10.
Which command will activate the statement concentrator?