We're so confident of our products that we provide no hassle product exchange.
IBM Certified Database Administrator - IBM IMS Sample Questions:
1. Which one of the following statements is FALSE about DB2 Workload Management (WLM)?
A) DB2 Workload Management uses workloads to identify incoming work based on the connection
attributes under which the work is submitted.
B) When a WLM threshold condition is violated an action is executed in order to maintain stability in the
system.
C) DB2 Workload Management dispatcher can be used to control sharing of memory resources among
active workloads.
D) DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a
different service class.
2. What does the table partitioning feature in DB2 allow you to do?
A) Table partitioning allows you to create result set tables from a join query, which automaticallysplits the
data into smaller chucks, thereby increasing the performance of your DB2 database.
B) Table partitioning allows you to make smaller tables automatically from large tables, therebyincreasing
the performance of your DB2 database.
C) Table partitioning is not a feature in DB2.
D) Table partitioning allows you to create very large tables that are divided across multiplestorage objects
and attach/detach large quantities of data quickly.
3. What is the role of the DB2 task center?
A) The DB2 task center is used to run or schedule tasks and to notify people about the status of
completed tasks.
B) The DB2 task center displays all tasks that were completed to create your DB2 database. It allows you
to make changes to the DB2 metadata only.
C) The DB2 task center is an automated feature in the DB2 product that monitors the heath of your DB2
database and executes tasks that maintain the health of your database. When they have been executed,
tasks are listed for your review.
D) The task center does not exist in DB2.
4. What is the purpose of the XQuery builder tool included in DB2?
A) The XQuery builder tool allows you to query and retrieve data from external XML documents.
B) The XQuery builder tool does not exist in DB2.
C) The XQuery builder tool builds well-formed XML documents that can be stored in a hierarchical form
within columns of a table.
D) The XQuery builder tool allows you to create queries against XML data.
5. What is DB2 Express-C?
A) DB2 Express-C is a no-charge data server version of the DB2 Express edition for thecommunity.
B) DB2 Express-C is not an existing product.
C) DB2 Express-C is latest version of DB2 Express, which follows the former versions DB2Express-A and
DB2 Express-B.
D) DB2 Express-C is the command-line interface for the DB2 Express product.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: D | Question # 3 Answer: A | Question # 4 Answer: D | Question # 5 Answer: A |
By Nydia
