000-915 Exam

Quality and Value for the 000-915 Exam

Test4pass Practice Exams for IBM 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 000-915 Exam

If you prepare for the exam using our Test4pass testing engine, we guarantee your success in the first attempt. If you do not pass the Solutions Expert 000-915 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

IBM 000-915 Downloadable, Printable Exams (in PDF format)

Our Exam 000-915 Preparation Material provides you everything you will need to take your 000-915 Exam. The 000-915 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

000-915 Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our IBM 000-915 Exam will provide you with free 000-915 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 000-915 Exam:100% Guarantee to Pass Your Solutions Expert exam and get your Solutions Expert Certification.

Hot KeyWords On 000-915 test

We collect some hot keywords about this exam:
Test4pass , Pass 4 Sure , Test in Side ,Pass Guide ,Test King 000-915 exam | 000-915 pdf exam | 000-915 braindumps | 000-915 study guides | 000-915 trainning materials | 000-915 simulations | 000-915 testing engine | 000-915 vce | 000-915 torrent | 000-915 dumps | free download 000-915 | 000-915 practice exam | 000-915 preparation files | 000-915 questions | 000-915 answers.

How to pass your 000-915 exam

You can search on Search Engine and Find Best IT Certification site: Test4pass.com - Find the Method to succeed 000-915 test,The safer.easier way to get Solutions Expert Certification .

��
��
Exam : IBM 000-915
Title : System Administration for Infromix Dynamic Server V9


1. Which of the following is a performance benchmark for a data warehousing environment?
A. Write cache rate
B. Checkpoint durations
C. Number of lock overflows
D. Response time of complex queries
Answer: D

2. A non-critical dbspace has been taken offline due to a disk failure. This dbspace contained 10% of the production data. A level-o archive and logical log backups are available for a restore of the database server, which normally takes up to ten hours.
Which of the following is the best solution to restore the database server?
A. Do a cold restore and apply the logical logs
B. Do a warm restore and apply the logical logs
C. Do a warm restore without applying the logical logs
D. Do a cold restore without applying the logical logs.
Answer: B

3. Given a partnum of 0x300034 for a table, which table in the sysmaster database could be queried to determine that actual table name?
A. systables
B. sysptnhdr
C. systabnames
D. sysdatabases
Answer: C

4. An Informix System Administrator needs to know how many pool threads are running on a CPU VP. Which of the following commands can be used to do this task?
A. onstat -g ath
B. onstat -g dsc
C. onstat -g glo
D. onstat -g sts
Answer: A

5. The following is extracted from the output of an onstat -k command.
From the above excerpt, how many exclusive locks are present in the engine?
A. 0
B. 1
C. 4
D. 6
Answer: C

6. 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

7. Which of the following sysmaster tables contains similar information as the output from the onheck - pe command?
A. syserrors
B. syschunks
C. sysptprof
D. sysextents
Answer: D

8. Users are reporting slow response time. It appears that it may be related to cpu utilization. Which of the following commands would show a list of virtual processors and their statistics?
A. onstat -g ath
B. onstat - g glo
C. onstat -g st
D. onstat -g act
E. onstat -g ssc all
Answer: B

9. The database server configuration file contains the following parameter settings.
According to the message log, checkpoints are occurring every 10 to 15 seconds. Checkpoint duration is less than one second.
Which of the following changes will most likely cause checkpoints to occur less frequently?
A. Decrease BUFFERS
B. Increase PHYSFILE
C. Increase CKPTINTVL
D. Decrease LRU_MIN_DIRTY and LRU_MAX_DIRTY
E. Increase LRU_MIN_DIRTY and LRU_MAX_DIRTY
Answer: B

10. The database server os offline. There is a concern about chunk paths and their allocation. Which of the following commands would show the path for each chunk?
A. oncheck -pr
B. oncheck -pt
C. oncheck -pp
D. onheck -Cdi
Answer: A

11. Given the following information.
Which of the following best describes what the output represents?
A. The database server was started for the first time and performed normal fast-recovery tasks.
B. The database server was restarted after a normal shutdown and performed normal fast-recovery tasks
C. The database server was restarted after an abnormal shutdown and performed normal fast-recovery tasks.
D. The database server was restarted after restoring dbspaces from an archive and a post-archive fast recovery was performed.
Answer: C

12. The System Administrator needs to know when the latest "update statistics medium" has been run. Which of the following tables will most likely contain this information?
A. systables
B. sysdistrib
C. sysindexes
D. syscolumns
Answer: B

13. The database server has marked several chunks as "down" in a non-critical dbspac, but the database server is still online. Which of the following methods ould restore the data while providing the least amount of downtime to the users of that dbspace?
A. A whole system restore
B. A warm restore of the dbspace
C. A cold restore of the dbspace
D. A warm restore of the whole system
Answer: B

14. A system 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