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
When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)
Select 2
Options
A The INTRA_PARALLEL database manager configuration parameter is set to NO.
B The PAGESIZE database configuration parameter is set to 32K.
C The DFT_TABLE_ORG database configuration parameter is set to COLUMN.
D The DFT_EXTENT_SZ database configuration parameter is set to 8.
E The AUTO_REORG database configurationparameter is set to NO.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sg1 ON ‘/data1’;
CREATE STOGROUP ibmstogroup ON ‘/data2’;
CREATE STOGROUP sg2 ON ‘/data3’;

Which storage group is the default storage group for the TESTDB database?
Options
A SG1
B IBMDEFAULTTSG
C IBMSTOGROUP
D SG2
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
What is the result of the following scenario?

Exhibit
Options
A The row is updated to (2, NULL)
B The CREATE TRIGGER statement will fail because amt is defined as NOT NULL
C SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed
D The row is updated to (2, 110.00)
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
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!

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.