This Competency Exam tests your mastery of the objectives for the courses that make up the Working with DB2 Databases series:
- Introduction to DB2
- Creating and Managing Physical Files
- Creating and Managing Logical Files
- Processing a DB2 Database
- Using Triggers
- Using Referential Integrity
The exam is divided into separate parts, one for each course in the series. Successfully completing all parts of the exam demonstrates your proficiency in the skills required to create a DB2 database and develop applications that process that database.
Approximate time to complete all parts of the exam: 2 hours
This Competency Exam was designed as a mastery test for the Working with DB2 Databases series. We recommend that you take the exam after you complete the series. Alternatively, you can take the corresponding portion of the exam when you complete each course.
Another use for the Competency Exam is as a pretest. Depending on your previous experience and training, you may feel that you already know the material covered by a given course. If this is the case, you should take the exam corresponding to that course. If you successfully complete the exam, you can skip the course, confident that you have already mastered the skills it teaches.
The exam automatically evaluates your performance and reports how you did. To "pass" the exam, you must successfully work at least 80% of the exercises corresponding to each topic. If you score less than 80%, you will be directed to the appropriate course for review.
The Working with DB2 Databases series, including this exam, should be taken by anyone who will creating DB2 databases and/or developing applications that process a DB2 database.
All courses in this series assume that you have a working knowledge of basic IBM i concepts and facilities. You can satisfy this prerequisite by successfully completing the courses in the following series: