Short on study time before your 000-611 exam? The 118 practice questions from Actual4Exams focus on the objectives that matter most in the IBM DB2 10.1 DBA for Linux, UNIX, and Windows test, so every review session counts. Download the PDF and turn spare minutes into real progress.
IBM 000-611 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 10.1 DBA for Linux, UNIX, and Windows |
| Exam Number: | C2090-611 |
| Real Exam Qty: | 64 |
| Exam Format: | Multiple Choice |
| Related Certifications: | IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows |
| Available Languages: | English |
| Exam Duration: | 90 minutes |
| Sample Questions: |  |
| Exam Way: | Authorized IBM/Pearson VUE testing center or online proctored exam (where available). |
| Pre Condition: | It is recommended that candidates first pass the DB2 10.1 Fundamentals exam (C2090-610) before pursuing the IBM Certified Database Administrator certification. |
IBM 000-611 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: DB2 Utilities and Problem Determination | - Administration utilities
|
| Topic 2: Planning and Installing DB2 | - Installation planning
|
| Topic 3: Backup, Recovery, and High Availability | - Data protection
|
| Topic 4: Performance Monitoring and Maintenance | - Performance management
|
| Topic 5: Creating and Managing Databases | - Database configuration
|
| Topic 6: Security and Authorization | - Database security administration
|
IBM DB2 10.1 DBA for Linux, UNIX, and Windows (000-611) — Questions Candidates Actually Ask
The 000-611 exam, officially known as IBM DB2 10.1 DBA for Linux, UNIX, and Windows, is the IBM test that leads to the IBM Certified Database Administrator certification at the Professional level. Passing it validates the skills employers expect from a certified professional. It is also associated with related credentials such as IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows.
The 000-611 exam contains 64 questions, and you have 90 minutes to complete them. Work out your per-question pace before test day, and flag slow items instead of stalling on them — time pressure, not knowledge, sinks many first attempts. Timed mock exams in the Actual4Exams test engines are the most reliable way to build that rhythm.
It is recommended that candidates first pass the DB2 10.1 Fundamentals exam (C2090-610) before pursuing the IBM Certified Database Administrator certification.
Yes. A free PDF demo of the IBM DB2 10.1 DBA for Linux, UNIX, and Windows questions is available, so you can check the question style and answer quality before you pay. Every purchase also includes 365 days of free updates, and if the product expires you can renew the update service at a 50% discount from your member zone.
If you take the corresponding 000-611 exam within 60 days of purchase and do not pass, you can apply for a full refund under the 100% Money Back Guarantee: submit a scan of your enrollment slip and your official Score Report (PDF) within 2 days of the exam date, and the claim is processed within 7 days. Attempts made within 3 days of purchase, downloads without an actual exam attempt, free materials, and expired orders are not eligible, and the candidate name must match the payer name. Prefer new material instead of a refund? You can exchange your purchase for two free products of equal value and keep the update service on your original product. As for delivery, the files are available for instant download and are also emailed to you within one minute of payment — if nothing arrives within 2 hours, contact customer service. There is no limit on how many computers you can install the product on.
The official IBM DB2 10.1 DBA for Linux, UNIX, and Windows outline is organized into 6 domains. The first three are:
- Backup, Recovery, and High Availability
- Performance Monitoring and Maintenance
- DB2 Utilities and Problem Determination
See the complete exam topics section above for the full outline and the weighting of every domain.
IBM DB2 10.1 DBA for Linux, UNIX, and Windows Sample Questions:
Question 1
Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?
A. ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';
ALTER TABLESPACE my_ts REBALANCE;
B. ALTER TABLEPACE my_ts MANAGED BY DATABASE;
ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;
C. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE
STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';
ALTER TABLESPACE my_ts REBALANCE;
D. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;
Question 2
Table TAB_A resides within table space TBSP_1.
Which statement is correct?
A. A flash copy of TAB_A will be made at the beginning of the LOAD because of the COPY YES option. This copy allows applications to read thedata that existed in the table prior to the LOAD operation and improves performance since the read operations will not collide with the LOAD.
B. The indexes for TAB_A will not be completely rebuilt because the INCREMENTAL indexing mode is used. Instead, new index keys will beappended to the original indexes. This will improve concurrency for the applications that are reading TAB_A during the LOAD operation.
C. The indexes for TAB_A will be copied at the beginning of the LOAD operation because of the COPY YES option. Since the indexes will also bebuilt using the INCREMENTAL indexing mode, the concurrency of table TAB_A will be maximized for any applications that wish to access thetable.
D. TAB_A is a table that has implicitly hidden columns and the file DEL_FILE contains data for both regular columns and hidden columns. Whilenew data is being loaded into TAB_A, applications will be able to read the data that existed prior to the LOAD operation.
Question 3
Which type of table space can be associated with only one storage group?
A. Automatic storage space (AS)
B. System managed space (SMS)
C. Database managed space (DMS) File
D. Database managed space (DMS) Device
Question 4
Which statement regarding compression for temporary tables is true?
A. Compression for temporary tables can be dynamically enabled and disabled.
B. Temporary tables can only be compressed using classic row compression.
C. Temporary tables can only be compressed using adaptive compression.
D. The DB2 optimizer automatically decides to use classic row compression or adaptive compression for temporary tables.
Question 5
Which statement about the db2pd tool is true?
A. It ensures that information is not retrieved on changing data.
B. It may retrieve data that is not completely accurate.
C. It collects information from the log buffer and active log files.
D. It collects information from the snapshot monitor and a predefined set of event monitors.
Solutions:
| Question 1 Answer: D | Question 2 Answer: D | Question 3 Answer: A | Question 4 Answer: B | Question 5 Answer: B |
No help, Full refund!
Actual4Exams confidently stands behind all its offerings by giving Unconditional "No help, Full refund" Guarantee. Since the time our operations started we have never seen people report failure in the IBM 000-611 exam after using our products. With this feedback we can assure you of the benefits that you will get from our products and the high probability of clearing the 000-611 exam.
We still understand the effort, time, and money you will invest in preparing for your certification exam, which makes failure in the IBM 000-611 exam really painful and disappointing. Although we cannot reduce your pain and disappointment but we can certainly share with you the financial loss.
This means that if due to any reason you are not able to pass the 000-611 actual exam even after using our product, we will reimburse the full amount you spent on our products. you just need to mail us your score report along with your account information to address listed below within 7 days after your unqualified certificate came out.
