System Administration for IBM Informix Dynamic Server
Questions, Answers, Braindumps (000-918)
Thanks to www.exams.ws and www.examcheats.net
You detected excessive memory usage that might be caused
by a memory leak in the application. Which two commands
would be useful in this scenario? (Choose two.)
A. onstat -u
B. onstat -g sql -r 120
C. onstat -g ses -r 60
D. onstat -g mgm
E. onstat -g mem
ANS C, E
A user wants to save SQL explain output to the file:
/tmp/myexplain.out. Which syntax should be used?
A. set explain on file to /tmp/myexplain.out
B. set explain on file /tmp/myexplain.out
C. set explain file /tmp/myexplain.out
D. set explain file to /tmp/myexplain.out
Both standard and temporary dbspaces are listed in the
DBSPACETEMP configuration parameter or environment variable.
Which rule applies?
A. Sort, backup, implicit, and non-logging explicit
temporary tables are created in temporary dbspaces if
adequate space exists.
B. Backup, implicit, and non-logging explicit temporary
tables are created in temporary dbspaces if adequate
space exists. Sort temporary tables are specified by
the PSORT_DBTEMP environment variable.
C. Sort, backup, implicit, and non-logging explicit
temporary tables are created in all available dbspaces
if adequate space exists.
D. Explicit temporary tables created without the WITH
NO LOG option are created in the root dbspace.
You are receiving an error when trying to drop a chunk
that you think is empty. Which command will show you
if any object is still allocating part of the chunk?
A. oncheck -pe
B. onstat -d
C. oncheck -cD
D. oncheck -cc
How can a database administrator remotely view the entire
A. Query the sysadmin database command_history table.
B. Execute oncheck -showlog.
C. Query the sysmaster database sysonlinelog table.
D. Execute onstat -m.
Which two utilities will help a database administrator
diagnose problems with IDS archive media? (Choose two.)
ANS C, D