C1000-078
IBM Db2 12 for z/OS Administrator practice test
459 IBM C1000-132 and C1000-078 practice questions with explanations, in study, timed and flashcard modes. 20 sample questions are free.
Full access
$99
- All 459 questions across C1000-132 and C1000-078, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- Total questions
- 459
- Free samples
- 20
- Versions
- 2
- Updated
- Aug 2026
Exam simulator
Practice C1000-078 in the simulator.
Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.
At a glance
C1000-078, by the numbers.
Official specifications published by IBM.
- Duration
- 90 min
- Questions
- 60
- Passing score
- 70%
- Exam fee
- $200
- In the bank
- C1000-132 (218), C1000-078 (241)

Exam guide
Everything about C1000-078.
C1000-078 · IBM · Db2 12 Function Level 506
What is C1000-078?
Lead database administrators take C1000-078 to show they can run Db2 12 on z/OS. Passing it earns IBM Certified Administrator - Db2 12 for z/OS. It suits senior DBAs and database architects with three or more years of Db2 work. Performance tuning is a big area, including RUNSTATS, the utility that gathers the statistics Db2 uses to plan data access. For example, you may recover a table space after a failure using Db2 utilities. IBM also offers a Db2 13 for z/OS certification for sites on the newer release. Its practice questions focus on design, operation and recovery, performance and security.
What you'll practise
- Design tables, views and indexes, and choose between identity columns, ROWID and sequences.
- Run Db2 commands and utilities in normal and failure situations, including load and unload.
- Grant privileges and authorities, and audit Db2 activity.
- Monitor and tune CPU, memory, I/O, locking and compression, and act on RUNSTATS results.
- Set critical system parameters, use data sharing commands and plan migrations.
- Configure distributed access through DDF and the communications database.
Requirements
- No formal prerequisites: anyone can book the exam.
- Recommended: three or more years as a database administrator.
- Recommended: extensive Db2 for z/OS knowledge, plus basic z/OS and Workload Manager skills.
- Recommended: basic SQL, XML, JSON, database security and Db2 routines such as stored procedures.
Who it's for
- Lead and senior database administrators for Db2 on z/OS.
- Database architects who design Db2 systems on the mainframe.
- Candidates who planned to take C2090-612 or C2090-312, which this exam replaces.
Exam details
Published by IBM, plus what is in our question bank.
What does C1000-078 cover?
The practice test's questions, grouped by exam topic. Open a topic to see what it covers.
7 topics · 42 subtopics · 241 questions
How do I earn this certification?
Passing C1000-078 earns the IBM Certified Administrator - Db2 12 for z/OS in the IBM Db2 for z/OS track.
How to study for this exam?
Use the C1000-078 practice test alongside the official material below.
What's changed on this exam?
Status and coverage changes that affect what you should study.
- Current status
- ACTIVE→ C9006700
- Last content update
- Jan 1, 2025
- Announced
- Jan 1, 2025
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