C1000-161 series practice examsIn development
IBM Certified Database Administrator - Db2
Legacy, and paid accordingly: Db2 still runs European banking and insurance and its administrators are retiring. Instance against database configuration, table spaces matched to buffer pools by page size, circular against archive logging and what each permits, authentication outside the database with authorities separating maintenance from data access, then the three recovery types, the LOAD behaviour that leaves a table space pending, statistics and reorganisation, lock escalation, and HADR synchronisation modes.
What you get
Papers are cut from the bank and weighted like the real exam, and no question appears in two of them. Every wrong answer comes back on later days until you have it right.
What the exam covers
| Architecture, storage and security | Not published |
| Recovery, maintenance, performance and availability | Not published |
Two sample questions
1. What does the RECOVER command combine?
- Backup and archive in one operation, writing both to the same destination
- Restore and reorganisation in one operation, clustering the rows as it proceeds
- Restore and statistics collection in one operation, so plans are correct
- Restore and rollforward in one operation, selecting the images automatically — correct
Why: The command reads the history to determine which backup and logs are needed and performs both stages, which reduces the opportunity for error under pressure.
2. What does the transaction log record?
- Changes made to the database — correct
- The cached pages of a buffer pool
- The metadata of the catalog
- The security labels of users
Why: The log records data changes, enabling recovery by replaying or undoing committed and uncommitted work.
The real C1000-161 series exam
| Length | 90 minutes |
|---|---|
| Questions | 60 |
| Pass mark | Scaled score published per exam version by IBM |
| Price | Purchased per attempt through the IBM certification programme |
| Recommended before you sit it | None enforced. Production Db2 administration experience and SQL are assumed. |
| Valid for | Tied to the product version examined |
Exam facts as published by IBM; always check the vendor’s page before you book.
Study C1000-161 series with Chiron
Chiron is invitation-only while we are in beta, and nothing is for sale yet: invited accounts use every paper, drill and course note for free.