IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 31:

  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 32:

  How can you determine which databases are created in an instance?

  A. use dbschema utility
  B. inspect ONCONFIG file
  C. List reserved pages with oncheck -pr
  D. run SELECT name FROM sysmaster:sysdatabases
  D. run SELECT name FROM sysmaster:sysdatabases

• Question 33:

  A progammer wants to unload a table to a file inside a stored procedure. What functionality listed below will help the programmer accomplish the task?

  A. dbload
  B. dbexport
  C. external table
  D. SQL unload statement
  C. external table

• Question 34:

  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
  C. only Informix or a DBSA

• Question 35:

  Which isolation level is appropriate if you do not want your query to place any locks?

  A. Dirty Read
  B. Cursor Stability C. Committed Read
  D. Repeatable Read
  A. Dirty Read

• Question 36:

  Which of the following is required for a cold restore?

  A. A restore that includes the rootdbs
  B. A restore that includes temp dbspaces
  C. A restore that includes only non-critical dbspaces.
  D. A restore that includes multiple level to be restored.
  A. A restore that includes the rootdbs

• Question 37:

  Which of the following methods can be used to tranfer data in EXPRESS mode?

  A. dbload
  B. external tables
  C. onload/onunload
  D. dbexport/dbimport
  B. external tables

• Question 38:

  Which of the following statements can be used to prevent duplicate values in an indexed column?

  A. CREATE HASH INDEX
  B. CREATE UNIQUE INDEX
  C. CREATE DISTINCT TYPE
  D. CREATE CLUSTER INDEX
  B. CREATE UNIQUE INDEX

• Question 39:

  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

• Question 40:

  Which two statements about oninit are correct? (Choose two.)

  A. oninit can be used to initialize an Informix instance.
  B. oninit -m starts an Informix instance in multi-user mode.
  C. oninit -j starts an Informix instance in administration mode.
  D. oninit has a functionally equivalent Administration API command string.
  E. oninit can be used to change an instance from quiescent mode to online mode.
  A. oninit can be used to initialize an Informix instance.
  C. oninit -j starts an Informix instance in administration mode.