Certinside 000-704 Exam

Quality and Value for the 000-704 Exam

CertInside Practice Exams for IBM 000-704 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

Guarantee to Pass Your 000-704 Exam

If you prepare for the exam using our CertInside testing engine, we guarantee your success in the first attempt. If you do not pass the DB2 000-704 exam (db2 udb v8.1 advanced db admin for linux,unix+windwos) on your first attempt we will give you a Free update of your purchasing fee.

IBM 000-704 Exams (in EXE format)

Our Exam 000-704 Preparation Material provides you everything you will need to take your 000-704 Exam. The 000-704 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-704 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 the certification exams, our Practice Tests are in multiple-choice (MCQs) Our IBM 000-704 Exam will provide you with free 000-704 exam questions with verified answers that reflect the exam. These questions and answers provide you with the experience of taking the test. High quality and Value for the 000-704 Exam:100% Guarantee to Pass Your DB2 exam and get your DB2 Certification.

http://www.CertInside.com The safer.easier way to get DB2 Certification.
　
　
Exam : IBM 000-704
Title : DB2 Udb V8.1 Advanced DB Admin for Linux,Unix+Windwos


1. Which two of the following can be done to a buffer pool using the ALTER BUFFERPOOL statement?
A. Reduce the size.
B. Change the page size.
C. Modify the extent size.
D. Modify the prefetch size.
E. Immediately increase the size.
Answer: AE

2. A table is defined using DMS table spaces with its index, data, and long data separated into different table spaces. The table space containing the table data is restored from a backup image.
Which of the table's other table spaces must also be restored in order to roll forward to a point in time prior to the end of the logs?
A. Long table space
B. Index table space
C. Temporary table space
D. Index and long table spaces
Answer: D

3. In a federated system, a userid is used for the CREATE SERVER definition at the DB2 data source.
Which of the following privileges should it have?
A. SELECT on the catalog at the DB2 data source
B. UPDATE on the CREATE SERVER definition table
C. SELECT on the tables for which nicknames are created
D. INSERT on the tables for which nicknames are created
Answer: A

4. Which of the following can enable multiple prefetchers for table spaces with a single container?
A. NUM_IOSERVERS
B. INTRA_PARALLEL
C. DB2_PARALLEL_IO
D. DB2_STRIPED_CONTAINERS
Answer: C

5. Given a single physical server with a single OS image utilizing 24 CPUs and configured with 12 database partitions, how many of the database partitions can act as coordinator partitions for remote applications?
A. 1
B. 2
C. 12
D. 24
Answer: C