Test information:
Number of questions: 63
Time allowed in minutes: 90
Required passing score: 64%
Languages: English

This Database Associate certification is an entry level exam for a user of any of the DB2 for z/OS family of products. This individual is knowledgeable about the fundamental concepts of DB2 11 for z/OS through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand which additional products are available with DB2 11, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Section 1 – Working with SQL and XML (14%)
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

Section 2 – Security (8%)
Basic knowledge of restricting data access (authorities, privileges, views, profiles, roles, trusted contexts)
Basic ability to write a Data Control Language (DCL) SQL statement

Section 3 – Planning (17%)
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

Section 4 – Operations (14%)
Basic knowledge of DB2 commands and DSN commands
Basic knowledge of DB2 utilities
Basic knowledge of troubleshooting (Explain, SQL Codes)

Section 5 – Data Concurrency (10%)
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

Section 6 – Application Design (19%)
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

Section 7 – Working with Database Objects (17%)
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

Click here to view complete Q&A of C2090-320 exam
Certkingdom Review

Best IBM C2090-320 Certification, IBM C2090-320 Training at certkingdom.com