Exam Name: DB2 10.1 DBA for Linux, UNIX, and Windows
Certification Provider: IBM
Corresponding Certification: IBM Certified Database Administrator
Over 170159+ Satisfied Customers
DB2 10.1 DBA for Linux, UNIX, and Windows: 000-611 Exam Premium File as PDF & Test Engine
Last Updated: Sep 06, 2026
No. of Questions: 118 Questions & Answers with Testing Engine
Download Limit: Unlimited
This exam has been stopped to register, new exam code replace: C2090-611
Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)
100% Money Back Guarantee
Fast2test has an unprecedented 99.6% first time pass rate among our customers. 
We're so confident of our products that we provide no hassle product exchange.
- Best 000-611 exam practice materials
- Three formats are optional
- 10 years of excellence
- 365 Days Free Updates
- Learn anywhere, anytime
- 100% Safe shopping experience
- Printable 000-611 PDF Format
- Prepared by IBM Experts
- Instant Access to Download 000-611 PDF
- Study Anywhere, Anytime
- 365 Days Free Updates
- Free 000-611 PDF Demo Available
- Online Tool, Convenient, easy to study.
- Instant Online Access 000-611 Dumps
- Supports All Web Browsers
- 000-611 Practice Online Anytime
- Test History and Performance Review
- Supports Windows / Mac / Android / iOS, etc.
- Installable Software Application
- Simulates Real 000-611 Exam Environment
- Builds 000-611 Exam Confidence
- Supports MS Operating System
- Two Modes For 000-611 Practice
- Practice Offline Anytime
Whether you study best on paper or on screen, Fast2test has a IBM DB2 10.1 DBA for Linux, UNIX, and Windows format that fits: a printable PDF, a desktop test engine for Windows, and an online test engine that runs in any browser. All three cover the same 118 000-611 practice questions.
IBM 000-611 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows |
| Exam Number: | A2090-611 |
| Exam Price: | $200 USD |
| Certificate Validity Period: | 3 years |
| Passing Score: | 61% |
| Real Exam Qty: | 59-60 |
| Exam Duration: | 90 minutes |
| Available Languages: | English, Japanese |
| Related Certifications: | IBM Certified Database Associate - DB2 10.1 Fundamentals IBM Certified Advanced Database Administrator - DB2 10.1 for Linux, UNIX, and Windows |
| Exam Format: | Multiple choice, Multiple select |
| Recommended Training: | DB2 10.1 DBA Certification Study Guide DB2 10.1 for Linux, UNIX, and Windows Administration |
| Exam Registration: | IBM Certification Portal Pearson VUE Registration |
| Sample Questions: | IBM 000-611 Sample Questions |
| Exam Way: | In-person at Pearson VUE test centers or online proctored |
| Pre Condition: | No mandatory prerequisites; recommended 6-12 months hands-on DB2 10.1 administration experience |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM 000-611 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Security | 15% | - Authorities, privileges and roles - Label-based access control - Trusted contexts and RCAC - Audit facility implementation |
| Topic 2: Business Rules Implementation | 8.5% | - Use SET INTEGRITY command - Create views with check option - Implement constraints and integrity rules - Develop and manage triggers |
| Topic 3: Connectivity and Networking | 6.5% | - Configure client/server connectivity - DB2 discovery and LDAP integration |
| Topic 4: High Availability and Recovery | 10% | - HADR configuration and management - Crash and roll-forward recovery - Backup and restore operations - DB2 pureScale HA features |
| Topic 5: Utilities | 14% | - Data movement and load utilities - Ingest and Design Advisor tools - REORG, RUNSTATS, REBIND utilities |
| Topic 6: Monitoring DB2 Activity | 10% | - Workload management monitoring - Use administrative views and monitoring functions - Problem determination and diagnostic tools |
| Topic 7: DB2 Server Management | 10% | - Configure and manage DB2 servers, instances and databases - Use autonomic computing features - Schedule jobs and use Visual Explain - Use IBM Data Studio and administration tools |
| Topic 8: Physical Design | 26% | - Create databases and manage database objects - Multi-temperature storage management - Convert to automatic storage databases - Table partitioning and data organization - XML data support and compression |
Your IBM DB2 10.1 DBA for Linux, UNIX, and Windows Questions, Answered
The 000-611 exam, officially titled DB2 10.1 DBA for Linux, UNIX, and Windows, is the qualifying test for the IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows certification from IBM, a credential at the Professional level. Passing it proves you have the skills employers look for in certified professionals, and it can also support progress toward related credentials such as IBM Certified Database Associate - DB2 10.1 Fundamentals, IBM Certified Advanced Database Administrator - DB2 10.1 for Linux, UNIX, and Windows.
The IBM DB2 10.1 DBA for Linux, UNIX, and Windows exam gives you 90 minutes to work through 59-60 questions. That is a steady pace with little room for second-guessing, so train yourself to read each question once, flag the difficult ones, and keep moving. Before exam day, sit at least two full timed sessions in the Fast2test test engine — when the clock feels familiar, it stops being a threat.
You need 61% to pass, and the official registration fee is $200 USD. Fall short and you pay that fee in full again for every retake, which makes solid preparation the cheaper option by far. Work through the Fast2test practice questions until you score comfortably above the passing mark, then book your seat.
No mandatory prerequisites; recommended 6-12 months hands-on DB2 10.1 administration experience Eligibility rules can change over time, so before you register, confirm the latest requirements on the official exam page: IBM 000-611 exam overview.
You can book your 000-611 exam through any of these official registration channels:
The exam is delivered as In-person at Pearson VUE test centers or online proctored, so you can pick the option that fits your schedule when you book.
IBM recommends the following training for IBM DB2 10.1 DBA for Linux, UNIX, and Windows candidates:
Pair that training with the 118 practice questions from Fast2test and you can check your readiness topic by topic before exam day.
Yes. Fast2test offers a free PDF demo for the IBM DB2 10.1 DBA for Linux, UNIX, and Windows exam so you can judge the quality of our questions and answers before paying anything. Every purchase also comes with 365 days of free updates, and once that period expires you can extend your update service at a 50% discount.
Your purchase is protected by a 100% money-back guarantee. If you sit the corresponding 000-611 exam within 60 days of buying and do not pass, send us a scan of your exam enrollment slip together with your official Score Report (PDF) within 2 days of the exam date — the candidate name must match the payer's name — and we will process your full refund within 7 days. Please note that exams taken within 3 days of purchase, materials downloaded without ever sitting the exam, free products, and expired orders are not covered. If you would rather not have a refund, you can exchange your order for two exam products of equal value, free of charge, and keep the update service on your original purchase.
Delivery is instant: your files are emailed to you within one minute of payment and can also be downloaded directly, with no limit on the number of computers you install them on. If nothing has arrived within 2 hours, contact our customer service team and we will sort it out.
The IBM DB2 10.1 DBA for Linux, UNIX, and Windows syllabus is organized into 8 domains. The main areas include High Availability and Recovery (10%), Business Rules Implementation (8.5%), and Connectivity and Networking (6.5%). Scroll up to the Exam Topics section above for the complete, current outline before you plan your study schedule.
IBM DB2 10.1 DBA for Linux, UNIX, and Windows Sample Questions:
Table TAB_A resides within table space TBSP_1.
Which statement is correct?
- A. Using the INSERT INTO and the INCREMENTAL indexing mode allows DB2 to increase the concurrency of table access during the LOADoperation because LOAD will always append the inserted data to the end of the table and the new index pages are also added to the end ofthe existing index when using INCREMENTAL indexing mode.
- B. Using the COPY NO option means the data in any table within table space TBSP_1 cannot be updated or deleted until either a table spacebackup of TBSP_1 or a full database backup is completed.
- C. Using the COPY NO and ALLOW READ ACCESS options means that the existing table data is only readable until the index build phase begins,since no copy of the existing data is made during the LOAD.
- D. Using the ALLOW READ ACCESS option along with INCREMENTAL indexing mode means that the newly inserted data can be accessedbecause of the new CURRENTLY COMMITTED semantics.
Correct Answer: B 🗳️
Which is the suggested way to restore a database with a subset of its original table spaces?
- A. Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed.
- B. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN DATABASE option and specify the set of tablespaces that are needed.
- C. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES option and specify the set of table spaces that areneeded.
- D. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN IMAGE option and specify the set of table spacesthat are needed.
Correct Answer: A 🗳️
Which registry variable is used to enable transparent Lightweight Directory Access Protocol (LDAP)?
- A. DB2LDAP
- B. CLNT_PW_PLUGIN
- C. DB2AUTH
- D. SRVCON_PW_PLUGIN
Correct Answer: C 🗳️
Which statement about the db2pd tool is true?
- A. It collects information from the snapshot monitor and a predefined set of event monitors.
- B. It collects information from the log buffer and active log files.
- C. It may retrieve data that is not completely accurate.
- D. It ensures that information is not retrieved on changing data.
Correct Answer: C 🗳️
A partitioned table named SALES was created as follows:
Which statement about the PARTS_IDX index is true?
- A. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP0.
- B. The index PARTS_IDX will contain 3 partitions; the first partition will be stored in table space TBSP0, the second in TBSP1, and the third inTBSP2.
- C. The index PARTS_IDX will contain 3 partitions and all three partitions will be stored in table space TBSP3.
- D. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space
TBSP3.
Correct Answer: B 🗳️
0 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)
Instant Download 000-611
After Payment, our system will send you the products you purchase in mailbox in a minute after payment. If not received within 2 hours, please contact us.
365 Days Free Updates
Free update is available within 365 days after your purchase. After 365 days, you will get 50% discounts for updating.
Money Back Guarantee
Full refund if you fail the corresponding exam in 60 days after purchasing. And Free get any another product.
Security & Privacy
We respect customer privacy. We use McAfee's security service to provide you with utmost security for your personal information & peace of mind.
Related Exams
Contact Us
If you have any question please leave me your email address, we will reply and send email to you in 12 hours.
Our Working Time: ( GMT 0:00-15:00 ) From Monday to Saturday
Support: Contact now