Full Name: IBM DB2 9.7 Application Development
Exam Code: C2090-543
IBM DB2 Application Development Exam Summary:
Exam Name
|
IBM Certified Application Developer - DB2 9.7 for Linux Unix and Windows
|
Exam Code
|
C2090-543
|
Exam Price
|
$200 (USD)
|
Duration
|
90 mins
|
Number of Questions
|
60
|
Passing Score
|
60%
|
Books / Training
|
|
Sample Questions
|
|
Practice Exam
|
IBM C2090-543 Exam Syllabus Topics:
| Topic (Weights) | Details |
| Database Objects (11%) | - Demonstrate knowledge of naming conventions of DB2 objects 1. Aliases 2. Views 3. Tables - Describe when to use SQL routines, functions and modules 1. How to use DB2's built-in routines @ Functions @ Stored procedures - Demonstrate knowledge of data types 1. Integer 2. Floating point 3. Strings 4. Date/time 5. LOBs 6. XML data type |
| Traditional Data Manipulation (32%) | - Demonstrate knowledge of authorities needed to access data in an application - Describe the differences between dynamic and static SQL - Demonstrate knowledge of how to query databases across multiple tables and views - Given a scenario, demonstrate knowledge of changing data 1. Insert 2. Update 3. Delete - Demonstrate knowledge of cursors 1. Types of cursors @ Read only @ Updatable @ Scrollable 2. Scope of cursors 3. Create and manipulate cursors - Given a scenario, demonstrate the ability to manipulate large objects Locators - Demonstrate the ability to manage a unit of work 1. Isolation levels 2. COMMIT 3. ROLLBACK 4. SAVEPOINT |
| XML Data Manipulation (15%) | - Given a scenario, demonstrate knowledge of XML schema validation XML schema evolution - Demonstrate the ability to use XML functions 1. XMLPARSE @ Whitespace handling 2. XMLSERIALIZE 3. XMLTRANSFORM 4. Functions for preparing XML documents from relational data - Given a scenario, demonstrate knowledge of how to use XQuery expressions and evaluate the results - Given a scenario, describe how to construct queries that retrieve both traditional and XML data |
| Core Concepts (27%) | - Describe how to bind and rebind a package - Given a scenario, demonstrate knowledge of using parameter markers - Demonstrate knowledge of how to connect to a database (may use scenarios) 1. JDBC 2. ADO.NET 3. CLI/ODBC 4. php_ibm_db2 5. Embedded SQL - Demonstrate the ability to submit an SQL statement 1. JDBC 2. ADO.NET 3. CLI/ODBC 4. php_ibm_db2 5. Embedded SQL - Describe how to manipulate result sets 1. JDBC 2. ADO.NET 3. CLI/ODBC 4. php_ibm_db2 5. Embedded SQL - Demonstrate knowledge of problem determination 1. JDBC 2. ADO.NET 3. CLI/ODBC 4. php_ibm_db2 5. Embedded SQL |
| Advanced Programming (15%) | - Given a scenario, describe how to create and register external stored procedures - Given a scenario, describe how to create external functions 1. OLE DB table 2. External table - Given a scenario, demonstrate knowledge of how changing data will work when referential constraints are involved - Demonstrate knowledge of distributed unit of work (two phase commit) - Demonstrate knowledge of trusted contexts - Demonstrate knowledge of using advanced database objects 1. Global declared temporary tables 2. Sequences 3. MQTs |
Posts
0 comments:
Post a Comment