Use this quick start guide to collect all the information about IBM DB2 Fundamentals for z/OS (C2090-320) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the C2090-320 IBM DB2 11 Fundamentals for z/OS 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 Fundamentals for z/OS certification exam.
The IBM DB2 Fundamentals for z/OS certification is mainly targeted to those candidates who want to build their career in IBM Data and AI - Platform Analytics domain. The IBM Certified Database Administrator - DB2 11 DBA for z/OS exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of IBM DB2 Fundamentals for z/OS.
IBM DB2 Fundamentals for z/OS Exam Summary:
| Exam Name | IBM Certified Database Administrator - DB2 11 DBA for z/OS |
| Exam Code | C2090-320 |
| Exam Price | $200 (USD) |
| Duration | 90 mins |
| Number of Questions | 63 |
| Passing Score | 65% |
| Books / Training |
Introduction to DB2 for zOS for Systems and Operations Personnel DB2 11 for zOS System Administration |
| Schedule Exam | Pearson VUE |
| Sample Questions | IBM DB2 Fundamentals for z/OS Sample Questions |
| Practice Exam | IBM C2090-320 Certification Practice Exam |
IBM C2090-320 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Working with SQL and XML |
- Basic ability to write a DML SQL statement - Basic ability to access and process XML data (XQuery, Xpath) - Basic knowledge of most commonly used special registers - Basic knowledge of built-in functions |
14% |
|
Security |
- Basic knowledge of restricting data access (authorities, privileges, views, profiles, roles, trusted contexts) - Basic ability to write a Data Control Language (DCL) SQL statement |
8% |
| Planning |
- Basic ability to connect to DB2 servers (demonstrate ability to use remote access) - Basic knowledge of different types of tables (Base, MQT, Auxiliary, Partitioned, Temporal - at a high level; when is it appropriate to use each type) and table spaces - Basic knowledge of subsystem parameters - Basic knowledge of DB2 architecture (address spaces, logs, IRLM) - Basic knowledge of data sharing concepts - Basic knowledge of database workloads (transactional processing vs. analytics) - Basic knowledge of encoding scheme concepts |
17% |
| Operations |
- Basic knowledge of DB2 commands and DSN commands - Basic knowledge of DB2 utilities - Basic knowledge of troubleshooting (Explain, SQL Codes) |
14% |
| Data Concurrency |
- Basic knowledge of transaction management (COMMIT, ROLLBACK, AUTOCOMMIT and SAVEPOINT) - Basic knowledge of locking - Given a situation, basic knowledge to identify the isolation levels that should be used |
10% |
| Application Design |
- Basic ability to create and call a stored procedure or a user defined function (understanding of passing parameters and obtaining results) - Basic knowledge of temporary tables (how they are created and when they should be used) - Basic knowledge of triggers (how they function; when they might be used) - Basic knowledge of program preparation and BIND options - Basic knowledge of referential integrity and constraints - Basic knowledge of non-relational data concepts (XML data, LOB data) - Basic knowledge of Temporal (Time Travel) Tables - System-period, Application-period, and Bi-temporal - ability to create and query |
19% |
| Working with Database Objects |
- Basic ability to demonstrate usage of IBM-supplied and user-defined data types - Basic ability to write a DDL SQL statement - Basic ability to identify characteristics and properties of DB2 objects (Tables, Indexes, Views,...) - Basic ability to look up information in the DB2 catalog |
18% |
To ensure success in IBM DB2 Fundamentals for z/OS certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for IBM DB2 11 Fundamentals for z/OS (C2090-320) exam.