98% would recommend this to a friend
Most recommended for: Myself
The IBM 000-545 (DB2 9.7 SQL Procedure Developer) exam has 60 multiple choice questions to be answered in 90 minutes. The candidate needs to answer 60% of the questions correctly to pass. The exam is only available in English. There are six sections of the exam.
Section 1 pertains to SQL language representing 30% of the exam. There are four topics covering defining cursors and variables, coding assignment statements, SQL control statements, and error handling.
Section 2 pertains to SQL procedures representing 23% of the exam. There are six topics covering identifying proper SQL procedures, using CREATE PROCEDURE statement, using proper structure of procedure body, how to return sets and values with procedures, and nested procedures.
Section 3 pertains to functions representing 12% of the exam. There are six topic covering how to identify usage of proper functions, using the CREATE FUCNTION statement, the correct structure for function body, test and deploy functions, and invoking functions.
Section 4 pertains to triggers representing 8% of the IBM 000-545 (DB2 9.7 SQL Procedure Developer) exam. There are five topics covering how to use trigger correctly, using CREATE TRIGGER statement, identifying triggers, using advanced triggers, and testing and deploying triggers.
Section 5 pertains to the advanced features representing 16% of the exam There are six topics covering system features, arrays and associated arrays, global variables, and modules,
Section 6 pertains to related tools representing 10% of the exam. There are three topics covering on using Explain, debugging, and application development tools,