DB2 9.7 DBA for Linux UNIX and Windows (C2090-541) Free Practice Test

Question 1

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

A. by using the SRVSUPP_GSSPLUGIN_LIST registry variable

B. by using the SRVCON_GSSPLUGIN_LIST database manager configuration parameter

C. by using the SRVSUPP_GSSPLUGIN_LIST database manager configuration parameter

D. by using the SRVCON_GSSPLUGIN_LIST registry variable

Correct Answer: B

Question 2

Click the Exhibit button.

IBM 000-541: Practice Exam
Refer to the logging configuration parameters shown in the exhibit.
What will happen if there are currently 100 active log files and DB2 needs to create log file 101?

A. At least one application will receive a "log full" error and at least one transaction will be rolled back because the active log space is full.

B. Log file 101 will be successfully created in the primary log path since infinite logging has been enabled. Applications will continue processing normally.

C. Log file 101 will go into the OVERFLOWLOGPATH directory since the active log space is full and infinite logging has been enabled.

D. The database will appear to be hung since the active log space is full and the BLK_LOG_DSK_FUL parameter is set to YES.

Correct Answer: B

Question 3

Click the Exhibit button.

IBM 000-541: Practice Exam
Given the TCP/IP configuration shown in the exhibit, to what must the alternate server be set on the Primary, to allow Automatic Client Reroute to connect to the Standby after a HADR takeover?

A. 192.168.1.1

B. 192.168.1.102

C. 192.168.2.1

D. 192.168.2.102

Correct Answer: D

Question 4

The event monitor for transactions has been replaced in DB2 9.7 with which tool?

A. db2top

B. MON_GET_ACTIVITY_DETAILS table function

C. db2evmonfmt

D. MON_GET_WORKLOAD table function

Correct Answer: D

Question 5

Which statement is correct about using the TAKEOVER HADR command?

A. The TAKEOVER HADR command can only be issued on the standby database and the primary database is not connected to the standby database when the command is issued.

B. The TAKEOVER HADR command can only be issued to switch the roles of the primary and standby databases if the databases are in peer state.

C. The TAKEOVER HADR command can only be issued to switch the roles of the primary and standby databases if the standby database is in local catchup state.

D. The TAKEOVER HADR command can only be issued on the primary database and the primary database is connected to the standby database when the command is issued.

Correct Answer: B

Question 6

What are three authorization categories in DB2? (Choose three.)

A. System-level

B. Object-level

C. Network-level

D. Database-level

E. Instance-level

Correct Answer: A,B,D

Question 7

A database named PAYROLL resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which command can be used to accomplish this?

A. BACKUP DATABASE payroll USE XBSA

B. BACKUP DATABASE payroll USE FU\SHCOPY

C. BACKUP DATABASE payroll USE MIRROR

D. BACKUP DATABASE payroll USE SNAPSHOT

Correct Answer: D

Welcome to TestSimulate

IBM DB2 9.7 DBA for Linux UNIX and Windows (C2090-541) Free Practice Test