Exam Number/Code:000-915
Exam Name: system administration for infromix dynamic server v9

Testking 000-915 Exam will provide you with exam simulation questions and actual answers that reflect the actual exam
Preparing for the Testking 000-915 exam?Searching 000-915 Test Questions,
000-915 Practice Exam,000-915 Braindumps ? 000-915 practice exam covers all

the practice test objectives to pass 000-915 exam.

Pass your exam at first attempt with our Testking 000-915 study guide,000-915 Braindumps, As well Audio exam, Realistic

Practice Labs, and Interactive Testing Engine.

Our Testking practice test covers the information associated with each 000-915 exam topics in details and includes

information found in no other practice test sites on the web.

Our challenging questions with Correct Answers built to simulate the actual exam. Unlimited, FREE auto-updates so you’re

never behind on any topic. The whole package comes as an automatic download so there’s no waiting or shipping. Our most

questions and answers along with explanations. Our practice test will determine you to take your 000-915 certification exam

and pass the official exam on your first try, guaranteed

Now guaranteed Testking 000-915 exam training is available in various formats to best suit your needs and learning style.

Whether you are a hands-on tactile learner, visually or even a textbook training veteran, Real-Exams has the 000-915 pdf vce

format resources that will enable you to pass your 000-915 test with flying colors.

Comprehensive questions with complete explanations about actualtests 000-915 exam
download 000-915 exam questions accompanied by exhibits
Verified Answers Researched by Industry Experts and almost 100% correct
000-915 exam questions updated on regular basis

IBM 000-915 Transcender Torrent
IBM 000-915 P4S
IBM 000-915 Study Guide
IBM 000-915 Exams
IBM 000-915 Braindumps
IBM 000-915 Pass4sure
IBM 000-915 Real Exams
IBM 000-915 Exam
IBM 000-915 Actual Tests
IBM 000-915 Pdf

000-915 also gives new editions of Real Exams 000-915 for enhancing professional skills and knowledge. These Testking Real Practice Questions 000-

710 are useful for understanding 000-915 exam terminologies and these brain dumps also very useful for enhancing people brain

power. These Testking Real Practice Questions 000-915 are prepare by highly qualified and 000-915 professionals. 000-915 Certification experts’

teams always try to give you real exam environment in these 4shared training materials links.

Question: 1
In preparing to install 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: 2
When configuring the database server for Java support the JVPHOME configuration parameter
should be set to which of the following locations?
A. The Java Development Kit files
B. The Krakatoa installation directory
C. The Informix database installation files
D. The class files that will be complied for external java routine.
Answer: B
Question: 3
Which of the following shell commands will start database server and initialize rootbs?
A. oninit
B. ipcs-m
C. onmode-I
D. onstat-I
E. oninit-ivvy
Answer: E
Question: 4
The System Administrator needs to run applications on the same hhost machine as the database
server. Communications between the client and server must be as fast as possible. Which of the
following nettype entries is the best choice for the sqlhosts file?
A. onipchm
B. onipcstr
C. ontiitcp
D. onsoctcp
Answer: A
Question: 5
In the sqlhosts file, which column number is used to configure the KEEPALIVE option?
A. 1
B. 2
C. 3
D. 4
E. 5
Answer: C
Question: 6
The System Administrator has chosen to create an sqlhosts file in a diretory trhat is not the
default location. How can the environment be configured to use this file?
A. Set the SQLHOSTS environment variable to the name of the sqlhosts file.
B. Set the SQLHOSTS environment variable to the path and name of the sqlhostss file.
C. Set the INFORMIXSQLHOSTS environment variable to the path and name of the sqlhosts file
D. Set the INFORMIXSQLHOSTS environment variable to the path where the sqlhosts file is
located.
Answer: C
Question: 7
To successfully install the IBM Informix Dynamic Server product, which of the following
environment variable must be set?
A. INFORMIXDIR, PATH
B. INFORMIXDIR, INFORMIXSQLHOSTS
C. INFORMIXDIR, INFORMIXSERVER, PATH
D. INFORMIXDIR, INFORMIXSERVER, ONCONFIG
Answer: A
Question: 8
Where must the database server configuration file reside?
A. /etc
B. $ONCONFIG
C. $INFORMIXDIR/etc
D. $INFORMIXDIR/config
Answer: A
Question: 9
The System Administrator wants to change the root chunk size for a newly created instance,
however no database have been created yet. The ROOTSIZE configuration parameter has been
changed to the new value.
Assuming sufficient disk space is available, what, if anything, must be done to implement the size
change and bring up the instance?
A. Stop and restart the database server
B. Add a new chunk with the correct size
C. Completely reinitialize the database server
D. Do nothing; the changes will take effect immediately
Answer: C
Question: 10
The System Administrator is configuring the NETTYPE parameter to set the number of poll
threads, for network connections. The administrator would like to allow 100 total users, 2 poll
threads, and run the poll threads on network virtual processors.
Which of the following NETTYPE values should be used?
A. soctcp, 50,2, CPU
B. soctcp, 2,50,NET
C. ipcshm, 2,50, NET
D. soctcp, 2,100, NET
Answer: B
Question: 11
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 b specified in the sqlhosts file?
A. ontlitcp
B. ontlispx
C. onsocspx
D. onsoctcp
Answer: A
Question: 12
Files need to be configured to establish network connections on a UNIX hosts system named
“texas1″ with an IP address of 192.168.15.100.
The sqlhosts files is as follows:
Usa ontlitcp texas1 sqlexec
Which of the following entries is required in the /etc/hosts file?
A. 192.168.15.100 usa
B. 192.168.15.100 texas 1
C. texas 1 192.168.15.100
D. texas 1 192.168.15.100 usa
Answer: B
Question: 13
Which of the following configuration parameters specifies the maximum amount of time a
transaction will wait on a lock in a distributed database environment?
A. DRTIMEOUT
B. TXTIMEOUT
C. BLOCK_TIMEOUT
D. DEADLOCK_TIMEOUT
Answer: D
Question: 14
Company.com is trying to determine what is the best connection type they should use for their
client applications to connect to the Informix database server. The company will have 100 clients
connecting from different platforms in various locations. The connections must be able to support
multithreaded client connections, multiple connections to the database server, and the
connections must be secure.
Which of the following connection types would be the most effective?
A. Network connection
B. Multiplexed connection
C. Shared memory connection
D. Streamed pipes or named pipes
Answer: A
Question: 15
Which of the following describes an IBM Informix Dynamic Server distributed database
environment? (Select three answer)
A. Database can span across database servers located on the same machine
B. Databases can span across database servers located on different machines.
C. A database on one database server can be accessed from a database on the same server.
D. A database on one database server can be accessed from another database server on the
same machine.
E. One database can be accessed from another database that is on a database server located
on a different machine.
Answer: C,D,E
Question: 16
Images with an average size of 50 bytes are to be stored as large objects in the database. For a
database server that uses a 4KB page size, which of the following methods should be used to
store the objects and utilize disk space most efficiently?
A. Create a normal dbspace to store the large objects.
B. Create a normal dbspace with a 2KB blobpage size to store the large objects.
C. Create a normal dbspace with an 8KB blobpage size to store the large objects.
D. Create a normal dbspace with a 16KB blobpage size to store the large objects.
Answer: A
Question: 17
Which of the following onstat commands list dbspaces and chunks on the database server as well
as read/write statistics for each chunk as well?
A. onstat -d
B. onstat -D
C. onstat -p
D. onstat -P
Answer: B
Question: 18
Which of the following oncheck options will give a detailed smart bolob space disk utilization
report?
A. oncheck -pS
B. oncheck -pB
C. oncheck -pP
D. oncheck -pT
Answer: A

Testking 000-915
TK Questions&Answers(Q & As with Expert Explanations): 166 Q&A
Update: 31/08/2008

Free Down: Testking 000-915
Free Down: Pass4sure 000-915

Dowload PassGuide Practice Test Questions,Training Materials

1. Free News Testking IBM Exams
2. Free Testking IBM 000-905
3. Free testking microsoft MCITP 70-443
4. Free testking ibm IBM certifications
5. Free Testking ibm 000-910
6. Free Testking IBM 000-433
7. Free testking ibm Solutions Expert
8. Free Testking Ibm vce dumps
9. Free Testking ibm 000-917
10. Free PassGuide 000-912 PDF
11. Free Testking IBM 000-918
12. Free Testking IBM 000-911