1. Home
  2. IBM
  3. C2090-919

IBM C2090-919 Online Practice Questions and Exam Preparation

C2090-919 Exam Details

  • Exam Code
    :C2090-919
  • Exam Name
    :Informix 11.70 System Administrator
  • Certification
    :IBM Certifications
  • Vendor
    :IBM
  • Total Questions
    :123 Q&As
  • Last Updated
    :Jul 11, 2026

IBM C2090-919 Online Questions & Answers

  • Question 121:

    When executing the following command: execute function sysadmin:task("table compress", "customer") what will happen to the customer table?

    A. The rows will be compressed and the table size will decrease.
    B. The table will be taken offline and compressed, and the table size will decrease.
    C. The rows will be compressed and the space allocated to the table will be the same.
    D. The table will be taken offline and compressed, but the space allocated to the table will be the same.

  • Question 122:

    On which node of an Informix H/A cluster can you execute an external backup without disturbing cluster operations?

    A. Primary
    B. Shared disk secondary
    C. Remote standalone secondary
    D. High-availability data replication secondary

  • Question 123:

    Which would provide the greatest performance benefit in a warehousing environment?

    A. Indexes on searched data.
    B. Short checkpoint durations.
    C. Large number ofbufferpool buffers.
    D. Optimize decision support memory.

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-919 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.