IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 1:

  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
  C. Quiescent

• Question 2:

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

  A. column
  B. instance
  C. database
  D. fragment
  A. column

• Question 3:

  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
  A. Flexible Grid

• 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
  B. SD secondary servers use paging files to track pages between checkpoints

• 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
  D. Contains tables that the database server maintains automatically

• Question 6:

  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
  C. oncheck -pe

• Question 7:

  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
  C. in the dbspace where the current database was created

• Question 8:

  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
  D. SELECT from table XYZ on database ABC at server LMN

• 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
  A. dbspace
  D. smart blobspace

• Question 10:

  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
  C. sysmaster