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
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.ipcsm C.onmodei D.onstati E.oninitivy 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.onstatd B.onstatD C.onstatp
D.onstatP
Correct:B
18.Which of the following oncheck options will give a detailed smart blob space disk utilization report?
A.oncheckpS B.oncheckpB C.oncheckpP D.oncheckpT 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 “onstatd” 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.Logicallog 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 ‘onstatF’ 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.Highuse versus lowuse tables.
D.The number of logical logs used.
Correct:C
Testking ibm 000-915 Interactive Testing Engine Included!
166 Questions
Updated : 09/18/2008
Price : $87.99 $79.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.
[...] testking 000-915 [...]