system administration for infromix dynamic server v9
Index >> IBM >> Solutions Expert >> "000-915"Exam
VUE/Prometric Code：000-915
Exam Name：system administration for infromix dynamic server v9
Questions and Answers：166 Q&As
Price：$79
Updated：2008-11-12
Questions and Answers：166 Q&As
Price：$79
Updated：2008-11-12
| system administration for infromix dynamic server v9 | |||
| Test | Q&A | Updated | Price |
| 000-915 | 166 Q&A | 2008-11-12 | $79 |
please download in PDF format Demo:
killtest 000-915 Exam Features
High quality and Value for the 000-915 Exam.
Killtest Practice Exams for system administration for infromix dynamic server v9 000-915 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.
100% Guarantee to Pass Your Solutions Expert exam and get your Solutions Expert Certification.
We guarantee your success in the first attempt. If you do not pass the 000-915 (system administration for infromix dynamic server v9) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.
killtest 000-915 Downloadable.
Printable Exams (in PDF format) Our Exam 000-915 Preparation Material provides you everything you will need to take your Solutions Expert exam. The Solutions Expert Certification details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get Solutions Expert exam questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first Solutions Expert exam try, but also save your valuable time .
- Comprehensive questions with complete details about 000-915 exam.
- 000-915 exam questions accompanied by exhibits.
- Verified Answers Researched by Industry Experts and almost 100% correct.
- Drag and Drop questions as experienced in the Real Solutions Expert exam.
- 000-915 exam questions updated on regular basis.
- Like actual Solutions Expert Certification exams, 000-915 exam preparation is in multiple-choice questions (MCQs).
- Tested by many real Solutions Expert exams before publishing.
- Try free Solutions Expert exam demo before you decide to buy it in http://www.Killtest.com.
High quality and Value for the 000-915 Exam:100% Guarantee to Pass Your Solutions Expert exam and get your Solutions Expert Certification.
http://www.Killtest.com The safer.easier way to get Solutions Expert Certification.
We offer Demo version of Q&A, Q&A are as follows (not to provide picture):
000-915：please download 000-915 in PDF format Demo
1.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 Dynmaic Server.
Correct:A
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 compiled for external Java routines.
Correct:B
3.Which of the following shell commands will start the database server and initialize rootdbs?
A.oninit
B.ipcs-m
C.onmode-i
D.onstat-i
E.oninit-ivy
Correct:E
4.The System Administrator needs to run applications on the same host 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.onipcshm
B.onipcstr
C.ontlitcp
D.onsoctcp
Correct:A
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
Correct:C
6.The System Administrator has chosen to create an sqlhosts file in a directory that is not the default that 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 SQL HOSTS environment variable to the path and name of the sqlhosts 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.
Correct:C
7.To successfully install the IBM Informix Dynamic Server product, which of the following environment variables must be set?
A.INFORMIXDIR, PATH
B.INFORMIXDIR, INFORMIXSQLHOSTS
C.INFORMIXDIR, INFORMIXSERVER, PATH
D.INFORMIXDIR, INFORMIXSERVER, ONCONFIG
Correct:A
8.Where must the database server configuration file reside?
A./etc
B.$ONCONFIG
C.$INFORMIXDIR/etc
D.$INFORMIXDIR/config
Correct:A
9.The System Administrator wants to change the root chunk size for a newly created instance, however no databases 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.
Correct:C
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.soctop, 50,2,CPU
B.soctcp,2,50,NET
C.ipcshm,2,50 NET
D.soctcp,2,100,NET
Correct:B
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 be specified in the sqlhosts file?
A.ontlitcp
B.ontlispx
C.onsocspx
D.onsoctcp
Correct:A
12.Files need to be configured to establish network connections on a UNIX host 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 texas1
C.texas1 192.168.15.100
D.texas1 192.168.15.100 usa
Correct:B
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
Correct:D
14.A company 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
Correct:A
15.Which of the following describes an IBM Informix Dynamic Server distributed database environment? (Select three answers.)
A.Databases can span across database servers located on the same machine.
B.Databases can span across database servers located on different machine.
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.
Correct:C D E
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 large objects and utilitze disk space most efficiently?
A.Create a normal dbspace to store the large objects.
B.Create a blobspace with a 2KB blobpage size to store the large objects.
C.Create a blobspace with an 8KB blobpage size to store the large objects.
D.Create a blobspace with a 16KB blobpage size to store the large objects.
Correct:A
17.Which of the following onstat commands lists 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
Correct:B
18.Which of the following oncheck options will give a detailed smart blob space disk utilization report?
A.oncheck-pS
B.oncheck-pB
C.oncheck-pP
D.oncheck-pT
Correct:A
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 of 100,000 kilobytes to the 'datadbs1' dbspace?
A.onspaces -a datadbs1 -p /dev/rawdev1 -o 0 -s 100000
B.onspaces -c datadbs1 -p /dev/rawdev1 -o 0 -s 100000
C.onspaces -c datadbs1 -p /dev/rawdev1 -Co 10 -Cs 100000
D.onspaces -a datadbs1 -p /dev/rawdev1 -o 10 -s 100000
Correct:D
20.A dbspace is almost full and more space is needed. When adding a new chunk to the dbspce, which of the following must be considered when specifying the size of the new chunk?
A.The size of the chunk should be considered but is can be changed after it is created.
B.Choose the chunk size carefully because its size cannot be changed once it is created.
C.For better performance, it is better to add a lot of small chunks than one very large chunk.
D.As a rule of thumb, the size of the new chunk should be twice the size of the previous chunk.
E.The size of the new chunk should not exceed the total size of all chunks currently allocated to the dbspace.
Correct:B
21.Given the following "onstat-d" output: dbspaces number fchunk nchunks flags name 7 7 2 ND dat1dbs Which one of the following states the current status of the dat1dbs dbspace?
A.The dbspace is mirrored and down.
B.The dbspace is not mirrored and down.
C.The dbspace is not mirrored and online.
D.The dbspace is mirrored but out of space.
Correct:B
22.Which of the following type of dbspces should be created to more efficiently handle large numbers of sort operations?
A.Sbspace
B.Root dbspace
C.Temporary dbspace
D.Logical-log dbspace
Correct:C
23.An unmirrored dbspace consists of two chunks. What information about these chunks must be known in order to issue the onspaces command to establish mirroring?
A.Pathname and size of the first chunk of the dbspace.
B.Pathname and offset of the first chunk of the dbspace
C.Pathnames and sizes of both of the chunks in the dbspace.
D.Pathnames and offsets of both of the chunks in the dbspace.
Correct:D
24.Which of the following describes the ownership, group, and permissions that must be assigned to a device before the database server can use it as a chunk?
A.Owner: root; group: Informix; permissions: 660
B.Owner: root; group: Informix; permissions: 777
C.Owner: Informix; group: Informix; permissions: 664
D.Owner: Informix; group: Informix; permissions: 660
Correct:D
25.Users will be doing mostly small, quick inserts on their OLTP system. For optimal performance, which of the following values should the BUFFERS configuration parameter be set to?
A.10 pages
B.90% of SHMVIRTSIZE
C.As large as possible.
D.As small as possible.
Correct:C
26.A database has stored procedures that retrieve data from user tables. Which of the following is the best "update statistics" strategy to ensure the best performance?
A.Run "update statistics" on tables first, then run "update statistics" for stored procedures
B.Run "update statistics" for stored procedures first; then run "update statistics" on tables
C.Run "update statistics" on both tables and stored procedures; the sequence is not important.
D.Run "update statistics" on tables only; "update statistics" for stored procedures is not necessary.
Correct:A
27.A database server is experiencing long checkpoint durations. The 'onstat-F' command shows a large number of chunk writes. Which of the following configuration parameters changes will typically solve the problem?
A.Decrease the value of LRU_MAX_DIRTY and LRU_MIN_DIRTY
B.Increase the value of LRU_MAX_DIRTY and LRU_MIN_DIRTY
C.Increase the value of LRU_MAX_DIRTY and decrease the value of LRU_MIN_DIRTY
D.Decrease the value of LRU_MAX_DIRTY and increase the value of LRU_MIN_DIRTY
Correct:A
28.A database server has performance problems related to insufficient buffers. In addition, frequent memory swapping is observed at the operating system level. Which of the following should be increased FIRST to solve this performance problem?
A.The amount of virtual memory.
B.The amount of physical memory.
C.The amount of temporary dbsapce.
D.The number of database buffers.
Correct:B
29.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.Only one CPU VP was configed
B.All chunks are created on raw devices.
C.The KAIOON environment variable is on.
D.All chunks are created using cooked files.
Correct:D
30.Disk I/O is unbalanced across dbspaces causing a performance problem. Which of the following should be identified to help solve this problem?
A.The number of buffers used.
B.The size of the physical log.
C.High-use versus low-use tables.
D.The number of logical logs used.
Correct:C
A.Informix Release Notes.
B.Informix reference manuals.
C.Operating System documentation.
D.Administrator's Guide for IBM Informix Dynmaic Server.
Correct:A
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 compiled for external Java routines.
Correct:B
3.Which of the following shell commands will start the database server and initialize rootdbs?
A.oninit
B.ipcs-m
C.onmode-i
D.onstat-i
E.oninit-ivy
Correct:E
4.The System Administrator needs to run applications on the same host 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.onipcshm
B.onipcstr
C.ontlitcp
D.onsoctcp
Correct:A
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
Correct:C
6.The System Administrator has chosen to create an sqlhosts file in a directory that is not the default that 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 SQL HOSTS environment variable to the path and name of the sqlhosts 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.
Correct:C
7.To successfully install the IBM Informix Dynamic Server product, which of the following environment variables must be set?
A.INFORMIXDIR, PATH
B.INFORMIXDIR, INFORMIXSQLHOSTS
C.INFORMIXDIR, INFORMIXSERVER, PATH
D.INFORMIXDIR, INFORMIXSERVER, ONCONFIG
Correct:A
8.Where must the database server configuration file reside?
A./etc
B.$ONCONFIG
C.$INFORMIXDIR/etc
D.$INFORMIXDIR/config
Correct:A
9.The System Administrator wants to change the root chunk size for a newly created instance, however no databases 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.
Correct:C
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.soctop, 50,2,CPU
B.soctcp,2,50,NET
C.ipcshm,2,50 NET
D.soctcp,2,100,NET
Correct:B
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 be specified in the sqlhosts file?
A.ontlitcp
B.ontlispx
C.onsocspx
D.onsoctcp
Correct:A
12.Files need to be configured to establish network connections on a UNIX host 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 texas1
C.texas1 192.168.15.100
D.texas1 192.168.15.100 usa
Correct:B
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
Correct:D
14.A company 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
Correct:A
15.Which of the following describes an IBM Informix Dynamic Server distributed database environment? (Select three answers.)
A.Databases can span across database servers located on the same machine.
B.Databases can span across database servers located on different machine.
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.
Correct:C D E
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 large objects and utilitze disk space most efficiently?
A.Create a normal dbspace to store the large objects.
B.Create a blobspace with a 2KB blobpage size to store the large objects.
C.Create a blobspace with an 8KB blobpage size to store the large objects.
D.Create a blobspace with a 16KB blobpage size to store the large objects.
Correct:A
17.Which of the following onstat commands lists 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
Correct:B
18.Which of the following oncheck options will give a detailed smart blob space disk utilization report?
A.oncheck-pS
B.oncheck-pB
C.oncheck-pP
D.oncheck-pT
Correct:A
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 of 100,000 kilobytes to the 'datadbs1' dbspace?
A.onspaces -a datadbs1 -p /dev/rawdev1 -o 0 -s 100000
B.onspaces -c datadbs1 -p /dev/rawdev1 -o 0 -s 100000
C.onspaces -c datadbs1 -p /dev/rawdev1 -Co 10 -Cs 100000
D.onspaces -a datadbs1 -p /dev/rawdev1 -o 10 -s 100000
Correct:D
20.A dbspace is almost full and more space is needed. When adding a new chunk to the dbspce, which of the following must be considered when specifying the size of the new chunk?
A.The size of the chunk should be considered but is can be changed after it is created.
B.Choose the chunk size carefully because its size cannot be changed once it is created.
C.For better performance, it is better to add a lot of small chunks than one very large chunk.
D.As a rule of thumb, the size of the new chunk should be twice the size of the previous chunk.
E.The size of the new chunk should not exceed the total size of all chunks currently allocated to the dbspace.
Correct:B
21.Given the following "onstat-d" output: dbspaces number fchunk nchunks flags name 7 7 2 ND dat1dbs Which one of the following states the current status of the dat1dbs dbspace?
A.The dbspace is mirrored and down.
B.The dbspace is not mirrored and down.
C.The dbspace is not mirrored and online.
D.The dbspace is mirrored but out of space.
Correct:B
22.Which of the following type of dbspces should be created to more efficiently handle large numbers of sort operations?
A.Sbspace
B.Root dbspace
C.Temporary dbspace
D.Logical-log dbspace
Correct:C
23.An unmirrored dbspace consists of two chunks. What information about these chunks must be known in order to issue the onspaces command to establish mirroring?
A.Pathname and size of the first chunk of the dbspace.
B.Pathname and offset of the first chunk of the dbspace
C.Pathnames and sizes of both of the chunks in the dbspace.
D.Pathnames and offsets of both of the chunks in the dbspace.
Correct:D
24.Which of the following describes the ownership, group, and permissions that must be assigned to a device before the database server can use it as a chunk?
A.Owner: root; group: Informix; permissions: 660
B.Owner: root; group: Informix; permissions: 777
C.Owner: Informix; group: Informix; permissions: 664
D.Owner: Informix; group: Informix; permissions: 660
Correct:D
25.Users will be doing mostly small, quick inserts on their OLTP system. For optimal performance, which of the following values should the BUFFERS configuration parameter be set to?
A.10 pages
B.90% of SHMVIRTSIZE
C.As large as possible.
D.As small as possible.
Correct:C
26.A database has stored procedures that retrieve data from user tables. Which of the following is the best "update statistics" strategy to ensure the best performance?
A.Run "update statistics" on tables first, then run "update statistics" for stored procedures
B.Run "update statistics" for stored procedures first; then run "update statistics" on tables
C.Run "update statistics" on both tables and stored procedures; the sequence is not important.
D.Run "update statistics" on tables only; "update statistics" for stored procedures is not necessary.
Correct:A
27.A database server is experiencing long checkpoint durations. The 'onstat-F' command shows a large number of chunk writes. Which of the following configuration parameters changes will typically solve the problem?
A.Decrease the value of LRU_MAX_DIRTY and LRU_MIN_DIRTY
B.Increase the value of LRU_MAX_DIRTY and LRU_MIN_DIRTY
C.Increase the value of LRU_MAX_DIRTY and decrease the value of LRU_MIN_DIRTY
D.Decrease the value of LRU_MAX_DIRTY and increase the value of LRU_MIN_DIRTY
Correct:A
28.A database server has performance problems related to insufficient buffers. In addition, frequent memory swapping is observed at the operating system level. Which of the following should be increased FIRST to solve this performance problem?
A.The amount of virtual memory.
B.The amount of physical memory.
C.The amount of temporary dbsapce.
D.The number of database buffers.
Correct:B
29.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.Only one CPU VP was configed
B.All chunks are created on raw devices.
C.The KAIOON environment variable is on.
D.All chunks are created using cooked files.
Correct:D
30.Disk I/O is unbalanced across dbspaces causing a performance problem. Which of the following should be identified to help solve this problem?
A.The number of buffers used.
B.The size of the physical log.
C.High-use versus low-use tables.
D.The number of logical logs used.
Correct:C
