High quality and Value for the 000-917 Exam
Exam Number/Code: 000-917
Exam Name: System Administration for IBM Informix Dynamic Server V10
Questions and Answers: 146 Q&A
Duration: 90 Minutes (50-70 questions)
Available Languages: English
Test Register: Pearson VUE or Prometric
VisualExams Practice Exams for 000-917 are written to the highest standards of technical accuracy, provided by our certified subject matter experts and published authors for development.

100% Guarantee to Pass Your Implemenation exam and get your Implemenation Certification.
We guarantee your success in the first attempt. If you do not pass the Implemenation "000-917" (System Administration for IBM Informix Dynamic Server V10) on your first attempt, send us the official result. We will give you a FULLY REFUND of your purchasing fee OR send you another same value product for free.

Free IBM 000-917 study guide
　
　
Exam : IBM 000-917
Title : System Administration for IBM Informix Dynamic Server V10

1. A database server has been running for days but after monthly reports were run, the following message appeared in the online.log:
12:25:01 Memory allocation error
Which of the following most likely caused the error?
A. The DS_TOTAL_MEMORY has been reached.
B. The swap space on the computer has been set too high.
C. An operating system limit on shared memory has been reached.
D. The BUFFERS and SHMVIRTSIZE configuration parameters are larger than the maximum segment size allowed.
Answer: C

2. 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 utilize 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.
Answer: A

3. A Database Administrator is configuring the files to establish network connections on a UNIX system, which uses a sockets interface and a TCP/IP protocol.
The DBSERVERNAME configuration parameter has been set to ‘dbserver1′ and the name of the UNIX host machine is ‘chicago1′. The service name used is ’sqlexec’.
Which of the following entries in the sqlhosts file should be used?
A. chicago1 sqlexec dbserver1 onsoctcp
B. chicago1 onsoctcp dbserver1 sqlexec
C. dbserver1 onsoctcp sqlexec chicago1
D. dbserver1 onsoctcp chicago1 sqlexec
Answer: D

4. Which of the following best describes external backups on the IBM Informix Dynamic Server?
A. An external backup allows backups using onbar or ontape; database transactions are active 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 operating system or third-party utilities; transactions are active during external backups.
D. An external backup allows backups using operating system or third-party utilities; transactions are suspended during external backups.
Answer: D

5. A Database Administrator needs to know the physical location of a table. Which of the following commands would show this information?
A. oncheck -pe
B. oncheck -pr
C. oncheck -pR
D. oncheck -pp
Answer: A

6. A dbspace was recently added to a database server. Which of the following commands will help identify whether disk layout problems exist as a result of adding the dbspace?
A. onstat -g iob
B. onstat -g iov
C. onstat -g iof
D. onstat -g glo
Answer: C

7. Given the following information collected by the ‘onstat -d’ command:
What type of dbspace is the ‘temp_space2′ dbspace?
A. Blob dbspace
B. Normal dbspace
C. Mirrored dbspace
D. Temporary dbspace
Answer: B

8. To specify which configuration file to use, the ONCONFIG environment variable must be set to the:
A. name of the configuration file to use.
B. path of the configuration file to use.
C. path and name of the configuration file to use.
D. $INFORMIXDIR/etc directory where the configuration file will be located.
Answer: A

9. The following error message appears in the database server message log:
09:28:43 Aborting Long Transaction: tx 0xa43c728 username: sallyr uid: 200
This transaction has rolled back. Which of the following best describes the situation in the error message?
A. A transaction has spanned multiple logical-log files and has caused the logical-log files to fill to 100% full.
B. A transaction has caused the physical-log file to fill to the percentage indicated by the LTXHWM configuration parameter.
C. A transaction has caused a single logical-log file to fill to the percentage indicated by the LTXHWM configuration parameter.
D. A transaction starting in the oldest log is open, and the percentage of logical-log files filled has passed the LTXHWM configuration parameter.
Answer: D

10. Querying the sysmaster database table sysdatabases returns a row with a value of 1 for is_logging and a value of 0 for is_buff_log and is_ansi; What is the current log status of the database?
A. ANSI
B. Not logged
C. Buffered logging
D. Unbuffered logging
Answer: D

11. A database server is experiencing slow query response times. Operating system utilities show that all 6 CPUs are at around 50% utilization. There are currently 4 CPU VPs configured on the database server. Of the following, which is the most probable change that could be made to correct this problem?
A. Add more AIO VPs.
B. Add more CPU VPs.
C. Turn on Processor Affinity.
D. Add more physical processors to the machine.
Answer: B

12. Following are outputs of ‘onstat -k’ and ‘onstat -u’ command:
Users are reporting that they cannot access a table because they are getting errors indicating that the table is locked. The Lock address ‘a155380′ is holding a lock on the table. What is the session id for lock address ‘a155380′?
A. 34
B. 36
C. 38
D. 40
Answer: D

Where can you buy the 000-917 exam online?
We recommend TestInside 000-917 braindumps Testing Engine which will help you pass the 000-917 exam.

Free Download pdf for TestInside 000-917 pdf download:

VisualExams Implemenation 000-917 Exam Downloadable.
Printable Exams (in PDF format) Our Exam Implemenation 000-917 Preparation Material provides you everything you will need to pass your Implemenation exam. The Implemenation Certification details are researched and produced by our Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get "000-917 exam" questions from different websites or books, but logic is the key. Our Product will help you not only pass in the first System Administration for IBM Informix Dynamic Server V10 exam try, but also save your valuable time.

1. Comprehensive questions with complete details about 000-917 exam.
2. 000-917 exam questions accompanied by exhibits. Verified Answers Researched by Industry Experts and almost 100% correct.
3. Drag and Drop questions as experienced in the Real Implemenation exam. 000-917 exam questions updated on regular basis.

IBM 000-917 Search Help:
Feel free to use search terms below while searching the Network for 000-917 exam:
Cisco 000-917 free certification exams
Cisco 000-917 exam paper
Cisco 000-917 study exams
Cisco 000-917 exam study guide
Cisco 000-917 exams rapidshare
Cisco 000-917 exams certification guide
Cisco 000-917 exams free

Best 000-917 Practice Exams Collection:
TestInside 000-917
CertInside 000-917
Pass4Side 000-917
Pass4sure 000-917
Testking 000-917
Examsoon 000-917
PassQuick 000-917
Actualtest 000-917
VisualExams 000-917 test http://www.VisualExams.com/000-917.htm