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
Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?
Options
A db2pd
B db2advis
C db2expln
D db2dart
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

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

4
Question
Which operation can be performed with trusted context privileges that are acquired through a role?
Options
A DML operations
B Security administration operations
C Server maintenance operations
D DDL operations
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

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

Finish Practice?

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