My cart:
0 items
  • Cart is Empty
  • Sub Total: $0.00

C2090-543 Exam Format | C2090-543 Course Contents | C2090-543 Course Outline | C2090-543 Exam Syllabus | C2090-543 Exam Objectives

C2090-543 Exam Information and Guideline

DB2 9.7 Application Development



Below are complete topics detail with latest syllabus and course outline, that will help you good knowledge about exam objectives and topics that you have to prepare. These contents are covered in questions and answers pool of exam.









Exam Title :
IBM Certified Application Developer - DB2 9.7 for Linux Unix and Windows

Exam ID :
C2090-543

Exam Duration :
90 mins

Questions in Exam :
60

Passing Score :
60%

Exam Center :
Pearson VUE

Real Questions :
IBM DB2 Application Development Real Questions

VCE Practice Test :
IBM C2090-543 Certification VCE Practice Test






Database Objects


- Demonstrate knowledge of naming conventions of DB2 objects



Aliases


Views


Tables


- Describe when to use SQL routines, functions and modules



How to use DB2's built-in routines @ Functions @ Stored procedures


- Demonstrate knowledge of data types



Integer


Floating point


Strings


Date/time


LOBs


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



Insert


Update


Delete


- Demonstrate knowledge of cursors



Types of cursors @ Read only @ Updatable @ Scrollable


Scope of cursors


Create and manipulate cursors


- Given a scenario, demonstrate the ability to manipulate large objects

Locators

- Demonstrate the ability to manage a unit of work



Isolation levels


COMMIT


ROLLBACK


SAVEPOINT



32%




XML Data Manipulation


- Given a scenario, demonstrate knowledge of XML schema validation

XML schema evolution

- Demonstrate the ability to use XML functions



XMLPARSE @ Whitespace handling


XMLSERIALIZE


XMLTRANSFORM


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)



JDBC


ADO.NET


CLI/ODBC


php_ibm_db2


Embedded SQL


- Demonstrate the ability to submit an SQL statement



JDBC


ADO.NET


CLI/ODBC


php_ibm_db2


Embedded SQL


- Describe how to manipulate result sets



JDBC


ADO.NET


CLI/ODBC


php_ibm_db2


Embedded SQL


- Demonstrate knowledge of problem determination



JDBC


ADO.NET


CLI/ODBC


php_ibm_db2


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



OLE DB table


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



Global declared temporary tables


Sequences


MQTs



15%

C2090-543 Exam Dumps Detail

We are the best Exam Dumps Provider

With a long list of thousands of satisfied customers, we welcome you to join us.

All CertificationsAll Vendors