Logo ExamsQA
Exit
Official Bank 0/60

IBM DB2 11.1 DBA for LUW (C2090-600) - IBM Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
60 Total Questions
1
Question
Which statement about Data Server Manager (DSM) is TRUE?
Options
A DSM can be used for reviewing audit trails
B DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue
C DSM can be used for configuration management of DB2 Data Server drivers
D DSM cannot be used for database administration
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?
Options
A db2cluster -verify
B db2cluster -cm -verify -resource
C db2cluster -verify -configuration
D db2cluster -cm -list -alert
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
Which of the following are valid Explain operators? (Choose two.)
Select 2
Options
A COLSCAN
B CTQ
C SELECT
D IXSCAN
E XSCAN
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?
Options
A It does not apply to table space backups.
B If set, backup images created with the BACKUP command are automatically compressed.
C It only has effect when appliedto a database in which all tables have been compressed.
D It specifies the compression mode to use for DB2 backups.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
What does dsmtop use to gather metrics?
Options
A db2pd
B monitoring tablefunctions
C the system catalog
D db2dart
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.