IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 21:

  You have a database server environment where all databases use buffered logging. In which two conditions are the logical-log buffers in shared memory flushed to the logical log on disk? (Choose two.)

  A. When the buffer is full.
  B. When a checkpoint occurs.
  C. When a user issues a begin work.
  D. When a user commits the transaction.
  E. When a user rolls back the transaction.
  A. When the buffer is full.
  B. When a checkpoint occurs.

• Question 22:

  Which command option should be used to resume an interrupted onbar restore?

  A. -RETRY
  B. -RESTART
  C. -REINTIIALZE
  D. -BEGIN_AGAIN
  B. -RESTART

• Question 23:

  When restoring data, which granularity of object may NOT be restored?

  A. a single table
  B. a single chunk
  C. a single dbspace
  D. an entire instance
  B. a single chunk

• Question 24:

  Which phase of Fast Recovery rolls forward (restores) all transactions since the last checkpoint and rolls back any uncommitted transactions?

  A. Logical Recovery
  B. Physical Recovery
  C. Dbspace Recovery
  D. Transactional Recovery
  A. Logical Recovery

• Question 25:

  Which search condition is allowed in a check constraint?

  A. It can contain aggregates.
  B. It can contain subqueries.
  C. It can contain host variables.
  D. It can contain a range of values.
  D. It can contain a range of values.

• Question 26:

  Which two commands would create a table t1 with page level locking assuming default configuration parameter settings? (Choose two.)

  A. create table t1 (c1 int)
  B. create table t1 (c1 int) locking page
  C. create table t1 (c1 int) lock level page
  D. create table t1 (c1 int) lock mode page
  E. create table t1 (c1 int) locking mode page
  A. create table t1 (c1 int)
  D. create table t1 (c1 int) lock mode page

• Question 27:

  There are two open sessions (session A and session B) that are updating the same tables. Session B is trying to read all rows in the table and is continuously receiving the error "-143 ISAM error: deadlock detected". Which action in session B would allow it to read all of the rows?

  A. commit work;
  B. set isolation to dirty read;
  C. set lock mode to not wait;
  D. set lock mode to nolocking;
  B. set isolation to dirty read;

• Question 28:

  Which utility would you use to print out the physical layout of the instance?

  A. onstat
  B. onmode
  C. onspaces
  D. dbschema
  D. dbschema

• Question 29:

  Given INFORMIXCONTIME = 60 and INFORMIXCONRETRY = 3, if the initial connection attempt fails, what subsequent attempts will be made to connect?

  A. 60 and 120 seconds before aborting
  B. Every 3 minutes within one hour before aborting
  C. Every 3 seconds within one hour before aborting
  D. Wait indefinitely until it is successfully completed
  A. 60 and 120 seconds before aborting

• Question 30:

  Which one of the following is a characteristic of a Decision Support System (DSS) or Data Warehousing environment?

  A. frequent writes
  B. frequent updates
  C. uses query parallelization
  D. typically uses memory resident tables
  C. uses query parallelization