IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 71:

  Which objects can be compressed?

  A. CLOBs
  B. smart BLOBs
  C. partition BLOBs
  D. blobspace BLOBs
  C. partition BLOBs

• Question 72:

  The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

  A. The table has a ROWID shadow column.
  B. The table has a Fragment By Range index.
  C. The table has a Unique Key being used by ER.
  D. The Fragment Key is defined with multiple columns.
  E. The Primary Key for the table is referenced by a foreign key constraint.
  A. The table has a ROWID shadow column.
  E. The Primary Key for the table is referenced by a foreign key constraint.

• Question 73:

  Which Informix utility can be used to display contents of logical-log files, either from disk or from backup?

  A. onlog
  B. onclean
  C. ondblog
  D. onspaces
  A. onlog

• Question 74:

  Which ONCONFIG parameter would you use to disable the automatic creation or extension of chunks?

  A. SP_WAITTIME
  B. SP_THRESHOLD
  C. SP_AUTOEXPAND
  D. SP_CHUNKEXTEND
  C. SP_AUTOEXPAND

• Question 75:

  Which object can be compressed?

  A. dictionary table
  B. temporary table
  C. attached b-tree index
  D. detached b-tree index
  D. detached b-tree index

• Question 76:

  Which option maximizes performance in an Informix Warehouse (DSS) environment?

  A. Higher value of LOGBUFF.
  B. Higher value of PHYSBUFF.
  C. Higher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORY.
  D. SHMTOTAL set to 0 to allow Informix to access all available physical memory.
  D. SHMTOTAL set to 0 to allow Informix to access all available physical memory.

• Question 77:

  Which statement is true about restartable restore?

  A. ontape can perform restartable restores if a backup is taken to disk.
  B. Restartable restore is the ability to restart a failed restore using onbar.
  C. Restartable restore is the ability to restart a failed restore using ontape.
  D. Restartable restore is the ability to restart an instance using a restore from some other computer.
  B. Restartable restore is the ability to restart a failed restore using onbar.

• Question 78:

  Which statement accurately describes the selective row-level auditing feature in Informix?

  A. Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.
  B. Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.
  C. Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.
  D. Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.
  B. Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.

• Question 79:

  Which Informix utility can be used to customize the onconfig file?

  A. ifxdeploy
  B. genoncfg
  C. dbaccess
  D. onparams
  B. genoncfg

• Question 80:

  Which configuration parameter can be set to quickly return rows to a user while a query continues processing?

  A. OPTOFC
  B. OPTMSG
  C. OPT_GOAL
  D. OPTCOMPIND
  C. OPT_GOAL