IBM Certified Database Associate - DB2 11 Fundamentals for Z/OS (C2090-320)

comp name

This DB2 associate certification is entry level certification in Db2 family, and this certification is for those who are intrested to start their career as database administrator in IBM DB2 11 Z/OS Products. In This certification, candidates will be tested in fundamentals of db2 11 Z/OS like db creation and administration, day to day operations, basic sql knowledge and understanding of db security and transaction isoloation.
To achieve this certification, candidates should pass C2090-320: DB2 11 Fundamentals for z/OS. Find the complete details of certification below.

Exam Details

Required Exam(s) C2090-320: DB2 11 Fundamentals for z/OS
Durations 90 mins
Passing Score 63 Questions and required passing score is 64%.
Question Types Multiple choice, drag and drop, Fill in the blanks and simulation types.
Exam Fees 100 USD
Prerequired Exams There is no prerequired Exams to take, but its recommended, the candidates must have a basic knowledge of SQL and some hands on experience in DB2 11 fundamentals
Exam Policy : Click here to read the Exam policies.
Recommended Trainings : DB2 SQL Workshop, DB2 for zOS for Systems and Operations Personnel, DB2 11 for z/OS Database Administration, DB2 11 for zOS System Administration

Exam Pattern

Below the exam objectives of C2090-320: DB2 11 Fundamentals for z/OS .

Section 1 - Working with SQL and XML (14%)
  • 1.1 Basic ability to write a DML SQL statement
  • 1.2 Basic ability to access and process XML data (XQuery, Xpath)
  • 1.3 Basic knowledge of most commonly used special registers
  • 1.4 Basic knowledge of built-in functions
Section 2 - Security (8%)
  • 2.1 Basic knowledge of restricting data access (authorities, privileges, views, profiles, roles, trusted contexts)
  • 2.2 Basic ability to write a Data Control Language (DCL) SQL statement
Section 3 - Planning (17%)
  • 3.1 Basic ability to connect to DB2 servers (demonstrate ability to use remote access)
  • 3.2 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
  • 3.3 Basic knowledge of subsystem parameters
  • 3.4 Basic knowledge of DB2 architecture (address spaces, logs, IRLM)
  • 3.5 Basic knowledge of data sharing concepts
  • 3.6 Basic knowledge of database workloads (transactional processing vs. analytics)
  • 3.7 Basic knowledge of encoding scheme concepts
Section 4 - Operations (14%)
  • 4.1 Basic knowledge of DB2 commands and DSN commands
  • 4.2 Basic knowledge of DB2 utilities
  • 4.3 Basic knowledge of troubleshooting (Explain, SQL Codes)
Section 5 - Data Concurrency (10%)
  • 5.1 Basic knowledge of transaction management (COMMIT, ROLLBACK, AUTOCOMMIT and SAVEPOINT)
  • 5.2 Basic knowledge of locking
  • 5.3 Given a situation, basic knowledge to identify the isolation levels that should be used
Section 6 - Application Design (19%)
  • 6.1 Basic ability to create and call a stored procedure or a user defined function (understanding of passing parameters and obtaining results)
  • 6.2 Basic knowledge of temporary tables (how they are created and when they should be used)
  • 6.3 Basic knowledge of triggers (how they function; when they might be used)
  • 6.4 Basic knowledge of program preparation and BIND options
  • 6.5 Basic knowledge of referential integrity and constraints
  • 6.6 Basic knowledge of non-relational data concepts (XML data, LOB data)
  • 6.7 Basic knowledge of Temporal (Time Travel) Tables - System-period, Application-period, and Bi-temporal - ability to create and query
Section 7 - Working with Database Objects (17%)
  • 7.1 Basic ability to demonstrate usage of IBM-supplied and user-defined data types
  • 7.2 Basic ability to write a DDL SQL statement
  • 7.3 Basic ability to identify characteristics and properties of DB2 objects (Tables, Indexes, Views,...)
  • 7.4 Basic ability to look up information in the DB2 catalog

Books to Prepare

Below are the recommended books to prepare for C2090-320: DB2 11 Fundamentals for z/OS.

 Cover Image

Sorry ... Books details not available for now. We will update soon

Softwares for Practice

You can practice your exams by using below tools

Software Name : IBM DB2 11

License : Trail Version

Click here for trail download