Some people learn best on paper; others need a screen and a countdown timer. ExamTorrent covers both camps with the IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade material in three forms: a printable PDF, a Windows desktop test engine, and an online engine that runs in any browser — all containing the same 000-546 questions.
IBM 000-546 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade |
| Exam Number: | 000-546 |
| Real Exam Qty: | 57 |
| Exam Duration: | 90 minutes |
| Certificate Validity Period: | No fixed validity period (legacy certification, now retired) |
| Exam Format: | Multiple Choice, Multiple Response |
| Passing Score: | 70% |
| Available Languages: | English, Japanese |
| Exam Price: | USD 100 |
| Related Certifications: | IBM Certified Database Administrator - DB2 9.7 for Linux, UNIX and Windows |
| Sample Questions: | ![]() |
| Exam Way: | Authorized IBM/Pearson VUE testing center (onsite); legacy exam that has since been retired. |
| Pre Condition: | Upgrade exam intended for candidates already holding an earlier IBM DB2 Database Administrator certification (such as DB2 9 DBA for Linux, UNIX and Windows) and wishing to upgrade to the DB2 9.7 certification. |
| Official Syllabus URL: | https://www.ibm.com/training/certification/ |
IBM 000-546 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Database and Instance Management | 20% | - Manage instances and databases
|
| Topic 2: Security | 10% | - Implement database security
|
| Topic 3: Installation and Migration | 10% | - Install and upgrade DB2 9.7
|
| Topic 4: Backup, Recovery and High Availability | 20% | - Protect database availability
|
| Topic 5: Performance Monitoring and Tuning | 17% | - Monitor and optimize performance
|
| Topic 6: Planning | 8% | - Installation planning
|
| Topic 7: Problem Determination and Utilities | 15% | - Troubleshoot and maintain databases
|
000-546 Exam FAQs: What Candidates Ask Before Booking
Registering for the 000-546 exam costs USD 100 at the official rate, and you need 70% to pass. Bear in mind that an unsuccessful attempt is not discounted the second time around — a retake is charged at the full fee again. That is why experienced candidates test themselves with the 78 practice questions from ExamTorrent until their results are consistently strong before spending money on the real thing.
Yes, and we encourage it. A free PDF demo of the 000-546 questions is available so you can evaluate the quality and layout before buying. After purchase, your material stays current with 365 days of free updates — and if that period ever expires, you can extend the update service at a 50% discount through your member zone.
You will face 57 questions within a time allowance of 90 minutes. Raw numbers aside, the real skill is pacing: candidates who run out of time usually spent too long on early questions. Our advice is to set a mental per-question budget, skip and revisit anything that stalls you, and complete at least two full timed runs in the ExamTorrent test engine before the real appointment so the clock never rattles you.
Both situations are covered. Take the corresponding 000-546 exam within 60 days of purchase without passing, and you may claim a full refund under our 100% Money Back Guarantee: submit a scanned exam enrollment slip plus the official Score Report PDF within 2 days of your exam date, and we finish processing within 7 days. The conditions are strict — an exam taken within 3 days of purchase does not qualify, the candidate's name must match the payer's, and free materials or expired orders are excluded. Would you rather keep studying? Swap the order for two other exam products of equal value free of charge while keeping updates on your original purchase. As for delivery, it is immediate: files unlock for download the moment payment clears, a copy reaches your mailbox within a minute, and there is no cap on how many computers you install it on — if 2 hours pass with nothing received, contact our support team.
Passing the 000-546 exam earns you the DB2 certification, a Professional-level credential. It is the vendor's official proof that your skills meet the standard employers look for, and it regularly appears as a requirement in job postings. The certification also relates to IBM Certified Database Administrator - DB2 9.7 for Linux, UNIX and Windows, so it can anchor a broader certification plan rather than stand alone.
Upgrade exam intended for candidates already holding an earlier IBM DB2 Database Administrator certification (such as DB2 9 DBA for Linux, UNIX and Windows) and wishing to upgrade to the DB2 9.7 certification. Because vendors revise their eligibility rules from time to time, treat this as a starting point and verify the latest requirements on the official exam page — see the official 000-546 exam outline before you commit to a test date.
The vendor organizes the IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade blueprint into 7 domains, led by Installation and Migration (10%), Backup, Recovery and High Availability (20%), Database and Instance Management (20%). Every domain contains further subtopics, and the weighting tells you where your study hours pay off most — the full outline above has the complete picture, so review it before building your study plan.
IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Sample Questions:
Which two of the following can now be monitored with DB2 v9.7? (Choose two.)
- A. Deadlocks, lock timeouts, and lock waits.
- B. Unit of work total memory usage.
- C. Memory consumption by static and dynamic SQL statements.
- D. Unit of work total CPU usage.
- E. Memory consumption by static SQL statements.
Correct Answer: A,D 🗳️
When storing XML data in a DB2 database, which statement is valid?
- A. A table with an XML column can be defined in a non-Unicode database but the table containing the XML column will be stored in Unicode.
- B. A table with an XML column can be defined in a non-Unicode database.
- C. A table with an XML column can only be defined in a Unicode database.
- D. A table with an XML column can be defined in a non-Unicode database but the database must be converted to Unicode before the XML columns can be used.
Correct Answer: B 🗳️
How would you set the client information for a particular activity in a database using Workload Manager (WLM)?
- A. Use the WLM_SET_CLIENT_INFO audit function
- B. Use the WLM_SET_CLIENT_INFO table function
- C. Use the WLM_SET_CLIENT_INFO special register
- D. Use the WLM_SET_CLIENT_INFO stored procedure
Correct Answer: D 🗳️
After executing the following statement: ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK What is the expected result?
- A. The high water mark is lowered without moving any extents of TBSP1.
- B. The high water mark for TBSP1 is lowered and the unused space is automatically reclaimed by the system if TBSP1 is an automatic storage table space.
- C. The extents of TBSP1 are moved around to lower the high water mark.
- D. The high water mark for TBSP1 is lowered and the unused space is automatically reclaimed by the system.
Correct Answer: C 🗳️
A table named TAB_A has a primary key and 2 additional indexes that were created by the DBA. If the ADMIN_MOVE_TABLE procedure is used to MOVE table TAB_A from a table space named TS4K to a table space named TS16K, how many indexes will be on the table after the procedure finishes running?
- A. 2
- B. 3
- C. 1
- D. 0
Correct Answer: B 🗳️
Viewing page 1 out of 16 pages.
Viewing questions 1-5 out of 78 questions.







0 Customer Reviews

