← Back to exam page

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

Free demo downloads

Loading demo links...

Showing 1–3 of 10 questions

Question 1

In addition to examining the Connection Manager log file, what are two ways to monitor the Connection Manager status? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    onstat
  • ○

    onmode
  • ○

    oncmsm
  • ○

    onmonitor
  • ○

    OpenAdmin Tool
Question 2

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.)

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.
Question 3

Which two types of locks are used by Informix to access a shared memory buffer? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Byte
  • ○

    Shared
  • ○

    Update
  • ○

    Exclusive
  • ○

    Promotable