C2090-919 Informix 11.70 System Administrator Exam (Exam 2)

C2090-919 Informix 11.70 System Administrator Exam (Exam 2)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which list fragmentation statement is true?

  • Fragment level statistics are NOT supported with which fragmentation strategy?

  • Given the SQL explain output of this star join query, which is the fact table?

  • Which sbspaces statement is FALSE?

  • Under which condition can table fragments NOT be eliminated during query processing?

  • When adding space to the storagepool, which correctly describes the type of storag...

  • Which object can be defragmented?

  • Which statement about Informix data compression is true?

  • Which CANNOT be used to move compressed data from one database to another?

  • Which storage space should be used to store columns defined as a BLOB or a CLOB?

  • What does the SP_WAITTIME variable control?

  • When executing the SQL Admin API "defragment table" and "table repack" commands on...

  • Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based...

  • Which statement about automatic space management is true?

  • Which environment option can rollback transactions using a table involved in an AL...

  • The user 'guest' connected to a local database world@lsys and wants to execute the...

  • Identify a scenario when you CANNOT use in-place migration?

  • If the DYNAMIC_LOGS onconfig parameter is set to 1 and logical log backups are not...

  • What two conditions must be met in order to use Kernel-asynchronous I/O (KAIO)? (C...

  • Which connection type can be used for network connections?

Oct. 20, 2016
review by Christopher Karsten (@christopher4)
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:46 a.m.
    20 questions
    1 completed
    1 takers

  • C2090-919 Informix 11.70 System Administrator Exam (Exam 2) QR code