DB2 9.7 DBA for Linux UNIX and Windows - C2090-541 Exam Practice Test

Question 1

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 MIRROR

B. BACKUP DATABASE payroll USE XBSA

C. BACKUP DATABASE payroll USE FU\SHCOPY

D. BACKUP DATABASE payroll USE SNAPSHOT

Correct Answer: D

Question 2

You are unable to configure a data source using DB2 Discovery. What are three reasons why this is happening? (Choose three.)

A. The database does not exist.

B. The database has not been cataloged.

C. A network failure exists between the control center client and the database

D. The DISCOVER_DB parameter is disabled.

E. The DISCOVERJNST parameter is enabled.

Correct Answer: A,C,D

Question 3

Which two DB2 commands are used to extract, format, and present diagnostic information? (Choose two.)

A. db2xprt

B. db2exfmt

C. db2dart

D. db2diag

Correct Answer: C,D

Question 4

Which two SOL statements are explainable statements? (Choose two.)

A. VALUES

B. CALL

C. FETCH

D. INSERT

Correct Answer: A,D

Question 5

Which two actions can you perform when using Optim Database Administrator? (Choose two.)

A. Synchronize, copy, or merge database schema definitions between DB2 Data Servers.

B. Schedule changes for DPF objects or configurations.

C. Schedule delta online backups andreorgs for different days of the week.

D. Integrate remote DB2 Command execution, such as utilities, application binding and rebinding, and data loading and unloading

Correct Answer: A,D

Question 6

Which DB2 monitoring tool command can collect data on databases, sessions, buffer pools, tables, and dynamic SQL?

A. db2top

B. db2fodc

C. db2pm

D. db2dart

Correct Answer: A

IBM DB2 9.7 DBA for Linux UNIX and Windows - C2090-541 Exam Practice Test

Latest Update

Useful Links

Contact Us