1. Home
  2. IBM
  3. C2090-558

Informix 11.70 Fundamentals

Exam Details

  • Exam Code
    :C2090-558
  • Exam Name
    :Informix 11.70 Fundamentals
  • Certification
    :IBM Certifications
  • Vendor
    :IBM
  • Total Questions
    :120 Q&As
  • Last Updated
    :Apr 16, 2025

IBM IBM Certifications C2090-558 Questions & Answers

  • Question 91:

    Which of the following modes is NOT supported by Informix?

    A. On-Line

    B. Quiescent

    C. Replication

    D. Administration

  • Question 92:

    When storing string "ABCD" in a column, which of the following data types will result in a string stored with 2 padded spaces?

    A. VARCHAR (6)

    B. VARCHAR (4,2)

    C. VARCHAR (8,6)

    D. VARCHAR (6,8)

  • Question 93:

    Which of the following methods will allow you to determine how much space is currently in use?

    A. Query the $ table

    B. Query the sysstats database

    C. Query the sysusers database

    D. Query the sysmaster database

  • Question 94:

    Which one of the following is most suitable for scheduling the periodic collection of data about an instance?

    A. Sensor

    B. Trigger

    C. Stored Procedure

    D. User Defined Routine

  • Question 95:

    When encountering an assertion failure or performance issue, which Informix utility, when run by the DBA, collects and bundles the basic diagnostic data?

    A. ontape

    B. onmode

    C. ifxcollect

    D. onparams

  • Question 96:

    In which database does Informix store the information when a new task is created in OpenAdmin Tool's Task Scheduler?

    A. sysutils

    B. sysusers

    C. sysadmin

    D. sysmaster

  • Question 97:

    How does an administrator allocate a new dbspace from the storagepool?

    A. Use the SQL Admin API

    B. Use the oninit command

    C. Use the onadmin command

    D. Use the onspaces command.

  • Question 98:

    Informix is currently in online mode. As a DataBase System Administrator (DBSA), you switch to administration mode with ADMIN_USER_MODE_WITH_DBSA = 0. Who can access Informix databases?

    A. only Informix

    B. only a DBSA

    C. only Informix or a DBSA

    D. only root, Informix or a DBSA

  • Question 99:

    Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?

    A. onsql

    B. onadmin

    C. dbaccess

    D. dbschema

  • Question 100:

    Which of the following can be used to create and drop logical logs?

    A. onlog

    B. ondblog

    C. onspaces

    D. onparams

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-558 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.