IBM C2090-558 - Informix 11.70 Fundamentals Exam
Page: 1 / 25
Total 120 questions
Question #1 (Topic: Topic 1)
Which two installation modes are available for Informix? (Choose two.)
A. Full
B. Typical
C. Custom
D. Compact
E. Complete
Answer: B,C
Question #2 (Topic: Topic 1)
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
Question #3 (Topic: Topic 1)
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?
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
Question #4 (Topic: Topic 1)
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
Question #5 (Topic: Topic 1)
Which of the following modes is NOT supported by Informix?
A. On-Line
B. Quiescent
C. Replication
D. Administration
Answer: C
