Test information:
Number of questions: 60
Time allowed in minutes: 75
Required passing score: 63%
Languages: English
This test consists of 10 sections containing a total of 60 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.
Database Objects (13%)
Create and alter database demonstrating knowledge of database attributes
Create and alter tables demonstrating knowledge of table attributes
Demonstrate knowledge of types, attributes, and purpose of indexes
Create table columns demonstrating knowledge and application of various data types
Apply constraints to database tables and columns
Correctly apply encoding schemes to tables
Manage sequences and identities on tables
Create views and understand the best practices for the use of those views
Data Retrieval & Manipulation (12%)
Create table joins using best practices
Merge / select from data change table reference
Demonstrate knowledege of when to use truncate versus delete
Create functions & expressions
Apply knowledge of best practices for grouping, aggregation, and uniqueness
Apply knowledge of best practices for inserts, updates & deletes
Apply knowledge of best practices for Predicates (BETWEEN, IN, LIKE)
Distributed Access to DB2 (8%)
Manage connections to optimize performance
Identify what makes a cursor ambiguous
Determine whether limited fetch or optimize clause should be used in a query
Use best practices to determine generic program options
Set up a data source (dot net, java, odbc)
Coding SQL in Application Programs (10%)
Manage the use of cursors within a program
Apply best practices for error handling
Demonstrate knowledge of when to use dynamic versus static SQL
Demonstrate knowledge of multi-row syntax
Understand when and how to use DCLGEN
Understand how to prepare the program for execution
Processing Options that affect program design (8%)
Understand when and how to use precompile options
Understand when and how to use Bind Options & Connection Settings
Understand when and how to use Special Registers & Built-in Global Variables
Understand when and how to use options at the statement level
Performance Considerations (7%)
Identify examples of accounting trace usage
Understand the use of explain data and IBM Data Studio
Identify differences in DB2 access paths
Identify Stage 1 versus Stage 2 Predicates
Units of work, concurrency, and checkpoint/restart (10%)
Ability to use Isolation Levels & bind release options
Identify the differences between COMMIT, ROLLBACK, and SAVEPOINTS
Ability to recognize and code basic Units of Work
Ability to recognize and code Data Currency options
Knowledge of best practices and restrictions for Autonomous Transactions
Applies Process control and Checkpoint / Restart processing
Application Design & Lifecycle (8%)
Ability to validate execution results are correct
Ability to test connections and stored procedures
Ability to work with DB2 LOAD and UNLOAD utilities
Ability to troubleshoot application performance
Ability to properly utilize DB2 Performance Features
Access to Non-Structured Data (8%)
Ability to work with native XML data
Ability to work with JSON data
Ability to perform schema Validation for XML
Ability to work with XML Built-In Functions
Ability to access Hadoop Data
Advanced Programming Topics (15%)
Ability to work with Stored Procedures
Ability to make use of UDF’s
Ability to use Triggers
Ability to manage relationships between tables using Referential Integrity
Ability to work with Temporal and Archive Tables
Ability to work with MQTs
Ability to work with Temporary Tables
Ability to work with Data Masking techniques
IBM Certified Application Developer – DB2 11 for z/OS
Job Role Description / Target Audience
This certification is intended for the IBM DB2 for z/OS application developers. This is a highly skilled individual responsible for the development of applications that utilize the DB2 product on the z/OS operating system. This individual has significant experience as a designer and developer and has extensive knowledge of DB2 application development constructs, including new features and functionality related to version 11.
This person is capable of performing intermediate to advanced tasks related to application design and implementation, SQL programming, multi-platform deployment (local and/or multi-tiered applications), performance, testing, troubleshooting, and programming specific to DB2 for z/OS. The IBM Certified DB2 for z/OS Application Developer should also, at a minimum, be aware of, and have some experience with, best practices for interfacing with DB2.
To attain the IBM DB2 for z/OS Application Developer certification, candidates must pass one test. To gain additional knowledge and skills, and prepare for the tests based on the job roles and test objectives, click on the link to the test below and refer to the Test Preparation tab.
Recommended Prerequisite Skills
Familiarity with: z/OS, TSO/ISPF, CICS, Application Server (e.g. WebSphere, etc.), IBM Data Studio, Visual Explain, Eclipse, RDz, z/OS Management Framework, SPUFI, DB2I, WLM, Performance Tuning, DB2 Objects. Proficient with: DB2 for z/OS, IBM Data Server Client, SQL & SQLPL, Stored Procedures
Click here to view complete Q&A of C2090-313 exam
Certkingdom Review
Best IBM C2090-313 Certification, IBM C2090-313 Training at certkingdom.com