PDF, desktop engine, or online engine — not sure which IBM Certified Database Administrator - DB2 10 for z/OS version fits how you study? Ask us. The BraindumpsIT service team is online 24/7, and whichever you choose carries the same 000-612 questions.
IBM 000-612 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 10 DBA for z/OS |
| Exam Number: | C2090-612 |
| Related Certifications: | IBM Certified System Administrator - DB2 for z/OS IBM Certified Database Administrator - DB2 11 for z/OS |
| Exam Price: | 200 USD |
| Exam Format: | Multiple Response, Multiple Choice |
| Passing Score: | 59% - 60% |
| Certificate Validity Period: | 3 years |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 63 - 67 |
| Available Languages: | English |
| Recommended Training: | DB2 10 for z/OS Administration Workshop DB2 10 for z/OS Performance and Tuning |
| Exam Registration: | Pearson VUE Registration IBM Certification Portal |
| Sample Questions: | ![]() |
| Exam Way: | Onsite at Pearson VUE test centers |
| Pre Condition: | No formal prerequisites; minimum 2 years hands-on experience with DB2 10 for z/OS recommended |
| Official Syllabus URL: | https://www.ibm.com/certify/cert?id=08000202 |
IBM 000-612 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Backup, Recovery and Utilities | 22% | - Data consistency and integrity checks - DB2 utility usage and management - Backup and recovery strategies - Image copies and log management - Restart and recovery procedures |
| Topic 2: Database Design and Implementation | 30% | - Identity columns, sequences and row definitions - Data sharing environment architecture - Physical database implementation - Partitioning strategies and data distribution - Design tables, views, indexes and table spaces |
| Topic 3: Security and Authorization | 20% | - Trusted contexts and authentication - Privileges, authorities and roles - Row and column level access control - Security administration and auditing - Security monitoring and incident response |
| Topic 4: Performance and Availability | 28% | - SQL analysis and tuning - Trace analysis and problem determination - Performance monitoring and metrics - Locking, concurrency and deadlock resolution - Workload Manager (WLM) integration - RUNSTATS, REBIND and access path optimization |
Answers to Your IBM Certified Database Administrator - DB2 10 for z/OS Questions
No formal prerequisites; minimum 2 years hands-on experience with DB2 10 for z/OS recommended Eligibility details like these are worth double-checking before you register — vendors revise them periodically, and the official exam page (official 000-612 exam page) always has the current version.
The official IBM Certified Database Administrator - DB2 10 for z/OS outline has 4 domains — the biggest include Database Design and Implementation (30%), Backup, Recovery and Utilities (22%), Performance and Availability (28%). Those weightings are your study compass: the largest domains hide the most points. See the full outline above for every subtopic.
You can, and you should. The free PDF demo is there so you can judge the content yourself before spending anything. If you're unsure whether the PDF, desktop engine, or online version suits your study habits, contact our 24/7 service team — they'll advise you. After purchase, 365 days of free updates are included, renewable at 50% off if the period ever expires.
Sign up through the vendor's official channels:
The exam is offered Onsite at Pearson VUE test centers, so decide which arrangement suits you before picking a date.
Delivery first: the moment you pay, we send the download link and access details to your email within a minute — even on holidays — and the files install on unlimited computers; contact support if 2 hours pass with nothing. For refunds, the terms are explicit: take the corresponding 000-612 exam within 60 days of purchase, and if you fail, submit a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam for a full refund, processed within 7 days. Excluded: exams taken within 3 days of purchase, name mismatches between candidate and payer, and free or expired products. The alternative to a refund: two equal-value exam products free, with your original updates intact.
The pass mark is 59% - 60%, and the official fee is 200 USD. That fee resets to full price on every retake, so the real money-saver is preparation — run the 134 practice questions from BraindumpsIT until passing becomes routine, then book your seat.
The vendor recommends:
Classroom hours alone won't tell you if you're ready — the 000-612 practice questions from BraindumpsIT will. Use them after the coursework to convert knowledge into exam performance.
The IBM Certified Database Administrator - DB2 10 for z/OS is IBM's official exam for the IBM Certified Database Administrator - DB2 10 for z/OS certification, a Professional-level credential. Candidates take it to validate real skill — and employers read it exactly that way. It also connects to related credentials such as IBM Certified Database Administrator - DB2 11 for z/OS, IBM Certified System Administrator - DB2 for z/OS.
The exam gives you 90 minutes for 63 - 67 questions. The candidates who struggle aren't usually short on knowledge — they're short on pacing. Fix that before test day: set a time budget per question, practice moving past hard items without stalling, and rehearse full timed sessions in the BraindumpsIT engine until the clock stops being a factor.
IBM Certified Database Administrator - DB2 10 for z/OS Sample Questions:
Which stored procedures need to be set up properly in order to register an XML schema?
- A. XSR_REGISTER and XSR_COMPLETE
- B. XSR_REGISTER, XSR_VALIDATE and XSR_COMPLETE
- C. The commands to register a XML schema do not invoke stored procedures.
- D. XSR_ADD_SCHEMA
Correct Answer: A 🗳️
The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?
- A. Number of columns used in an index.
- B. Stage 1 and stage 2 information.
- C. Filter factor information.
- D. Number of times anSQL statement is executed.
Correct Answer: D 🗳️
Altering the DSSIZE is allowed for what type of table space?
- A. Segmented table space.
- B. XML table space.
- C. Universal table space.
- D. DSSIZEcannot be altered.
Correct Answer: C 🗳️
What kind of information is stored in SYSIBM.SYSCOPY?
- A. General information needed for recovery.
- B. Information about currently runningand stopped copy jobs.
- C. Only information about objects which are currently in copy pending.
- D. Only information about existing image copies.
Correct Answer: A 🗳️
Which ALTER TABLE statement will generate a new table space version?
- A. ALTER TABLE ... ADD COLUMN COL2 ...
- B. Altering an already existing VARCHAR column on the table to shorten its maximum length.
- C. ALTER TABLE ... ADD PARTITION ...
- D. ALTER TABLE ... DATA CAPTURE CHANGES ...
Correct Answer: A 🗳️
Free Demo






