DB2 9 Family Fundamentals
Questions, Answers, Braindumps (000-730)
I passed it with good score, but you need to study
and remember a lot of the information. I used www.exams.ws
for my test.
Here are the questions what I remember.
An alias can be an alternate name for which DB2 object?
Which of the following constraint types can be used
to ensure the value of an INTEGER column references
only positive values?
Which of the following are types of routing objects?
A. Package and function
B. Function and unserexit
C. Procedure and package
D. Function and Procedure
Which product must be installed on Z/Os to allow a
COBOL program running on that machine to access data
on a remote DB2 for Z/OS Server?
A. DB2 for z/OS
B. DB2 Run-Time Client for z/OS
C. DB2 Connect Enterprise Edition for z/OS
D. z/OS Application Connectivity to DB2 for z/OS and
For which of the following is a data warehouse optimized?
A. Backup and Recovery
What type of constraint is used to ensure that each
row inserted into the EMPLOYEE table with a value
in the WORKDEPT column has a row with a corresponding
value in the DEPTNO column of the DEPARTMENT table?
A. A Check constraint on the EMPLOYEE table
B. A UNIQUE constraint on the EMPLOYE table WORKDEPT
C. A foreign key reference from the DEPARTMENT tables
DEPTNO column to the WORKDEPT column of the EMPLOYEE
D. A foreign key reference from the EMPLOYEE tables
WORKDEPT column to the DEPTNO column of the DEPARTMENT
Which of the following DB2 products are required on
an iSeries or system I server to enable an application
running on that server to retrieve data from a DB2
database on a Linux Server?
A. DB2 fro i5/OS
B. DB2 Runtime Client
C. DB2 Connect Enterprise Edition
D. DB2 For i5/OS SQL Development Kit