Job interviews eventually arrive at the same question: what certifications do you hold? In 2026, IBM credentials remain one of the strongest answers, and the IBM Informix 11.70 System Administrator practice questions from CertkingdomPDF are how busy people earn one.
IBM C2090-919 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | Informix 11.70 System Administrator |
| Exam Number: | C2090-919 |
| Exam Price: | USD 200 (may vary by region) |
| Real Exam Qty: | 63 |
| Certificate Validity Period: | Not specified |
| Exam Format: | Multiple-choice, Multiple-response |
| Passing Score: | 60% |
| Available Languages: | English |
| Exam Duration: | 90 minutes |
| Recommended Training: | IBM Informix 11.70 Administration Training |
| Exam Registration: | IBM Certification Portal Pearson VUE Registration |
| Sample Questions: | ![]() |
| Exam Way: | In-person at Pearson VUE centers or online proctored |
| Pre Condition: | No formal prerequisites; recommended 2+ years of Informix administration experience |
| Official Syllabus URL: | https://www.ibm.com/certify/exams/C2090-919 |
IBM C2090-919 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| System Activity Monitoring and Troubleshooting | 14% | - Locking, concurrency and problem isolation - Message log and system database monitoring - Informix utilities and admin API usage |
| Warehousing | 8% | - Merge and external tables - Star/snowflake schema support |
| Installation and Configuration | 12.5% | - Log configuration and connection protocols - Distributed system and user-defined types - Operating system setup and parameters - Deployment utilities and migration |
| Performance Tuning | 16% | - Checkpoints, statistics and network tuning - Disk layout and PDQ optimization - Shared memory and virtual processor configuration |
| Backup and Restore | 8% | - Onbar and ontape configuration - Backup strategies and recovery modes |
| Space Management | 19% | - Storage pool and extendable chunks - Fragmentation, compression and OLTR - Dbspace, sbspace and chunk management |
| Security | 12.5% | - Auditing, trusted contexts and privileges - Authentication, authorization and encryption |
| Replication and High Availability | 10% | - ER, GRID, HDR and Mach 11 setup - Connection Manager configuration |
Answering Your IBM Informix 11.70 System Administrator Questions
IBM Informix 11.70 System Administrator is an official IBM certification exam, identified by exam code C2090-919. Passing earns you the IBM Certified System Administrator - Informix 11.70 certification, classified at the Administrator level. In hiring, certificates work as a quick, quantitative standard, and this one tells employers your skills passed the vendor's own measurement.
IBM Informix 11.70 System Administrator candidates answer 63 questions within 90 minutes. Efficiency under the clock is a trainable skill, not a talent: decide your per-question budget in advance, flag anything that threatens it, and keep moving. Running timed simulations in the CertkingdomPDF test engine until you finish with time to spare is the most reliable way to make exam day feel controlled rather than rushed.
The IBM Informix 11.70 System Administrator exam requires 60% to pass, and official registration costs USD 200 (may vary by region). Since retakes bill the full USD 200 (may vary by region) again, the economic argument for thorough preparation writes itself. Let the CertkingdomPDF practice tests be your measuring stick: when your scores hold above the passing line across several consecutive sessions, the exam stops being a financial risk.
No formal prerequisites; recommended 2+ years of Informix administration experience
Because vendors adjust their policies, verify the current requirements before registering on the official exam page.
Registration for IBM Informix 11.70 System Administrator goes through the official channels below.
For planning purposes, note that the exam is delivered In-person at Pearson VUE centers or online proctored.
IBM recommends these training options for IBM Informix 11.70 System Administrator candidates.
Whatever training path you take, finish it with question practice: the 123 items in the CertkingdomPDF C2090-919 package are where knowledge turns into exam-day scoring ability.
Yes. CertkingdomPDF provides a free PDF demo of the IBM Informix 11.70 System Administrator questions, so you can evaluate the material before committing. After purchase, updates are free for 365 days, and when your product expires you can extend the update service at a 50% discount.
Your purchase is backed by a 100% money-back guarantee with transparent conditions. Take the IBM Informix 11.70 System Administrator exam within 60 days of purchase; if you fail, you qualify for a full refund, provided the exam matches your product. Attempts within 3 days of purchase do not qualify, and neither do downloaded-but-unused products, free materials, or expired orders; the candidate name must match the payer name. File with a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and claims are processed within 7 days. You may instead choose an exchange: two other exam products of equal value, free, while your original purchase keeps its update service.
Delivery is immediate: files are downloadable at payment and emailed to you within one minute. If nothing arrives within 2 hours, check spam and contact customer service. Installation is unlimited across your computers.
The IBM Informix 11.70 System Administrator syllabus is organized into 8 domains, with the largest being Security (12.5%), System Activity Monitoring and Troubleshooting (14%), and Installation and Configuration (12.5%). The complete breakdown appears in the topics section above; a clear classification of what the exam tests is the first step toward efficient preparation.
IBM Informix 11.70 System Administrator Sample Questions:
Which of the following is NOT a step in setting up HDR for the first time?
- A. Use onmode -d to specify the secondary instance name.
- B. Use oninit -v to bring up the secondary.
- C. Execute a physical restore on the secondary.
- D. Take a level 0 backup of the primary.
Correct Answer: B 🗳️
Which statement about the scope of UPDATE STATISTICS is true?
- A. If the FOR TABLE keywords are specified with a table but without specifying a list of columns, the database server will not recalculate distributions on all of the columns of the specified table.
- B. If the FOR PROCEDURE specification, Table and Column Scope, and Resolution clauses are NOT included, then the statistics are updated for every table and SPL routine in the current database.
- C. If the FOR TABLE keywords are used without specifying the name or synonym of a table, the database will not recalculate distributions for any table in the current database.
- D. If the FOR PROCEDURE keywords are included but the name of any SPL routine is not specified, an error will be returned.
Correct Answer: B 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
Fragment level statistics are NOT supported with which fragmentation strategy?
- A. Interval fragmentation.
- B. List fragmentation.
- C. Round-robin fragmentation.
- D. Expression fragmentation.
Correct Answer: C 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
How can ER onconfig parameters be modified dynamically?
- A. cdr set onconfig
- B. cdr change onconfig
- C. cdr define onconfig
- D. cdr tune onconfig
Correct Answer: B 🗳️
Which is NOT valid information in the SQLHOSTS connectivity file (or on windows the SQLHOSTS registry key)?
- A. Host name and service name.
- B. Database server name or alias.
- C. Number of listener threads.
- D. Connection type.
Correct Answer: C 🗳️
Viewing page 1 out of 25 pages.
Viewing questions 1-5 out of 123 questions.





