IBM C2090-919 - Informix 11.70 System Administrator Exam
Page: 2 / 25
Total 123 questions
Question #6 (Topic: Topic 1)
Which onstat command will allow the gathering of statistics about the Informix Database
Scheduler tasks that are currently running or scheduled to be run?
Scheduler tasks that are currently running or scheduled to be run?
A. onstat -g dbc
B. onstat -g sch
C. onstat -g adm
D. onstat -g tsk
Answer: A
Question #7 (Topic: Topic 1)
Which statement about in-place migration is true?
A. In-place migration is possible when an Informix instance is migrated from a non-Informix database management system.
B. In-place migration is possible when an Informix instance is migrated from an older version of Informix on the same operating system.
C. In-place migration is possible when an Informix instance is migrated from an older version of Informix on a different operating system.
D. In-place migration requires that the DBA copy the database schema, user data, and user objects from the older version to the newer version of Informix.
Answer: B
Question #8 (Topic: Topic 1)
Identify a scenario when you CANNOT use in-place migration?
A. When you want to change database locale.
B. When you want to migrate from a 32-bit to a 64-bit port of Informix.
C. When you want to defragment some of the heavily fragmented tables.
D. When you want to use new configuration features in the new Informix version.
Answer: A
Question #9 (Topic: Topic 1)
What statement about users accessing a Flexible Grid is true?
A. Every user can execute commands on the Flexible Grid.
B. Only user informix can execute commands on a Flexible Grid.
C. Users have to be authorized to execute Flexible Grid commands.
D. Commands can only be executed from the node on which the Flexible Grid was created.
Answer: C
Question #10 (Topic: Topic 1)
Which object can be defragmented?
A. index
B. external table
C. temporary table
D. system catalog table
Answer: A
