IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows Sample Questions:

1. How does the DB2 Server identify the list of GSS-API plug-ins it supports?

A) by using the SRVCON_GSSPLUGIN_LIST database manager configuration parameter
B) by using the SRVSUPP_GSSPLUGIN_LIST database manager configuration parameter
C) by using the SRVCON_GSSPLUGIN_LIST registry variable
D) by using the SRVSUPP_GSSPLUGIN_LIST registry variable

2. A database named FINANCE resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which two actions must be performed before a backup image can be created in this manner? (Choose two.)

A) Workload Manager must be installed on the server.
B) DB2 Advanced Copy Services (ACS) must be installed, activated, and configured.
C) The TOOLS catalog must be created for the instance to which the database belongs.
D) The DB2 High Availability (HA) features must be available for the server.

3. BOB and ALICE moved from the DEVELOPER group to the ANALYST group.
As the security administrator, which two commands would remove Bob and Alice from the
DEVELOPER group? (Choose two.)

A) REVOKE GROUP developer FROM USER bob, USERalice
B) REVOKE ROLE developer FROM USER bob, USERalice
C) REVOKE ROLE developer FROM bob,alice
D) REVOKE GROUP developer FROM bob,alice

4. Click the Exhibit button

Referring to the exhibit, what are the minimum actions necessary to capture the maximum amount of diagnostic information in the db2diag.log file and the administration notification file?

A) UPDATE DBM CFG USING NOTIFYLEVEL 4; STOP DATABASE MANAGER; START DATABASE MANAGER;
B) UPDATE DBM CFG USING DIAGLEVEL 3; UPDATE DBM CFG USING NOTIFYLEVEL 4;
C) UPDATE DBM CFG USING DI AG LEVEL 4
D) UPDATE DBM CFG USING NOTIFYLEVEL4

5. Click the Exhibit button
Given the INSERT statements shown below:
INSERT INTO applicant VALUES (1 ,'M' 54); INSERT INTO applicant VALUES (2, 'F', 38); INSERT INTO applicant VALUES (3, 'M', 21); INSERT INTO applicant VALUES (4, 'F', 91); INSERT INTO applicant VALUES (5, 'C', 50); INSERT INTO applicant VALUES (6, 'C', 70); INSERT INTO applicant VALUES (7, 'C', 95);
How many rows will be successfully inserted?

A) 1
B) 5
C) 7
D) 3

Solutions: