ExamDumpster

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

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.

Duration
90 min
Questions
63
Passing score
44 out of 63
Level
Associate

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-122 questions, answered