IBM DB2 Application Development Exam Syllabus

DB2 Application Development PDF, C2090-543 Dumps, C2090-543 PDF, DB2 Application Development VCE, C2090-543 Questions PDF, IBM C2090-543 VCEUse this quick start guide to collect all the information about IBM DB2 Application Development (C2090-543) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the C2090-543 IBM DB2 9.7 Application Development exam. The Sample Questions will help you identify the type and difficulty level of the questions and the Practice Exams will make you familiar with the format and environment of an exam. You should refer this guide carefully before attempting your actual IBM DB2 Application Development certification exam.

The IBM DB2 Application Development certification is mainly targeted to those candidates who want to build their career in IBM Data and AI - Platform Analytics domain. The IBM Certified Application Developer - DB2 9.7 for Linux, Unix and Windows exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of IBM DB2 Application Development.

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%
Schedule Exam Pearson VUE
Sample Questions IBM DB2 Application Development Sample Questions
Practice Exam IBM C2090-543 Certification Practice Exam

IBM C2090-543 Exam Syllabus Topics:

Topic Details Weights
Database Objects - 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
11%
Traditional Data Manipulation - 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
32%
XML Data Manipulation - 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

15%
Core Concepts - 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
27%
Advanced Programming - 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
15%

To ensure success in IBM DB2 Application Development certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for IBM DB2 9.7 Application Development (C2090-543) exam.

Rating: 5 / 5 (63 votes)