IBM C2090-619 - IBM Informix 12.10 System Administrator Exam
Page: 3 / 26
Total 130 questions
Question #11 (Topic: )
In addition to examining the Connection Manager log file, what are two ways to monitor the
Connection Manager status? (Choose two.)
Connection Manager status? (Choose two.)
A. onstat
B. onmode
C. oncmsm
D. onmonitor
E. OpenAdmin Tool
Answer: A,E
Question #12 (Topic: )
Which is NOT a valid option to improve service for connection requests under TCP/IP
protocol?
protocol?
A. Adding sm_listen threads.
B. Adding listener threads for additional ports.
C. Dynamically increase the number of listener threads using onmode -P commands.
D. Adding an additional network-interface card to service Informix connection requests.
Answer: A
Question #13 (Topic: )
Which log file CANNOT be rotated using the default "message log rotate" SQL admin
command?
command?
A. audit log
B. message log
C. onbar debug log
D. onbar activity log
Answer: A
Question #14 (Topic: )
The total number of locks allocated equals the value specified by the LOCKS configuration
parameter. What is the behavior of the database server when more locks are now
requested?
parameter. What is the behavior of the database server when more locks are now
requested?
A. The user encounters a lock request error.
B. More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.
C. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.
D. More memory is allocated for additional lock structures in the RESIDENT section of shared memory.
Answer: C
Question #15 (Topic: )
Click on the exhibit. Which type of join is occurring?
A. Star Join
B. ANSI Join
C. Index Self-Join
D. Multi Index Join
Answer: A
