Free C2090-619 – IBM Informix 12.10 System Administrator Practice Test Question

Select all that apply, then click Submit answer.

• ○

  onstat

• ○

  onmode

• ○

  oncmsm

• ○

  onmonitor

• ○

  OpenAdmin Tool
  

Select all that apply, then click Submit answer.

• ○

  The table has a ROWID shadow column.

• ○

  The table has a Fragment By Range index.

• ○

  The table has a Unique Key being used by ER.

• ○

  The Fragment Key is defined with multiple columns.

• ○

  The Primary Key for the table is referenced by a foreign key constraint.
  

Select all that apply, then click Submit answer.

• ○

  Byte

• ○

  Shared

• ○

  Update

• ○

  Exclusive

• ○

  Promotable
  

Select all that apply, then click Submit answer.

• ○

  Target server instance size.

• ○

  Target server instance name.

• ○

  Source server instance sqlhosts.

• ○

  Target server configuration parameters.

• ○

  Source server instance TCP/IP address.
  

Select all that apply, then click Submit answer.

• ○

  Logical log files must always reside in rootdbs.

• ○

  Having too little log space does not affect performance.

• ○

  Having too much log space does not affect performance.

• ○

  Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.

• ○

  Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.
  

Select an option, then click Submit answer.

• ○

  LMM START THRESHOLD = 2MB and LMM STOP THRESHOLD = 3MB

• ○

  LMM START THRESHOLD = 20MB and LMM STOP THRESHOLD = 30MB

• ○

  LMM START THRESHOLD = 500MB and LMM STOP THRESHOLD = 333MB

• ○

  LMM START THRESHOLD = 2% and LMM STOP THRESHOLD = 3% of physical memory in the system
  

Select an option, then click Submit answer.

• ○

  On-disk encryption

• ○

  Enterprise Replication

• ○

  High-Availability Data Replication

• ○

  Server-to-server distributed query communication
  

Select an option, then click Submit answer.

• ○

  The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.

• ○

  The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator (IWA).

• ○

  The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), and
  OLAP expressions are evaluated by Informix database server.

• ○

  The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query will be executed by Informix database server, and the OLAP expressions are evaluated by Informix Warehouse Accelerator (IWA).
  

Select an option, then click Submit answer.

• ○

  Higher value of LOGBUFF.

• ○

  Higher value of PHYSBUFF.

• ○

  Higher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORY.

• ○

  SHMTOTAL set to 0 to allow Informix to access all available physical memory.
  

Select an option, then click Submit answer.

• ○

  By calling the syspurge function.

• ○

  By the purge_tables task of the Scheduler.

• ○

  By setting up the server to automatically run the purge policy.

• ○

  By running ALTER FRAGMENT with the PURGE NOW predicate.