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

100+ Free IBM Db2 13 z/OS DBA Professional Practice Questions

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

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
IBM does not publicly report pass rates for C1000-181 Pass Rate
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

Which Db2 13 enhancement helps DBAs recompile SQL PL routines and packages incrementally during migration?

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 - Db2 12 for z/OS (C1000-078)

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 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: IBM Db2 13 z/OS DBA Professional Exam

$200

Exam Fee

IBM C1000-181 listing

~90 min

Time Limit

IBM-typical professional exam length

~63%

Passing Score

IBM-typical (not publicly stated)

5

Domains

Design, Operation, Security, Performance, Migration

FL510

Db2 12 Prerequisite

Required catalog level before migrating

Pearson VUE

Test Delivery

Test center or online proctored

C1000-181 is the IBM Certified Db2 13 for z/OS Database Administrator - Professional exam, costing $200 USD through Pearson VUE. Plan on roughly 60-65 questions, 90 minutes, and approximately 63% to pass (IBM-typical values; not all are publicly stated). The exam is heavy on Db2 13 new function across function levels FL100, FL500, FL501, FL502, and FL505 — including AI Query Optimizer, application granular locking, profile tables, SQL Data Insights, online PBG-to-PBR conversion, PBR-RPN, and the SYSUTILITIES catalog table. Migration topics emphasize moving FROM Db2 12 at FL510 via DSNTIJPM, DSNTIJUZ, CATMAINT, and -ACTIVATE FUNCTION LEVEL. Five domains carry roughly equal weight: design, operation/recovery, security/auditing, performance, and installation/migration.

Sample IBM Db2 13 z/OS DBA Professional Practice Questions

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

1Which type of table space is the only one supported for new table creation in Db2 13 for z/OS, with non-UTS classic types deprecated?
A.Simple table space
B.Segmented (non-UTS) table space
C.Universal Table Space (UTS)
D.Classic partitioned table space
Explanation: Universal Table Space (UTS) is the strategic table space type in Db2 13. Both PBG (Partition By Growth) and PBR (Partition By Range) are UTS variants. Simple, segmented (non-UTS), and classic partitioned table spaces are deprecated and cannot be created for new objects in Db2 13.
2What is the primary advantage of PBR-RPN (Partition By Range with Relative Page Numbering) over classic PBR with Absolute Page Numbering?
A.Reduces RID size from 7 bytes to 5 bytes
B.Allows partition sizes up to 1 TB and partition-level resizing without affecting other partitions
C.Eliminates the need for partitioning indexes
D.Compresses index entries automatically
Explanation: PBR-RPN (also called PBR2) supports DSSIZE up to 1 TB per partition and lets you resize partitions independently because each partition has its own page-numbering origin. With Absolute Page Numbering, partition resizing is constrained because page numbers are continuous across all partitions.
3In Db2 13, what is the default value of the PAGESET_PAGENUM ZPARM for new PBR table spaces?
A.ABSOLUTE
B.RELATIVE
C.AUTO
D.MIXED
Explanation: In Db2 13 the default for PAGESET_PAGENUM changed from ABSOLUTE to RELATIVE, making RPN the default for new PBR table spaces. This aligns with IBM's strategic direction of making PBR2 the standard partitioning model.
4Which Db2 13 function level enables online conversion of a PBG table space to a PBR table space using ALTER PARTITIONING TO PARTITION BY RANGE?
A.FL100
B.FL500
C.FL501
D.FL505
Explanation: Online PBG-to-PBR conversion via ALTER TABLE ... ALTER PARTITIONING TO PARTITION BY RANGE was delivered in Db2 13 FL500. The conversion is a pending change finalized by REORG, and the resulting PBR table space uses RPN by default.
5An administrator wants to create a table space that automatically adds partitions when the existing ones fill up. Which UTS variant should be used?
A.PBR (Partition By Range)
B.PBG (Partition By Growth)
C.Segmented
D.Simple
Explanation: PBG (Partition By Growth) automatically adds a new partition when the current one reaches DSSIZE, up to MAXPARTITIONS. It is well suited for tables without a natural partitioning key. PBR is for range-partitioned data with explicit partition boundaries.
6Which clause of CREATE INDEX defines an index whose key columns include all partitioning columns of the underlying table, allowing it to be used for partition-level utilities?
A.CLUSTER
B.PARTITIONED
C.UNIQUE WHERE NOT NULL
D.INCLUDE
Explanation: A partitioned (data-partitioned secondary) index, declared with PARTITIONED, has its own physical partitions aligned with the table's partitions. This enables partition-level utilities such as REORG PART and improves availability because partitions can be operated on independently.
7In Db2 13, what happens to RID (Record Identifier) size when a PBR table space is converted from APN to RPN?
A.Stays at 5 bytes
B.Grows from 5 bytes to 7 bytes
C.Grows from 4 bytes to 8 bytes
D.Shrinks from 7 bytes to 5 bytes
Explanation: When a PBR table space switches to relative page numbering, RIDs grow from 5 to 7 bytes because each RID must encode partition number plus relative page within the partition. Indexes therefore grow slightly after conversion to RPN.
8Which CREATE TABLE option enables row-level security through a security label column that is checked against MLS RACF labels?
A.WITH ROW ACCESS CONTROL
B.WITH SECURITY LABEL
C.WITH ROW LEVEL GRANT
D.WITH RESTRICT ON DROP
Explanation: A column defined as WITH SECURITY LABEL holds a RACF SECLABEL that Db2 uses to enforce multi-level security on each row. Users see and modify only rows whose security label is dominated by their RACF label.
9Which Db2 13 feature allows defining triggers that may contain multiple SQL statements with control logic and parameter signatures, similar to procedures?
A.Basic triggers
B.Advanced triggers
C.Compound triggers
D.Distributed triggers
Explanation: Advanced triggers, introduced in Db2 12 and enhanced in Db2 13, support multiple SQL statements, SQL PL control structures, parameter signatures, and versions. Db2 13 FL505 added the ability to reference system temporal tables and archive-enabled tables in trigger WHEN clauses.
10What does CREATE TABLE ... WITH SYSTEM VERSIONING enable for a table?
A.Automatic compression of historical rows
B.System-maintained row history in a separate history table
C.Row-level security with RACF
D.Asynchronous replication to a remote subsystem
Explanation: System versioning (system-period temporal) makes Db2 maintain historical row versions in a paired history table. Old row images are inserted into the history table on UPDATE/DELETE so applications can query past states with FOR SYSTEM_TIME AS OF.

About the IBM Db2 13 z/OS DBA Professional Exam

The IBM Certified Db2 13 for z/OS Database Administrator - Professional (C1000-181) certification validates that a Db2 z/OS DBA can design, implement, operate, secure, tune, and migrate Db2 13 for z/OS subsystems. The exam emphasizes Db2 13 new function — including AI Query Optimizer, application granular locking, profile-table-based system monitoring, SQL Data Insights, online PBG-to-PBR conversion, PBR-RPN relative page numbering at the new default, REMOVELOG on -SET LOG, the SYSUTILITIES catalog table, and statement-level invalidation infrastructure — and migration FROM Db2 12 (FL510 prerequisite, DSNTIJPM, CATMAINT, -ACTIVATE FUNCTION LEVEL). Note that exact format details (question count, timing, passing score) are IBM-typical values; verify the current numbers on the official IBM credential page before booking.

Assessment

Approximately 60-65 multiple-choice questions across 5 domains: Database Design and Implementation, Operation and Recovery, Security and Auditing, Performance, and Installation and Migration. IBM does not publicly publish exact question counts; expect IBM-typical professional exam format.

Time Limit

90 minutes

Passing Score

approximately 63%

Exam Fee

$200 USD (IBM / Pearson VUE)

IBM Db2 13 z/OS DBA Professional Exam Content Outline

20%

Database Design and Implementation

Universal Table Space (UTS) — PBG and PBR; PBR-RPN with relative page numbering and 1 TB DSSIZE; partitioned indexes; INCLUDE columns; compression; advanced triggers (FL505 temporal trigger support); RCAC permissions and masks; MQTs; LOB and XML; pending DDL via SYSPENDINGDDL; deprecated non-UTS spaces

20%

Operation and Recovery

REORG SHRLEVEL CHANGE with switch-phase log reduction; RUNSTATS with profile-based statistics; COPY (FLASHCOPY YES); RECOVER TOLOGPOINT; LOAD SHRLEVEL CHANGE; UNLOAD; MERGECOPY; QUIESCE; CHECK DATA; BACKUP/RESTORE SYSTEM; real-time statistics; -SET LOG REMOVELOG (FL500); SYSUTILITIES (FL501); accounting and statistics traces

20%

Security and Auditing

RACF/SAF authentication; SYSADM, SECADM, DBADM, DATAACCESS, ACCESSCTRL, SYSOPR; SECADM-owned audit policies and -START TRACE(AUDIT) AUDTPLCY; row permissions (RCAC) and column masks; trusted contexts and roles; MLS security labels; z/OS Data Set Encryption integration (FL502)

20%

Performance

Buffer pools (DWQT, VDWQT, VPSEQT, VPPSEQT, PGSTEAL); Db2 13 AI Query Optimizer; application granular locking; profile-table monitoring (DSN_PROFILE_TABLE/DSN_PROFILE_ATTRIBUTES); dynamic statement cache improvements; EXPLAIN STMTCACHE; package phase-in with PLANMGMT(EXTENDED); parallelism (CURRENT DEGREE, VPPSEQT); group buffer pools and GBPCACHE; regression SQL functions

20%

Installation and Migration

Function levels FL100, FL500, FL501, FL502, FL505 and later; Db2 12 FL510 prerequisite; DSNTIJPM premigration queries; DSNTIJUZ DSNZPARM build; DSNTIJTM work-file init; CATMAINT; -ACTIVATE FUNCTION LEVEL ... TEST; fallback supported only at FL100; data-sharing coexistence; CURRENT LOCK TIMEOUT (FL500); DEADLOCK_RESOLUTION_PRIORITY (FL501); Sysplex WLB at FL502

How to Pass the IBM Db2 13 z/OS DBA Professional Exam

What You Need to Know

  • Passing score: approximately 63%
  • Assessment: Approximately 60-65 multiple-choice questions across 5 domains: Database Design and Implementation, Operation and Recovery, Security and Auditing, Performance, and Installation and Migration. IBM does not publicly publish exact question counts; expect IBM-typical professional exam format.
  • Time limit: 90 minutes
  • Exam fee: $200 USD

Keys to Passing

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

IBM Db2 13 z/OS DBA Professional Study Tips from Top Performers

1Build a function-level cheat sheet — FL100, FL500, FL501, FL502, FL505 — and memorize the headline new function delivered at each level
2Drill the migration job stream cold: DSNTIJPM (premigration), DSNTIJUZ (DSNZPARM build), DSNTIJTM (work files), CATMAINT (catalog update), and -ACTIVATE FUNCTION LEVEL with the TEST option
3Practice EXPLAIN, EXPLAIN STMTCACHE ALL, and PLAN_TABLE/DSN_STATEMENT_CACHE_TABLE analysis — performance questions test these tools, not generic SQL tuning advice
4Master profile tables: DSN_PROFILE_TABLE filters and DSN_PROFILE_ATTRIBUTES attributes (CURRENT LOCK TIMEOUT, MONITOR IDLE THREADS, application granular locking) and how they interact with subsystem ZPARM
5Know UTS variants cold — PBG, PBR, PBR-RPN — including the DSSIZE limits, RID byte sizes (5 vs 7), and the FL500 ALTER PARTITIONING TO PARTITION BY RANGE pending change
6Review SECADM-owned objects and audit policies: GRANT/REVOKE flow, audit categories (VALIDATE, OBJMAINT, SECMAINT, EXECUTE), trusted contexts, and RCAC permissions vs masks

Frequently Asked Questions

What is the C1000-181 IBM Db2 13 for z/OS DBA Professional exam?

C1000-181 is the IBM Certified Db2 13 for z/OS Database Administrator - Professional credential. It validates that a candidate can design, implement, operate, secure, tune, and migrate Db2 13 for z/OS subsystems, with emphasis on Db2 13 new function and migration from Db2 12. The exam is delivered through Pearson VUE at test centers or via online proctoring.

How much does the C1000-181 exam cost and how long is it?

The C1000-181 exam fee is $200 USD per attempt. IBM does not always publish exact format details, but professional exams of this type typically allow about 90 minutes and contain roughly 60-65 multiple-choice questions with a passing score around 63%. Verify the current logistics on the official IBM credential page before booking.

What Db2 13 new features should I focus on for C1000-181?

Focus on function-level features: SQL Data Insights and online PBG-to-PBR conversion at FL500; the SYSUTILITIES catalog table and DEADLOCK_RESOLUTION_PRIORITY at FL501; Db2-controlled Sysplex WLB and statement-level invalidation infrastructure at FL502; advanced trigger temporal-table support at FL505; the AI Query Optimizer; application granular locking; and profile-table-based monitoring and overrides.

Do I need experience with Db2 12 to take C1000-181?

There are no formal prerequisites, but most successful candidates have prior Db2 z/OS DBA experience and many already hold the Db2 12 DBA credential. The exam's installation and migration domain assumes familiarity with Db2 12 FL510 as the migration prerequisite, DSNTIJPM premigration queries, CATMAINT, and the -ACTIVATE FUNCTION LEVEL command.

How do I migrate from Db2 12 to Db2 13?

Bring the Db2 12 system to FL510 first. Run DSNTIJPM premigration queries on the Db2 12 catalog and resolve every reported issue (deprecated objects, invalid plans/packages, etc.). Then build Db2 13 DSNZPARM with DSNTIJUZ, run CATMAINT to update the catalog to V13R1M100, start Db2 13 at FL100, and gradually -ACTIVATE FUNCTION LEVEL up to FL500 and beyond as you are ready. Fallback to Db2 12 is supported only at FL100.

Is the C1000-181 exam open book or proctored?

The exam is delivered through Pearson VUE and is fully proctored — at a test center or via online proctoring with a webcam. No reference material is allowed during the exam.

How is C1000-181 different from the Db2 13 Associate exam (C1000-184)?

C1000-184 is the Associate-level Db2 13 z/OS exam, designed for candidates with foundational knowledge. C1000-181 is the Professional-level DBA exam, requiring deeper hands-on Db2 13 administration, migration, performance, and security skill. If you already work as a Db2 z/OS DBA, C1000-181 is the appropriate credential.