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 07, 2025

IBM IBM Certifications C2090-558 Questions & Answers

  • Question 1:

    Which technology can be used to execute Data Definition Language (DDL) command across multiple instances?

    A. Flexible Grid

    B. Enterprise Replication

    C. High Availability Cluster

    D. High Availability Data Replication

  • Question 2:

    What is the lowest level of granularity supported by Enterprise Replication?

    A. column

    B. instance

    C. database

    D. fragment

  • Question 3:

    Which of the following Informix server modes disable execution of SQL statements for all users while allowing administrative users to perform maintenance tasks?

    A. Offline

    B. On-Line

    C. Quiescent

    D. Administrative

  • Question 4:

    Which of the following statement is correct about Shared Disk (SD) secondary servers?

    A. SD secondary servers support automatic index repair

    B. SD secondary servers use paging files to track pages between checkpoints

    C. SD secondary servers require an HDR secondary server to be present in order to function

    D. SD secondary servers can become a High-Availability Data Replication (HDR) secondary server

  • Question 5:

    Which of the following statement is true of System Monitoring Interface (SMI) tables?

    A. SMI tables store database structures.

    B. Contains tasks used by the database scheduler

    C. SMI tables are also known as System Catalog tables

    D. Contains tables that the database server maintains automatically

  • Question 6:

    You create a table with the statement shown below: CREATE TABLE foo(col INTEGER) In which dbspace will the table reside?

    A. in a temporary dbspace

    B. in the default dbspace that is defined in onconfig

    C. in the dbspace where the current database was created

    D. in the dbspace specified by the IFX_DBSPACE environment variable

  • Question 7:

    You received an error, "Chunk is not empty", while trying to remove a chunk. How do you verify which objects still occupy space in the chunk?

    A. onspaces

    B. onmonitor

    C. oncheck -pe

    D. SELECT * from SYSTABLES

  • Question 8:

    Which database contains the system-monitoring interface (SMI) tables which provide information about the state of the database server?

    A. sysutils

    B. sysstate

    C. sysmaster

    D. sysmonitor

  • Question 9:

    Which two storage objects exist in Informix? (Choose two.)

    A. dbspace

    B. flash space

    C. smart rowspace

    D. smart blobspace

    E. encrypted space

  • Question 10:

    Which of the following is true about the remote query SELECT * FROM ABC@LMN:XYZ?

    A. SELECT from table ABC at database LMN on server XYZ

    B. SELECT from table ABC at server LMN on database XYZ

    C. SELECT from table LMN on database ABC on server XYZ

    D. SELECT from table XYZ on database ABC at server LMN

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.