Back to Exams
IBMC2090-614
DB2 10.1 Advanced DBA for Linux UNIX and Windows
This certification validates practical skills in system administration and infrastructure, including deployment, administration, troubleshooting, and resilience. It is intended for professionals operating dependable enterprise technology environments.
Rate this exam
Exam Details
Total Questions
108Last Updated
Aug. 2026Rating
4.8
Question Types
Multi choices
108 Get Full Access
Unlimited access to all questions
Detailed explanations for every question
Page progress: 1 / 225%
#1Multiple Choice
Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?
#2Multiple Choice
Given the following database design:
A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which action should be performed to improve query performance?
#3Multiple Choice
Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?
#4Multiple Choice
Which statement about the initiation of parallel I/O is correct?
#5Multiple Choice
The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log):
MESSAGE:
ADM5502W -
The escalation of "28581" locks on table "TEST.TABLE1" to lock intent "X" was successful.
Which two database configuration parameter settings should be checked? (Choose two.)