IBM C2090-919 - Informix 11.70 System Administrator Exam

Page:    1 / 25   
Total 123 questions

Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based on remaining free space?

  • A. SP_AUTOGROW
  • B. SP_THRESHOLD
  • C. SP_AUTOEXPAND
  • D. SP_CHUNKEXTEND


Answer : B

When executing the SQL Admin API "defragment table" and "table repack" commands on the customer table, what will happen to the table? (Choose two.) execute function sysadmin:task("defragment table","customer"); execute function sysadmin:task("table repack", "customer");

  • A. Fragments of a table will be combined.
  • B. Rows will be moved to the beginning of table.
  • C. Given sufficient resources the number of extents in the table will be reduced.
  • D. Free space at the end of the table will be released to the dbspace for other tables to use.
  • E. The table will be locked preventing inserts from happening for the duration of the commands.


Answer : B,C

Which sysmaster table can be queried to find the logging status of a database?

  • A. sysdb
  • B. sysdblog
  • C. sysdatabases
  • D. sysdblogstatus


Answer : C

To maximize the performance of your OnBar backup and recovery operations, what should you do?

  • A. Use a commercial storage manager.
  • B. Use the bundled Informix Storage Manager (ISM).
  • C. Use a combination of disk-based and tape-based backup devices.
  • D. Use separate storage devices for instance spaces and logical logs.


Answer : D

Without explicitly setting DBSPACETEMP and TEMPTABLE_NOLOG, where will temporary tables be created by default? (Choose three.)

  • A. The root dbspace.
  • B. The users' home directory.
  • C. The $INFORMIXDIR/tmp directory.
  • D. The dbspace in which the active database was created.
  • E. The /tmp directory or PSORT_DBTEMP.


Answer : A,D,E

Page:    1 / 25   
Total 123 questions