IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 11:

  What is the default isolation level on a database with unbuffered logging?

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

• Question 12:

  Which two tasks can be accomplished using the OpenAdmin Tool (OAT)? (Choose two.)

  A. Manage Virtual Processors (VP).
  B. Automate the update statistics process.
  C. Perform installation of an Informix server.
  D. Run the High Performance Loader (HPL) GUI tool.
  E. Remove an instance's orphaned shared memory segment.
  A. Manage Virtual Processors (VP).
  B. Automate the update statistics process.

• Question 13:

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

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

• Question 14:

  Given the query shown below:

  

  What will happen?

  A. All rows will be retrieved in which item_desc contains the characters 'pencil'.
  B. All rows will be retrieved in which item_desc does not contain the characters 'pencil'.
  C. All rows will be retrieved in which item_desc contains the letters 'p', 'e', 'n', 'c', 'i' and 'l' in any order.
  D. All rows will be retrieved in which item_desc contains the letters "P', 'E', 'N, C', I' and 'L' in any order.
  A. All rows will be retrieved in which item_desc contains the characters 'pencil'.

• Question 15:

  You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?

  A. sqlhosts file must be called sqlhosts
  B. set INFORMIXSQLHOSTS variable to /newlocation/sqlhosts
  C. set INFORMIXSQLHOSTS variable to /newlocation/newsqlhosts
  D. sqlhosts file must be defined under $INFORMIXDIR/etc/ directory
  C. set INFORMIXSQLHOSTS variable to /newlocation/newsqlhosts

• Question 16:

  Which two products can be used by client applications to connect to Informix instances? (Choose two.)

  A. IBM Global Connect
  B. IBM Informix Connect
  C. IBM Informix JDBC Driver
  D. IBM Informix Office Manager
  E. IBM Informix Universal Driver Kit
  B. IBM Informix Connect
  C. IBM Informix JDBC Driver

• Question 17:

  In which way is a Remote Standalone (RS) secondary server different from a High- Availability Data Replication (HDR) secondary server?

  A. RS secondary servers do not support DRAUTO.
  B. RS secondary servers support replication at the column level
  C. You can have more than one RS secondary server in a cluster.
  D. RS secondary servers can be directly upgraded to a primary server.
  C. You can have more than one RS secondary server in a cluster.

• Question 18:

  Which two events can initiate a trigger on a table? (Choose two.)

  A. DROP
  B. ALTER
  C. INSERT
  D. SELECT
  E. TRUNCATE
  C. INSERT
  D. SELECT

• Question 19:

  Given the following table definition: CREATE TABLE t1(col1 BOOLEAN); Which of the following statements will fail to insert a row?

  A. INSERT INTO t1 values ('t');
  B. INSERT INTO t1 values ('f');
  C. INSERT INTO t1 values (1);
  D. INSERT INTO t1 values (NULL);
  C. INSERT INTO t1 values (1);

• Question 20:

  What are two ways to create table t1 with row level locking? (Choose two.)

  A. Execute the command "create table t1 (c1 int) locking row".
  B. Execute the command "create table t1 (c1 int) lock level row".
  C. Execute the command "create table t1 (c1 int) lock mode row".
  D. Set DEF_TABLE_LOCKMODE to ROW in ONCONFIG before executing "create table t1(c1 int)".
  E. Set the environment variable DEF_TABLE_LOCKMODE to ROW before executing "create table t1(c1 int)".
  C. Execute the command "create table t1 (c1 int) lock mode row".
  D. Set DEF_TABLE_LOCKMODE to ROW in ONCONFIG before executing "create table t1(c1 int)".