ExamDumpster

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
Try the free samples first
IBM logo
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)
Open the full exam guide

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.

Duration
90 min
Questions
60
Passing score
70%
Level
Professional
Question types
multiple_choice, multiple_response

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 simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

C1000-078 questions, answered