DB2-730 Exam

QUESTION 1
Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that
has 2 CPUs?
A. DB2 Everyplace
B. DB2 Express Edition
C. DB2 Workgroup Server Edition
D. DB2 Enterprise Server Edition

A client application on z/OS must access a DB2 database on a Solaris Server. At a minimum, which of the
following products must be installed on the Solaris workstation?
A. DB2 Connect Enterprise Edition
B. DB2 Workgroup Server Edition
C. DB2 Workgroup Server Edition and DB2 Connect Enterprise Edition
D. DB2 Enterprise Server Edition and DB2 Connect Enterprise Edition

QUESTION 5
Which of the following products must be installed on an AIX server in order to build an application for AIX
that will access a DB2 for z/OS database?
A. DB2 Enterprise Server Edition
B. DB2 Personal Developer's Edition
C. DB2 Universal Developer's Edition
D. DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition

QUESTION 2
Which of the following products is allowed to access other DB2 servers, but cannot accept requests from
other remote clients?
A. DB2 Personal Edition
B. DB2 Workgroup Server Edition
C. DB2 Enterprise Server Edition
D. DB2 Data Warehouse Edition

QUESTION 4
Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?
A. DB2 Express-C
B. DB2 Express
C. DB2 Personal Edition
D. DB2 Enterprise Server Edition

QUESTION 6
Which of the following DB2 products can only be installed on a System i server?
A. DB2 for z/OS
B. DB2 for i5/OS
C. DB2 Data Warehouse Edition
D. DB2 Enterprise Server Edition

QUESTION 7
What is the purpose of the Design Advisor?
A. To analyze workloads and make recommendations for indexes and MQTs
B. To present a graphical representation of a data access plan and recommend design changes that will
improve performance
C. To replicate data between a DB2 database and another relational database
D. To configure clients so they can access databases stored on remote servers

QUESTION 8
Which of the following tools can be used to catalog a database?
A. Visual Explain B. Alert Center
C. Journal
D. Configuration Assistant

QUESTION 9
Which of the following is used to create and debug user-defined functions?
A. SQL Assist
B. Control Center
C. Command Editor
D. Developer Workbench

QUESTION 10
Which of the following DB2 tools allows a user to set DB2 registry parameters?
A. Task Center
B. Visual Explain
C. Configuration Assistant
D. Satellite Administration Center

QUESTION 11
What is the SQL Performance Monitor used for?
A. To examine the health of a DB2 Database Manager instance
B. To visually construct complex DML statements and examine the results of their execution
C. To schedule tasks, run tasks, and send notifications about completed tasks to other users
D. To analyze database operations performed against a DB2 for i5/OS database

QUESTION 12
Which two of the following allow you to perform administrative tasks against database objects? A. Control Center
B. Journal
C. Command Line Processor
D. Task Center
E. Health Center

QUESTION 13
Which of the following tasks can NOT be performed using the Developer Workbench?
A. Develop and debug an SQL stored procedure
B. Develop and debug a user-defined data type
C. Develop and debug a user-defined function
D. Develop and run XML queries

QUESTION 14
Which of the following tools can be used to automate table reorganization operations?
A. Control Center
B. Command Center
C. Command Line Processor
D. Task Center

QUESTION 15
Which of the following can be viewed with the Journal?
A. Historical information about tasks, database changes, messages, and notifications
B. Information about licenses associated with each DB2 9 product installed on a particular system
C. Graphical representations of data access plans chosen for SQL statements
D. Warning and alarm thresholds for database indicators