C2090-543 IBM DB2 9.7 Application Development Practice Exam
C2090-543 IBM DB2 9.7 Application Development
About IBM DB2 9.7 Application Development Exam
This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to design, build, execute, and deploy DB2 9.7 database applications.
Prerequisite for the exam
Significant experience with intermediate or advanced level skills in developing applications that interact with DB2 databases. This individual has strong skills in DB2 SQL and in database application development concepts.
Course Outline
1. Database Objects
• Demonstrate knowledge of naming conventions of DB2objects
1. Aliases
2. Views
3. Tables
• Describe when to use SQL routines, functions and modules
1. How to use DB2's built-in routines
a. Functions
b. Stored procedures
• Demonstrate knowledge of data types
1. Integer
2. Floating point
3. Strings
4. Date/time
5. LOBs
6. XML data type
2. Traditional Data Manipulation
• Demonstrate knowledge of authorities needed to access datain an application
• Describe the differences between dynamic and static SQL
• Demonstrate knowledge of how to query databases acrossmultiple 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
a. Read only
b. Updatable
c. Scrollable
2. Scope of cursors
3. Create and manipulate cursors
• Given a scenario, demonstrate the ability to manipulate largeobjects
1. Locators
• Demonstrate the ability to manage a unit of work
1. Isolation levels
2. COMMIT
3. ROLLBACK
4. SAVEPOINT
3. XML Data Manipulation
• Given a scenario, demonstrate knowledge of XML schemavalidation
1. XML schema evolution
• Demonstrate the ability to use XML functions
1. XMLPARSE
a. Whitespace handling
2. XMLSERIALIZE
3. XMLTRANSFORM
4. Functions for preparing XML documents fromrelational data
• Given a scenario, demonstrate knowledge of how to useXQuery expressions and evaluate the results
• Given a scenario, describe how to construct queries thatretrieve both traditional and XML data
4. Core Concepts
• Describe how to bind and rebind a package
• Given a scenario, demonstrate knowledge of using parametermarkers
• Demonstrate knowledge of how to connect to a database (mayuse 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
5. Advanced Programming
• Given a scenario, describe how to create and register externalstored procedures
• Given a scenario, describe how to create external functions
1. OLE DB table
2. External table
• Given a scenario, demonstrate knowledge of how changingdata will work when referential constraints are involved
• Demonstrate knowledge of distributed unit of work (two phasecommit)
• Demonstrate knowledge of trusted contexts
• Demonstrate knowledge of using advanced database objects
1. Global declared temporary tables
2. Sequences
3. MQTs
Exam Pattern
- Exam Name: IBM DB2 9.7 Application Development
- Exam Code: C2090-543
- Length of Time: 90 Minutes
- Total Questions: 60
- Pass Score: 36/60
What do we offer?
- Full-Length Mock Test with unique questions in each test set
- Practice objective questions with section-wise scores
- An in-depth and exhaustive explanation for every question
- Reliable exam reports evaluating strengths and weaknesses
- Latest Questions with an updated version
- Tips & Tricks to crack the test
- Unlimited access
What are our Practice Exams?
- Practice exams have been designed by professionals and domain experts that simulate real time exam scenario.
- Practice exam questions have been created on the basis of content outlined in the official documentation.
- Each set in the practice exam contains unique questions built with the intent to provide real-time experience to the candidates as well as gain more confidence during exam preparation.
- Practice exams help to self-evaluate against the exam content and work towards building strength to clear the exam.
- You can also create your own practice exam based on your choice and preference
100% Assured Test Pass Guarantee
We have built the TestPrepTraining Practice exams with 100% Unconditional and assured Test Pass Guarantee!
If you are not able to clear the exam, you can ask for a 100% refund.
