Career upgrade: Learn practical AI skills for better jobs and higher pay.
Level up
PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free Db2 12 z/OS DBA Practice Questions

Pass your IBM Certified Administrator - Db2 12 for z/OS (C1000-078) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
Not published Pass Rate
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

Which Db2 12 ZPARM controls the maximum number of remote (DDF) database access threads (DBATs) the subsystem can have active concurrently?

A
B
C
D
to track
Same family resources

Explore More IBM Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

IBM AIX v7.3 Administrator Specialty (S2000-025)

Practice Questions

IBM Certified Administrator - Maximo Manage v8.x (C1000-141)

Practice Questions

IBM Certified Cognos Analytics v12 Administrator - Professional (C1000-178)

Practice Questions

IBM Certified Db2 13 for z/OS DBA - Professional (C1000-181)

Practice Questions

IBM Certified Developer - App Connect Enterprise V12.0 (C1000-171)

Practice Questions

IBM Certified Solution Implementer - Sterling B2B Integrator V5.2 (C8060-218)

Practice Questions
2026 Statistics

Key Facts: Db2 12 z/OS DBA Exam

63

Exam Questions

IBM (multiple choice/response)

90 min

Time Limit

Pearson VUE delivery

40/63

Passing Score

IBM (63%)

$200

Exam Fee

IBM / Pearson VUE

6

Test Domains

IBM C1000-078 outline

FL511

Top Function Level

Db2 12 continuous delivery

C1000-078 contains 63 multiple-choice questions in 90 minutes and requires 40 correct (63%) to pass. The $200 USD exam through Pearson VUE certifies IBM Db2 12 for z/OS administrators across six domains: database design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, and installation/migration/upgrades. Candidates must master Universal Table Spaces (PBR and PBG), function levels FL501-FL511, RCAC, DDF profile tables, ZPARMs such as MAXDBAT and CMTSTAT, and recovery utilities. Db2 12 remains active alongside Db2 13, so the credential is still in demand for shops on the Db2 12 release.

Sample Db2 12 z/OS DBA Practice Questions

Try these sample questions to test your Db2 12 z/OS DBA exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1Which Db2 12 for z/OS table space type can hold exactly one table, supports growth-based partition allocation, and automatically adds partitions as the table grows?
A.Partition-by-Range (PBR) UTS
B.Partition-by-Growth (PBG) UTS
C.Segmented (non-UTS) table space
D.Classic partitioned table space
Explanation: A Partition-by-Growth Universal Table Space (PBG UTS) holds exactly one table and adds partitions automatically up to MAXPARTITIONS when an existing partition fills. It is the recommended choice for tables that grow but do not have a natural partitioning key.
2An application requires a partition-by-range Universal Table Space with up to 64 partitions. Which clause in CREATE TABLESPACE controls this upper bound?
A.MAXROWS 64
B.NUMPARTS 64
C.MAXPARTITIONS 64
D.DSSIZE 64G
Explanation: MAXPARTITIONS sets the upper limit on the number of partitions a UTS may have. For PBG it controls automatic growth; for PBR it controls the maximum number of range partitions. NUMPARTS defines the initial number of partitions.
3In Db2 12 for z/OS, which feature allows a non-unique secondary index to be defined on a computed value such as UPPER(LASTNAME)?
A.Materialized Query Table
B.Index on Expression
C.Hash organized index
D.Functional dependency constraint
Explanation: Index on Expression lets you create a Db2 index whose key is an expression such as UPPER(LASTNAME) or YEAR(HIRE_DT). The optimizer can use the index to satisfy queries that reference the same expression in predicates.
4Which Db2 12 column attribute generates unique numeric values automatically and can be defined as GENERATED ALWAYS or GENERATED BY DEFAULT?
A.ROWID column
B.Identity column
C.Sequence object
D.Trigger-based default
Explanation: An identity column is a numeric column with the GENERATED ALWAYS or GENERATED BY DEFAULT attribute that produces a sequential value automatically when rows are inserted. Identity columns are tied to a single table.
5A DBA needs a counter shared across multiple tables. Which Db2 object should be created?
A.An identity column on each table
B.A SEQUENCE object
C.A trigger that maintains a sequence table
D.A ROWID column
Explanation: A SEQUENCE is a stand-alone database object whose NEXT VALUE FOR and PREVIOUS VALUE FOR expressions can be referenced by any table or application that holds USAGE on the sequence. Identity columns are scoped to a single table.
6Which type of temporal table preserves historical row versions every time the row is updated, with Db2 automatically copying the old image to a separate history table?
A.Application-period temporal table (business-time)
B.System-period temporal table (system-time)
C.Bitemporal table
D.Archive-enabled table
Explanation: A system-period temporal (system-time) table uses the SYSTEM_TIME period and a linked history table. Db2 transparently moves the prior row image to the history table on UPDATE/DELETE, and queries with FOR SYSTEM_TIME AS OF return historical state.
7Which Db2 12 table organization stores rows in a fixed location based on a hash of the key, providing direct access without an index probe?
A.Append-only segmented table
B.Hash organized table
C.Clustered index table
D.MEMBER CLUSTER table
Explanation: Hash organized tables compute a hash of a fixed-length key and store the row in a deterministic page, allowing single-row equality lookups with no index access. Hash organization is best for very high-volume single-row lookups by primary key.
8Which Db2 12 ZPARM controls the default value of LOCKSIZE for table spaces created without an explicit LOCKSIZE specification?
A.DSNZPARM IRLMRWT
B.DSNZPARM CTHREAD
C.DSNZPARM NUMLKTS
D.Default LOCKSIZE is ANY and not controlled by a single ZPARM
Explanation: If LOCKSIZE is not specified, Db2 uses LOCKSIZE ANY, which lets the lock manager choose page or row locking dynamically based on workload and ZPARMs. NUMLKTS controls the number of page/row locks per table space before escalation, not the default LOCKSIZE.
9Which Db2 12 utility reorganizes a table space and can also rebuild indexes and update inline statistics in a single execution?
A.RUNSTATS
B.REORG TABLESPACE
C.MODIFY RECOVERY
D.QUIESCE
Explanation: REORG TABLESPACE reorganizes a table space, can rebuild associated indexes (with PART/INDEX options), and can collect inline statistics (STATISTICS keyword) in one pass, eliminating a separate RUNSTATS step in many shops.
10Which Db2 12 utility produces an image copy of a table space that can be used for subsequent RECOVER operations?
A.COPY
B.BACKUP SYSTEM
C.UNLOAD
D.DSN1COPY
Explanation: The COPY utility makes a recoverable image copy of one or more table spaces and registers it in SYSCOPY so RECOVER can use it. Both full and incremental copies are supported, and FlashCopy can be requested for fast point-in-time copies.

About the Db2 12 z/OS DBA Exam

The IBM Certified Administrator - Db2 12 for z/OS (C1000-078) credential validates skills in administering an enterprise Db2 12 for z/OS subsystem: database and table-space design (PBR/PBG UTS, classic partitioned, segmented), operation and recovery using COPY, RECOVER, REORG, RUNSTATS, LOAD, UNLOAD, BACKUP SYSTEM, BSDS and archive logs, security with RACF integration and row/column access control (RCAC), distributed connectivity through DDF and DRDA with profile tables and AT-TLS, performance tuning with EXPLAIN, buffer pools, EDM/RID/Sort pools, IFCID trace, and OMEGAMON, and installation/migration/upgrades including Db2 12 function levels FL501 through FL511.

Assessment

63 multiple-choice and multiple-response questions covering Db2 12 for z/OS database administration: design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, and installation/migration/upgrades.

Time Limit

90 minutes

Passing Score

40/63 (63%)

Exam Fee

$200 (IBM / Pearson VUE)

Db2 12 z/OS DBA Exam Content Outline

~17%

Database Design and Implementation

Table design, universal table spaces (PBR, PBG), MAXPARTITIONS, classic partitioned vs segmented, universal indexes, INCLUDE columns, index on expression, identity columns, SEQUENCEs, system/business/bitemporal temporal tables, hash organized tables, native SQL stored procedures, archive-enabled tables.

~17%

Operation and Recovery

COPY (with FlashCopy), RECOVER (TOLOGPOINT/TORBA), REORG with inline statistics, RUNSTATS (FREQVAL, KEYCARD, HISTOGRAM), LOAD, UNLOAD, QUIESCE, MODIFY RECOVERY, BACKUP SYSTEM/RESTORE SYSTEM, BSDS dual logging, archive log offload, conditional restart with DSNJU003, IRLM, -START/-STOP/-DISPLAY commands, DSN1LOGP, DSNJU004.

~17%

Security and Auditing

RACF DSNR (connection), DSNADM (administrative authorities), MDSNTB/GDSNTB (table privileges), GRANT/REVOKE, CREATE ROLE and trusted contexts, RCAC (CREATE PERMISSION, CREATE MASK, ACTIVATE ROW/COLUMN ACCESS CONTROL), audit policies (CHECKING/EXECUTE/OBJMAINT/SECMAINT/CONTEXT/VALIDATE), SECADM, SQLADM, ACCESSCTRL, DATAACCESS, SEPARATE_SECURITY=YES, AT-TLS for DDF.

~17%

Distributed Connectivity

DDF address space, DRDA over TCP/IP, location names, MAXDBAT, CONDBAT, CTHREAD, CMTSTAT (INACTIVE/ACTIVE), IDTHTOIN, POOLINAC, TCPALVER, DDF profile tables (SYSIBM.DSN_PROFILE_TABLE and DSN_PROFILE_ATTRIBUTES), -START PROFILE/-STOP PROFILE/-DISPLAY PROFILE, three-part names, AT-TLS for DRDA encryption.

~17%

Performance

EXPLAIN and PLAN_TABLE access types, buffer pool tuning (VPSIZE, PGFIX, PGSTEAL, VPSEQT, DWQT/VDWQT), EDM Pool with EDMSTMTC and EDMDBDC, RID Pool, Sort Pool, dynamic statement cache, AUTH cache, lock options (LOCKSIZE ROW/PAGE/TABLE/TABLESPACE), NUMLKUS, NUMLKTS, DEADLOK, IRLMRWT, IFCID 3/4, statistics trace, accounting trace, OMEGAMON for Db2 PE, plan stability with SWITCH(PREVIOUS), parallelism (CDSSRDEF, PARAMDEG).

~15%

Installation, Migration, and Upgrades

Db2 12 function levels FL500 through FL511, -ACTIVATE FUNCTION LEVEL, -DISPLAY GROUP for FL status, premigration job DSNTIJPM, CATMAINT UPDATE, DSNTIJUZ for ZPARM rebuild, APPLCOMPAT (per package and ZPARM default), PAGESET_PAGENUM for PBR RPN default, BSDS configuration, code level vs catalog level vs function level.

How to Pass the Db2 12 z/OS DBA Exam

What You Need to Know

  • Passing score: 40/63 (63%)
  • Assessment: 63 multiple-choice and multiple-response questions covering Db2 12 for z/OS database administration: design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, and installation/migration/upgrades.
  • Time limit: 90 minutes
  • Exam fee: $200

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

Db2 12 z/OS DBA Study Tips from Top Performers

1Memorize the UTS variants: PBR is range-partitioned by key; PBG holds one table and grows automatically up to MAXPARTITIONS. Classic partitioned and segmented (non-UTS) types still appear in legacy systems.
2Drill the function-level chain: FL100 (V11 mode) -> FL500 (V12 catalog only) -> FL501 (first new function) -> FL502...FL511. Use -DISPLAY GROUP to verify activated and highest possible function levels.
3Practice DDF and profile-table workflows: SYSIBM.DSN_PROFILE_TABLE plus SYSIBM.DSN_PROFILE_ATTRIBUTES, -START PROFILE to refresh, MAXDBAT vs CONDBAT vs CTHREAD, and CMTSTAT INACTIVE for high-performance DBAT pooling.
4Master RCAC syntax: CREATE PERMISSION ... ON TABLE; CREATE MASK ... ON TABLE; ALTER TABLE ... ACTIVATE ROW ACCESS CONTROL / ACTIVATE COLUMN ACCESS CONTROL. Combined with SECADM and SEPARATE_SECURITY=YES for separation of duties.
5Know recovery primitives end-to-end: COPY -> SYSCOPY, log offload -> archive logs, BSDS dual, RECOVER TOLOGPOINT, BACKUP SYSTEM/RESTORE SYSTEM, FlashCopy on COPY, conditional restart via DSNJU003, DSN1LOGP for forensic analysis.
6Be fluent with key ZPARMs: MAXDBAT, CONDBAT, CMTSTAT, IDTHTOIN, NUMLKUS, NUMLKTS, IRLMRWT, DEADLOK, CHKFREQ, STATIME, EDMSTMTC, EDMDBDC, CDSSRDEF, PARAMDEG, APPLCOMPAT, PAGESET_PAGENUM, SEPARATE_SECURITY.

Frequently Asked Questions

How many questions and how long is the C1000-078 exam?

The exam has 63 multiple-choice and multiple-response questions and a 90-minute time limit. You need 40 correct answers (63%) to pass.

How much does the IBM C1000-078 exam cost?

The exam fee is $200 USD per attempt and is delivered through Pearson VUE testing centers and online proctoring.

What experience does IBM recommend for C1000-078?

IBM recommends hands-on Db2 12 for z/OS DBA experience covering utilities, recovery, distributed connectivity, security, and performance. Most successful candidates have 1-3 years of mainframe DBA work plus exposure to Db2 12 specifically (function levels, PBR/PBG, RCAC, DDF profile tables).

Is Db2 12 for z/OS still relevant in 2026?

Yes. Db2 12 for z/OS remains active alongside Db2 13, and many enterprise shops continue to run it. C1000-078 is the supported DBA credential for those environments. Candidates planning to upgrade should also review the Db2 13 for z/OS DBA credential (C1000-181).

What are Db2 12 function levels and why do they matter?

Db2 12 introduced continuous delivery via function levels (FL500 through FL511 and beyond). Code level, catalog level (set via CATMAINT), and function level (activated by -ACTIVATE FUNCTION LEVEL) work together to gate new features. Packages must be bound with an APPLCOMPAT that matches the function level needed before applications can use new function.

Which utilities are most heavily tested?

Expect questions on COPY (with FlashCopy), RECOVER (TOLOGPOINT/TORBA), REORG with inline statistics, RUNSTATS (FREQVAL, KEYCARD, HISTOGRAM), LOAD, UNLOAD, QUIESCE, MODIFY RECOVERY, BACKUP SYSTEM/RESTORE SYSTEM, plus stand-alone utilities DSN1LOGP, DSN1COPY, DSNJU003, and DSNJU004.

How are RACF and Db2 authorization integrated for the exam?

Know the DSNR class (connection access), DSNADM class (administrative authorities like SYSADM/DBADM), and the per-object classes such as MDSNTB/GDSNTB for tables when the access control authorization exit (DSNX@XAC) is enabled. SEPARATE_SECURITY=YES gives SECADM exclusive control over roles, trusted contexts, RCAC, and audit policies.