IBM C2090-558 - Informix 11.70 Fundamentals Exam

Page:    1 / 24   
Total 120 questions

Which two installation modes are available for Informix? (Choose two.)

  • A. Full
  • B. Typical
  • C. Custom
  • D. Compact
  • E. Complete


Answer : B,C

Which two statements are true about the COMMIT WORK statement? (Choose two.)

  • A. The keyword WORK is optional.
  • B. A single COMMIT WORK can end several BEGIN WORK statements.
  • C. The COMMIT WORK statement releases all row locks but not table locks.
  • D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement.
  • E. A new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK statement in a nonlogged database.


Answer : A,D

Informix is currently in online mode. As a DataBase System Administrator (DBSA), you switch to administration mode with ADMIN_USER_MODE_WITH_DBSA = 0. Who can access Informix databases?

  • A. only Informix
  • B. only a DBSA
  • C. only Informix or a DBSA
  • D. only root, Informix or a DBSA


Answer : C

Which document provides details on preparing an operating system to run Informix?

  • A. Machine Notes
  • B. System User's Guide
  • C. Operating System Guide
  • D. Informix Migration Guide


Answer : A

Which of the following modes is NOT supported by Informix?

  • A. On-Line
  • B. Quiescent
  • C. Replication
  • D. Administration


Answer : C

Page:    1 / 24   
Total 120 questions