system administration for infromix dynamic server v9 : 000-915 Exam
Test information:
• Number of questions: 83
• Time allowed in minutes: 120
• Required passing score: 79%
Related certifications:
• IBM Certified Solutions Expert — Informix Dynamic Server V9 System Administrator
• IBM Certified Database Administrator — DB2 9 DBA for Linux UNIX and Windows
Exam Topics Include:
• Installation and Configuration
• Client/Server Communications
• System Activity Monitoring
• Troubleshooting
• Performance Tuning
• dbspace Configuration
• Normal Operations
• Backup and Restore
Product Description
Exam Number/Code: 000-915
Exam Name:system administration for infromix dynamic server v9
“system administration for infromix dynamic server v9″, also known as 000-915 exam, is a IBM certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 166 Q&As to your 000-915 Exam preparation. In the 000-915 exam resources, you will cover every field and category in Solutions Expert helping to ready you for your successful IBM Certification.
Exam Details
Job Role Description / Target Audience:If you are knowledgeable with Informix Dynamic Server Version 9 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of Informix databases, you may benefit from this certification role. To attain the IBM Certified Solutions Expert – Informix Dynamic Server V9 System Administrator certification, candidates must be Certified as a System Administrator for Informix Dynamic Server Version 7, and pass 1 test(000-915).
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 Question: 19
Given the following information:
The name of a device to be used is ‘/dev/rawdev1′ The first 10 kilobytes of this device cannot be used;
Which of the following commands adds a chunk 10 100,000 kilobytes to the ‘datadbs1′ dbspace?
# pass4sure ibm 000-915 Questions and Answers : 166 Q&As
# Updated: October 3rd , 2008
# Price: $159.99 $99.99
Free down:Testking ibm 000-915
Free down:Pass4sure ibm 000-915
| IBM Free Downloads |
|
Type |
Exam Bible | New Questions & Answers |
Latest Updated |
Download link |
 |
All Ibm 's Exam Pack |
767 |
1 days ago | Download |
If you would like to make a comment, please fill out the form below.
[...] pass4sure 000-701 Exam : IBM DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration pass4sure 000-915 Exam : System Administration for IBM Informix Dynamic Server V9 pass4sure 000-917 Exam : System [...]
[...] pass4sure 000-701 Exam : IBM DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration pass4sure 000-915 Exam : System Administration for IBM Informix Dynamic Server V9 pass4sure 000-917 Exam : System [...]
[...] Pass4sure 000-915 Testking 000-915 Actualtest 000-915 [...]