Use this quick start guide to collect all the information about IBM Db2 13 for z/OS Database Administrator Associate (C1000-184) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the C1000-184 IBM Db2 13 for z/OS Database Administrator - Associate 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 13 for z/OS Database Administrator Associate certification exam.
The IBM Db2 13 for z/OS Database Administrator Associate certification is mainly targeted to those candidates who want to build their career in Data, Analytics, and AI domain. The IBM Certified Db2 13 for z/OS Database Administrator - Associate exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of IBM Db2 13 for z/OS Database Administrator Associate.
IBM Db2 13 for z/OS Database Administrator Associate Exam Summary:
| Exam Name | IBM Certified Db2 13 for z/OS Database Administrator - Associate |
| Exam Code | C1000-184 |
| Exam Price | $200 (USD) |
| Duration | 90 mins |
| Number of Questions | 60 |
| Passing Score | 73% |
| Books / Training |
Db2 for z/OS 13: Introduction to System Administration (CV854G) Db2 13 for z/OS Basic Database Administration (CV845G) Db2 13 for z/OS Utilities for Database Administrators (CV972G) |
| Schedule Exam | Pearson VUE |
| Sample Questions | IBM Db2 13 for z/OS Database Administrator Associate Sample Questions |
| Practice Exam | IBM C1000-184 Certification Practice Exam |
IBM C1000-184 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Planning |
- Demonstrate knowledge of subsystem parameters. - Understand the modes of migration and the continuous delivery process. - Identify the Db2 address spaces and their purposes. - Understand data sharing concepts. |
12% |
| Operations |
- Connect to Db2 servers. - Understand Db2 and DSN commands. - Understand the Db2 start up process. - Understand the Db2 logging and recovery environment. - Understand the Db2 subsystem recovery/restart process. - Demonstrate a basic knowledge of Db2 utilities. - Navigate the Db2 catalog / directory. |
20% |
| Security |
- Utilize the Data Control Language to establish access to Db2 objects. - Describe the authorization hierarchy. |
5% |
| Database Design |
- Create and modify database objects using DDL. - Understand the Db2 data types. - Illustrate the basic concepts of relational databases. - Understand the relationship(s) between Db2 tables. |
20% |
| Application Development |
- Develop stored procedures, UDFs, and triggers. - Understand the mechanisms for validating SQL execution. - Understand basics of DML. - Demonstrate knowledge of static and dynamic SQL. - Understand program preparation and BINDs. |
21% |
| Data Concurrency |
- Understand locking and concurrency concepts. - Demonstrate the knowledge of transaction isolation. - Understand application logical units of work and how they are managed. |
12% |
| Performance |
- Utilize explains. - Understand access paths and statistics. - Understand traces and reports. |
10% |
To ensure success in IBM Db2 13 for z/OS Database Administrator Associate certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for IBM Db2 13 for z/OS Database Administrator - Associate (C1000-184) exam.
