TestKing IBM 000-917 Exam Questions & Answers
000-917
System Administration for IBM Informix Dynamic Server V10
Exam number/code: 000-917
Exam name: System Administration for IBM Informix Dynamic
Server V10
Questions & Answers: 152 Q&A
Related Certifications: Certified Specialist, Database Administrator
Hundreds of people each day pass their IT certification exams with Testking
guaranteed certification resources and training kits.
Use the IBM 000-917 questions and answers to practice for your next IBM certification
exam. If you don't pass – you don't pay! Testking has the first and only 100% product
satisfaction and exam passing guarantee. Advanced practice questions and answers help
drive the information into your routine thinking and surpass 000-917 brain dumps in retention
and skill building.
IBM 000-917 exam answers and practice questions can be used at home or office,
installable on up to two PCs, or print the questions and answers to take with you and train
on-the-go! IBM 000-917 preparation tools are the perfect fit for any IBM certification
candidate with 000-917 training materials for every level of entry.
Exam Engine Features
Control your IT training process by customizing your practice certification questions and
answers. The fastest and best way to train.
* Truly interactive practice tests
* Create and take notes on any question
* Retake tests until you're satisfied
* YOU select the areas of the exam to cover
* Filter questions for a new practice test experience each time
* Re-visit difficult questions
TestKing IBM 000-917 Exam Questions & Answers
Exam: 000-917 Certification Questions & Answers
Question 1:
Given the following message log information:
Which of the following does the above message log excerpt most likely indicate?
A. The database server is hung.
B. The databse server crashed and was brought back up.
C. The database server was brought up after a normal shutdown.
D. The database server is stuck in fast recovery mode.
Answer: C
Question 2:
Kernel AIO is configured on a UNIX platform; but the database server is not taking
advantage of it. Which of the following is the most likely reason for this problem?
A. All chunks are created using cooked files.
B. All chunks are created on raw devices.
C. The KAIOON environment variable is on.
D. Only one CPU VP was configured.
Answer: A
Question 3:
In preparing to install the IBM Informix Dynamic Server product, which of the following is the
best resource to find suggested beginning values for kernel parameter settings?
A. Informix Release Notes
B. Informix Reference Manuals
C. Operating System Documentation
D. Administrator's Guide for IBM Informix Dynamic Server
Answer: A
Question 4:
Use the following information to answer this question: A database system consists of two
database servers: server_A and server_B. A customer_A table is created in a stores9
database located on server_A. A second table called customer_B is created in a second
stores9 database located on server_B. A client application connects to server_A. Which of
the following SQL statements can be used to query the customer_B table?
A. select * from stores9@server_B:customer_B
TestKing IBM 000-917 Exam Questions & Answers
B. select * from stores9:customer_B@server_B
C. select * from stores9@instance_A:server_B
D. select * from stores9:customer_B@server_A
Answer: A
Question 5:
Which of the following best describes external backups on the IBM Informix Dynamic
Server?
A. An external backup allows backups using operating system or third-party utilities;
transactions are suspended during external backups.
B. An external backup allows backups using onbar or ontape; database transactions are
suspended during external backups.
C. An external backup allows backups using onbar or ontape; database transactions are
active during external backups.
D. An external backup allows backups using operating system or third-party utilities;
transactions are active during external backups.
Answer: A
Question 6:
Given the following information:
Which of the following best describes what the output represents?
A. The database server was restarted after a normal shutdown and performed normal fast-
recovery tasks.
B. The database server was started for the first time and performed normal fast-recovery
tasks.
C. The database server was restarted after an abnormal shutdown and performed normal
fast-recovery tasks.
D. The database server was restarted after restoring dbspaces from an archive and a post-
archive fast recovery was performed.
Answer: C
Question 7:
A mission critical database system has 10GB of data, and continuously processes large
numbers of transactions. To minimize data loss and system recovery time, which of the
following is the best backup strategy for this database system?
A. Perform the physical backup daily; run continuous backup of logical logs.
B. Perform the physical backup weekly; run continuous backup of logical logs.
C. Perform the physical backup weekly; do not back up logical logs.
D. Perform the physical backup hourly; do not back up logical logs.
Answer: A
TestKing IBM 000-917 Exam Questions & Answers
Question 8:
Which of the following network protocols does the IBM Informix Dynamic Server support?
A. SNMP
B. IPX/SPX
C. Shared memory
D. Named pipe
Answer: B
Question 9:
A Database Administrator has written a script that receives event-alarm parameters and
sends email whenever the logical logs have filled. What must be done to enable the
database server to use the script?
A. Set the ALARMPROGRAM configuration parameter to the full path and filename of the
script, and restart the database server.
B. Move the alarm program to the $INFORMIXDIR/etc directory, set the
SYSALARMPROGRAM configuration parameter to the name of the script, and restart the
database server.
C. Set the SYSALARMPROGRAM configuration parameter to the full path and filename of
the script, and restart the database server.
D. Move the alarm program to the $INFORMIXDIR/etc directory, set the ALARMPROGRAM
configuration parameter to the name of the script, and restart the database server.
Answer: A
Question 10:
A Database Administrator is configuring the NETTYPE configuration parameter to set the
number of poll threads for shared memory connections. The administrator would like to allow
100 users, 2 poll threads, and run the poll threads on a CPU VP. Based on the above
information, the Database Administrator should configure the NETTYPE parameter with
which of the following entries?
A. ipcshm,2,100,CPU
B. ipcshm,100,2,CPU
C. ipcshm,2,50,CPU
D. ipcshm,50,2,NET
Answer: C
Question 11:
Several users running the same application have reported that they are receiving deadlock
errors. Which command can be used to monitor the number of deadlocks that have
occurred?
A. onstat -p
B. onstat -g spi
C. onstat -k
D. onstat -g ses
Answer: A
TestKing IBM 000-917 Exam Questions & Answers
Question 12:
Which of the following storage types can be used when creating chunks?
A. Cooked files, Entire raw device, Portions of raw devices
B. Raw devices, Cooked files, File systems directories
C. Cooked files, Raw devices, NFS mounted file system directories
D. Remote raw device or remote cooked file
Answer: A
Question 13:
Which of the following sysmaster tables contains similar information as the output from the
'oncheck -pe' command?
A. systables
B. sysfragments
C. sysextents
D. syschunks
Answer: C
Question 14:
To manually install the IBM Informix Dynamic Server product, which of the following
environment variables must be set?
A. INFORMIXDIR, INFORMIXSERVER, PATH
B. INFORMIXDIR, PATH
C. INFORMIXDIR, INFORMIXSQLHOSTS
D. INFORMIXDIR, INFORMIXSERVER, ONCONFIG
Answer: B
Question 15:
The sqlhosts file is on a UNIX machine that supports the Transport Layer Interface and uses
the TCP/IP protocol. Which of the following NETTYPE entries should be specified in the
sqlhosts file?
A. onsoctcp
B. ontlitcp
C. onsocspx
D. ontlispx
Answer: B
Related 000-917 Exams:
000-132 000-130 000-190 000-428 000-427
000-425 000-424 000-915 000-914 000-816
000-389 000-974 000-229 000-388 000-973
TestKing IBM 000-917 Exam Questions & Answers
000-228 000-387 000-386 000-385 000-223
000-382 000-222 000-512 000-671 000-085
000-906 000-081 000-969 000-968 000-966
000-965 000-961 000-866 000-960 000-864
000-119 000-863 000-118 000-370 000-210
000-701 000-115 000-700 000-114 000-113
000-111 000-601 000-600 000-665 000-014
000-079 000-076 000-074 000-071 000-070
000-858 000-208 000-857 000-207 000-856
000-206 000-855 000-205 000-204 000-203
000-268 000-202 000-201 000-266 000-200
000-754 000-753 000-752 000-751 000-750
000-551 000-550 000-357 000-749 000-351
000-748 SPS-100 000-747 000-M64 000-746
000-745 000-253 000-252 000-743 000-742
000-741 000-740 000-645 000-153 000-152
000-642 000-641 000-050 000-839 000-736
000-639 000-798 000-638 000-732 000-637
000-636 000-635 000-634 000-633 000-535
000-923 000-239 000-331 000-330 000-884
Popular Certification Exams:
LX0-101 000-512 000-094 HP0-J18 E20-830
HP0-J17 HP0-D03 NS0-530 NS0-131 HP0-M23
NS0-310 9E0-423 920-533 LOT-957 70-573
Hot Certifications:
CCIE Service SCJP ISQL Server+ MCTS:
Provider Certification Microsoft
Internet
Security and
Acceleration
(ISA) Server
2006,
Configuration
Popular Certification Providers:
BICSI Hitachi Huawei Curam Cisco