C1000-122
Db2 12 for z/OS DBA Fundamentals practice test
138 IBM C1000-122 practice questions with explanations, in study, timed and flashcard modes.
Full access
$99
- All 138 questions, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- Questions
- 138
- Free samples
- –
- Versions
- 1
- Updated
- Mar 2026
Exam simulator
Practice C1000-122 in the simulator.
Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.
At a glance
C1000-122, by the numbers.
Official specifications published by IBM.
- Duration
- 90 min
- Questions
- 63
- Passing score
- 44 out of 63
- Exam fee
- $200

Exam guide
Everything about C1000-122.
C1000-122 · IBM · Db2 12 for z/OS
What is C1000-122?
Passing C1000-122 shows you know the basics of running Db2 12 databases on IBM's z/OS mainframe. It is an entry-level exam for new mainframe database administrators (DBAs). IBM has since replaced it with C1000-184, which covers Db2 13. The exam asks you to write SQL, run Db2 commands and utilities, and control who can read data. It also covers locking, which stops two programs from changing the same data at the same time. For example, you may pick the isolation level that lets a report read data without waiting for locks. This practice test covers SQL and XML, application design, operations and database objects.
What you'll practise
- Write SQL and XML queries with built-in functions, special registers and global variables.
- Design applications with stored procedures, user-defined functions, triggers and temporary tables.
- Run Db2 and DSN commands and basic utilities, and troubleshoot common problems.
- Manage transactions, locks and isolation levels so programs can share data safely.
- Create database objects with DDL and look up their details in the Db2 catalog.
- Plan table spaces and subsystem parameters, and restrict data access with GRANT and REVOKE.
Requirements
- No formal prerequisites: anyone can book the exam.
- Recommended: working knowledge of the z/OS tools TSO, ISPF and SDSF.
- Recommended: hands-on time with Db2 12 for z/OS, including the SQL statements SELECT, INSERT, UPDATE and DELETE.
- Recommended: basic knowledge of database security and transaction isolation.
Who it's for
- New database administrators who look after Db2 12 on z/OS.
- Mainframe developers and operators who are moving into database administration.
- DBAs at sites that still run Db2 12 and have not yet moved to Db2 13.
Exam details
Published by IBM, plus what is in our question bank.
What does C1000-122 cover?
7 weighted domains. Open a domain for its topics, and a topic for its objectives. Practice questions are tagged to these.
How do I earn this certification?
Passing C1000-122 earns the IBM Associate Certified DBA - Db2 12 for z/OS Fundamentals in the Db2 for z/OS Database Administration track.
How to study for this exam?
Use the C1000-122 practice test alongside the official material below.
Three ways to practise
Study mode
Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.
Open in the simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator