Free C2090-619: IBM Informix 12.10 System Administrator Exam Questions and Answers
IBM Informix 12.10 System Administrator is exam C2090-619, part of the IBM Professional Certification Program. IBM exams you book carry a C1000- code, with S2000- used for specialty credentials, and the three digits are a sequential counter across the whole portfolio rather than a product family — a higher number simply means newer. C2090- and C2010- are the legacy series and are all but extinct.
Candidates comparing C2090-619 exam dumps, ExamTopics and other C2090-619 practice tests use this page for the answers and explanations behind each question. Download the free C2090-619 PDF, then sit the timed C2090-619 exam simulation before booking with IBM.
Last updated: November 4, 2026
- Exam code
- C2090-619
- Provider
- IBM
- Questions in our bank
- 1000+
- Free to read
- First 10, with answers
- Our test mode duration & pass mark
- 130 mins · 70%
- Verified answers
- Reviewed weekly
Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.
Question #1
An Informix server has 12 logical log files of 10,000 KB each. The ONCONFIG file contains LTXHWM 80, LTXEHWM 90 and DYNAMIC_LOGS 0. A single transaction begins consuming log space. At approximately how much logical log space used by that transaction will the server first treat it as a long transaction and begin rolling it back?
Correct answer: B
Explanation
Total logical log space is 12 x 10,000 KB = 120,000 KB. The long transaction high-watermark is 80 percent of that, so 0.80 x 120,000 = 96,000 KB. The 108,000 KB figure is the LTXEHWM point (90 percent), where the rollback gets exclusive access to the log, and that is later than the point where rollback begins.
Continue with C2090-619: IBM Informix 12.10 System Administrator
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in C2090-619: IBM Informix 12.10 System Administrator, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #2
Before installing Informix on Linux, an administrator reviews the kernel settings. Which two kernel parameters set the maximum size of a single shared memory segment and the total amount of shared memory allowed system-wide? (Choose two.)
Select 2 answers.
Correct answer: A, B
Explanation
kernel.shmmax limits the size of one shared memory segment and kernel.shmall limits the total shared memory pages for the system. kernel.sem governs semaphores and kernel.msgmax governs message queue size, so neither controls shared memory sizing.
Continue with C2090-619: IBM Informix 12.10 System Administrator
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in C2090-619: IBM Informix 12.10 System Administrator, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #3
Which statement creates an index on the orders table while allowing other sessions to continue reading and modifying the table?
Correct answer: D
Explanation
The ONLINE keyword makes CREATE INDEX build the index without placing an exclusive lock on the table, so concurrent DML continues. FILLFACTOR sets how full index pages are and USING BTREE chooses the access method. Neither changes locking, and a clustered index rewrites the table under an exclusive lock.
Continue with C2090-619: IBM Informix 12.10 System Administrator
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in C2090-619: IBM Informix 12.10 System Administrator, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #4
An administrator must create a logged sbspace named sbsp1 to hold CLOB data. The space uses the raw device /dev/rsb1, an offset of 0 and a size of 1000000 KB. Which command should be used?
Correct answer: D
Explanation
The -S option creates an sbspace, and the -Df clause sets default smart large object attributes such as LOGGING=ON. The -d option creates an ordinary dbspace and -b creates a blobspace, neither of which stores smart large objects. The -t option creates a temporary sbspace, which is not logged.
Continue with C2090-619: IBM Informix 12.10 System Administrator
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in C2090-619: IBM Informix 12.10 System Administrator, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #5
An Informix 12.10 server is backed up with ontape on this schedule, and logical logs are backed up continuously: Sunday: level 0 Monday: level 1 Tuesday: level 2 Wednesday: level 1 Thursday: level 2 The disks fail on Friday morning and a full physical restore is required. Which archives must be restored, in order, before the logical logs are applied?
Correct answer: C
Explanation
A level 1 archive holds all changes since the last level 0, so Wednesday's level 1 replaces Monday's and Tuesday's archives. Thursday's level 2 holds the changes since Wednesday's level 1. Restoring every archive in sequence is unnecessary, and a level 2 archive cannot be applied without the level 1 it depends on.
Continue with C2090-619: IBM Informix 12.10 System Administrator
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in C2090-619: IBM Informix 12.10 System Administrator, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #6
Queries against the orders table frequently filter on ship_status, a column that has no index and whose values are unevenly distributed. An administrator wants the optimizer to have distribution information for this column, built from a sample of the rows rather than a scan of all of them. Which statement should be run?
Correct answer: B
Explanation
MEDIUM builds distributions from a sampled set of rows, which suits filter columns that are not index keys. HIGH reads every row to give exact distributions, which is the opposite of sampling. LOW gathers only table and index statistics, with no column distributions, and DROP DISTRIBUTIONS removes existing ones.
Continue with C2090-619: IBM Informix 12.10 System Administrator
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in C2090-619: IBM Informix 12.10 System Administrator, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #7
The storage pool of an Informix 12.10 server already contains directory and raw device entries. An administrator, connected to the sysadmin database, needs a new 500 MB dbspace named sales_dbs and does not want to supply a path. Which statement should be used?
Correct answer: C
Explanation
The create dbspace from storagepool command takes a name and an initial size and picks space from the pool entries. The plain create dbspace command requires a path and offset. Modify space expand extends a dbspace that already exists, and storagepool add puts new entries into the pool rather than creating a dbspace.
Continue with C2090-619: IBM Informix 12.10 System Administrator
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in C2090-619: IBM Informix 12.10 System Administrator, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #8
Users report that decision-support queries wait a long time to start. An administrator captures this output from onstat -g mgm: MAX_PDQPRIORITY: 100 DS_MAX_QUERIES: 5 DS_MAX_SCANS: 1048576 DS_TOTAL_MEMORY: 400000 KB Queries: Active 5 Ready 9 Maximum 5 Memory: Total 400000 Free 310000 Quantum 80000 (KB) Which action BEST allows more of these queries to run concurrently?
Correct answer: B
Explanation
Five queries are active, which equals the DS_MAX_QUERIES limit, and nine more are ready and waiting. Most of the PDQ memory is still free, so adding memory would not help. MAX_PDQPRIORITY is already at 100, and DS_MAX_SCANS is far above any load shown.
Continue with C2090-619: IBM Informix 12.10 System Administrator
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in C2090-619: IBM Informix 12.10 System Administrator, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #9
Which utility is used to change the size and the dbspace location of the physical log?
Correct answer: C
Explanation
The onparams -p option changes the size and location of the physical log, typically to move it into a dedicated dbspace on a fast disk. The onspaces utility creates and drops storage spaces but does not relocate the physical log. The onmode utility changes server modes and some dynamic settings, and oncheck only checks and repairs disk structures.}
Continue with C2090-619: IBM Informix 12.10 System Administrator
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in C2090-619: IBM Informix 12.10 System Administrator, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Question #10
Auditing is enabled on an Informix 12.10 server. The database system security officer (DBSSO) needs to record the CRTB and DRTB events for user mia, who currently has no individual audit mask defined. Which command should the DBSSO run?
Correct answer: C
Explanation
The onaudit -a option adds a new audit mask for a user, and -e with + lists the events to audit. The -m option modifies an existing mask, so it fails when the user has none. The -d option deletes a mask, and -l sets the audit level rather than defining a user's events.
Continue with C2090-619: IBM Informix 12.10 System Administrator
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in C2090-619: IBM Informix 12.10 System Administrator, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
Discussion
Explain your reasoning, not just the letterOther IBM certifications
- C1000-010: IBM Operational Decision Manager Standard V8.9.1 Application Development (opens in a new tab)
- C2040-986: Creating IBM Lotus Notes and Domino 8.5 Applications with Xpages and Advanced Techniques (opens in a new tab)
- C1000-132: IBM Maximo Manage v8.0 Implementation (opens in a new tab)
- C2090-424: InfoSphere DataStage v11.3 (opens in a new tab)
- C1000-017: IBM Cloud Solutions Architect v3 (opens in a new tab)
- C1000-116: IBM Business Automation Workflow v20.0.0.2 using Workflow Center Development (opens in a new tab)
- C2090-011: IBM SPSS Statistics Level 1 v2 (opens in a new tab)
- C2090-304: IBM InfoSphere QualityStage v9.1 Solution Developer (opens in a new tab)
- C2090-621: IBM Cognos Analytics Author V11 (opens in a new tab)
- C1000-012: IBM Watson Application Developer V3.1 (opens in a new tab)
- C1000-124: IBM Cloud Advocate v1 (opens in a new tab)
- C2070-994: IBM Datacap V9.0 Solution Designer (opens in a new tab)
Reviews
Write a review★★★★★
Exam Practice is worth every penny. The mock exams are realistic, and the feedback helped me focus on key areas.
Amit SharmaVerified buyer
★★★★★
I highly recommend Exam Practice. The feedback after each test helped me improve significantly, and I passed my exams easily.
Oscar NyströmVerified buyer
★★★★★
This platform is a lifesaver. The practice questions and explanations are so detailed. It’s the best study tool I’ve ever used.
Hannah SmithVerified buyer
FAQ
Learn More: https://www.ibm.com/training/credentials
- Q1: What is the C2090-619: IBM Informix 12.10 System Administrator exam?
- A: C2090-619: IBM Informix 12.10 System Administrator is a IBM certification exam. Judging by the questions in our bank, it concentrates on informix, table, parameter, onmode and memory.
- Q2: What topics does the C2090-619: IBM Informix 12.10 System Administrator exam cover?
- A: Questions in our C2090-619: IBM Informix 12.10 System Administrator bank cluster around informix, table, parameter, onmode, memory, parameters, utility and catalog. Working through the full set is the quickest way to find which of these you are weakest on.
- Q3: How should I prepare for C2090-619: IBM Informix 12.10 System Administrator?
- A: Work through the C2090-619: IBM Informix 12.10 System Administrator practice questions here, checking your answer on each one, then sit the practice test to rehearse the exam under timed conditions before the real thing.
- Q4: Are these real C2090-619: IBM Informix 12.10 System Administrator exam questions?
- A: They are drawn from officially released past questions and from community members who have sat C2090-619: IBM Informix 12.10 System Administrator. Answers are verified and updated weekly.
- Q5: Where do I register for the C2090-619: IBM Informix 12.10 System Administrator exam?
- A: Register through IBM directly. Exampractice is not affiliated with IBM and does not administer the exam.
- Q6: Is there a free C2090-619: IBM Informix 12.10 System Administrator sample?
- A: Yes. Every C2090-619: IBM Informix 12.10 System Administrator page shows a free sample of real questions. Upgrading opens the full bank and the practice test.
- Q7: What are IBM Certification Exams?
- A: IBM Certification Exams validate your expertise in using and managing IBM’s suite of products and solutions, including cloud computing, AI, data analytics, cybersecurity, and more. These certifications demonstrate your proficiency in deploying, configuring, and optimizing IBM technologies to drive business success.
- Q8: Why should I pursue IBM Certification?
- A: IBM Certification enhances your professional credibility, showcasing your skills and knowledge in IBM technologies. This can lead to better job opportunities, higher salaries, and career advancement in IT, cloud computing, data analytics, and other tech-related fields.
- Q9: What are the benefits of IBM Certification?
- A: Benefits include recognition as a certified IBM professional, improved job performance, access to exclusive resources, continuing education opportunities, and staying current with the latest IBM technologies and best practices.
- Q10: Who should take IBM Certification Exams?
- A: IT professionals, system administrators, data analysts, cybersecurity experts, developers, and anyone involved in managing and implementing IBM solutions should consider these certifications to validate their expertise and advance their careers.
- Q11: What types of IBM Certification Exams are available?
- A: IBM offers various certification paths, including:
- Q12: How do I prepare for IBM Certification Exams?
- A: Preparation can include official IBM training courses, study guides, practice exams, online tutorials, and hands-on experience with IBM products and solutions.
- Q13: Where can I take IBM Certification Exams?
- A: IBM Certification Exams can be taken at authorized Pearson VUE testing centers worldwide or online, providing flexibility to fit your schedule and location.
- Q14: How do IBM Certifications impact my career?
- A: IBM Certifications significantly boost your career by demonstrating your expertise to employers, making you a more competitive candidate for advanced roles and promotions in IT, cloud computing, data analytics, and other tech-related fields.
- Q15: Are there any prerequisites for IBM Certification Exams?
- A: Some exams may have prerequisites, such as foundational knowledge or prior experience with IBM products. Check the specific requirements for each certification path on the IBM certification website.
- Q16: How often do I need to recertify for IBM Certifications?
- A: IBM Certifications typically require recertification every two to three years to ensure that certified professionals stay updated with the latest technologies and industry practices.