Free C2090-619: IBM Informix 12.10 System Administrator Exam Questions and Answers

Last updated: September 19, 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.

1. Question #1

   Which ONCONFIG parameter would you use to disable the automatic creation or extension of chunks?

   • A. SP_WAITTIME
   • B. SP_THRESHOLD
   • C. SP_AUTOEXPAND
   • D. SP_CHUNKEXTEND
   Reveal Answer

2. Question #2

   When free memory is limited, which configuration parameter should be set to allow critical database activities to complete successfully?

   • A. LOW_MEMORY_SVR
   • B. LOW_MEMORY_MGR
   • C. LOW_MEMORY_RESERVE
   • D. LOW_MEMORY_PRESERVE
   Reveal Answer

3. Question #3

   When you take a level 2 backup, what data is backed up?

   • A. All new data since the last level 1 backup.
   • B. All new data since the last level 2 backup.
   • C. All logical logs which have not previously been backed up.
   • D. All new data since the last level 0, level 1 or level 2 backup.
   Reveal Answer

4. Question #4

   Which two tasks can be performed through an Informix Grid? (Choose two.)

   Select 2 answers.

   • A. Install Informix products.
   • B. Start Informix servers in a grid.
   • C. Copy external files to grid servers.
   • D. Setup replication automatically in a grid.
   • E. Modify replication server attributes for grid servers.
   Reveal Answer

5. Question #5

   Which is NOT a component of the IBM Mobile Database offering?

   • A. IBM DB2
   • B. IBM Informix
   • C. IBM solidDB
   • D. IBM InfoSphere Warehouse
   Reveal Answer

6. Question #6

   What is the purpose of the GRANT ADMIN privilege?

   • A. Grants the admin privilege to create role separation.
   • B. Grants the admin privilege to perform DBSA functions.
   • C. Grants the admin privilege to use the Open Admin Tool.
   • D. Grants the admin privilege to run SQL administration API commands.
   Reveal Answer

7. Question #7

   Which statement is true about restartable restore?

   • A. ontape can perform restartable restores if a backup is taken to disk.
   • B. Restartable restore is the ability to restart a failed restore using onbar.
   • C. Restartable restore is the ability to restart a failed restore using ontape.
   • D. Restartable restore is the ability to restart an instance using a restore from some other computer.
   Reveal Answer

8. Question #8

   In an organization, all employees are authenticated via domain wide Kerberos single sign- on. The DBSA wants to provide access to the database server for an employee without requesting the Operating System (OS) administrator to create a OS level user account. Which Informix feature does the DBSA need to leverage?

   • A. Mapped users
   • B. Role based users
   • C. Table level access for users
   • D. Label based access for users
   Reveal Answer

9. Question #9

   Which option is available through ifx_grid_connect()?

   • A. Rename a replicated database.
   • B. Enable use of TimeSeries columns in tables.
   • C. Enable automatic creation of templates in a grid.
   • D. Defer propagation of DDL statements to other servers in the grid.
   Reveal Answer

10. Question #10

    What are two requirements for the "ifxclone" utility? (Choose two.)

    Select 2 answers.

    • A. All databases must use logging.
    • B. The source server must be a secondary server.
    • C. Only one server clone process can occur at a time.
    • D. Both the source and target servers must be part of a trusted network environment.
    • E. Both the source and target servers must use the same type of disk space (raw or cooked).
    Reveal Answer