Home > IBM > DB2 > 000-704

000-704 Exam

db2 udb v8.1 advanced db admin for linux,unix+windwos

Exam Number/Code : 000-704
Exam Name : db2 udb v8.1 advanced db admin for linux,unix+windwos
Questions and Answers : 114 Q&As
Update Time: 2011-09-21
Price: ~~$ 119.00~~ $ 69.00

000-704

Free 000-704 Demo Download

Test4pass offers free demo for DB2 000-704 exam (db2 udb v8.1 advanced db admin for linux,unix+windwos). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.

Exam Description

It is well known that 000-704 exam test is the hot exam of IBM certification. Test4pass offer you all the Q&A of the 000-704 real test . It is the examination of the perfect combination and it will help you pass 000-704 exam at the first time!

Why choose Test4pass 000-704 braindumps

Quality and Value for the 000-704 Exam
100% Guarantee to Pass Your 000-704 Exam
Downloadable, Interactive 000-704 Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.

IBM DB2 000-704 exam braindumps questions and answers

��
��
Exam : IBM 000-704
Title : DB2 Udb V8.1 Advanced DB Admin for Linux,Unix+Windwos

1. Which table space type is required to use a declared global temporary table?
A. USER TEMPORARY
B. GLOBAL TEMPORARY
C. SYSTEM TEMPORARY
D. DECLARED TEMPORARY
Answer: A

2. Use the following information for this question:
Assuming a temporary table is required by the SORT for this query, in which table space will the temporary table be created?
A. TBSPC4K
B. TBSPC8K
C. TBSPC16K
D. TBSPC32K
Answer: C

3. What option on the SQL statement ALTER TABLESPACE guarantees there will be no rebalance when adding a container to an existing table space?
A. ADD AT END
B. NO REBALANCE
C. EXTEND STRIPE SET
D. BEGIN NEW STRIPE SET
Answer: D

4. When creating a regular DMS table space, what is the minimum number of extents that must be specified?
A. 1
B. 3
C. 4
D. 6
E. 8
Answer: D

5. Which two (2) of the following are characteristics of System Managed Storage (SMS) and Database Managed Storage (DMS)?
A. SMS table spaces are always built on the file system.
B. DMS table spaces are always built on the file system.
C. SMS table spaces allow index and LOB storage in separate table spaces.
D. Only DMS table spaces allow the specification of OVERHEAD and TRANSFERRATE.
E. LOBs can only be cached in memory when they are stored in table spaces built on the file system.
Answer: AE

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

7. What option on the CREATE TABLESPACE statement determines on which database partition(s) the table space will be created?
A. ON NODES <nodelist>
B. IN DATABASE NODE GROUP <node group name>
C. IN PARTITION GROUP <partition group name>
D. IN DATABASE PARTITION GROUP <db partition group name>
Answer: D

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

9. Use the following information for this question:
Assuming a temporary table is required during the sort, what is the minimum page size for the table space where the temporary table will be created?
A. 4 KB
B. 8 KB
C. 16 KB
D. 32 KB
Answer: B

10. Which of the following SQL statements creates a table space that can contain LONG VARCHAR, LOB and INDEX data?
A. CREATE INDEX TABLESPACE DATA1 MANAGED BY DATABASE USING (FILE 'CONT1' 2000)
B. CREATE LARGE TABLESPACE DATA1 MANAGED BY DATABASE USING (FILE 'CONT1' 2000)
C. CREATE ANYTYPE TABLESPACE DATA1 MANAGED BY DATABASE USING (FILE 'CONT1' 2000)
D. CREATE ALLTYPE TABLESPACE DATA1 MANAGED BY DATABASE USING (FILE 'CONT1' 2000)
Answer: B

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

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

13. A table space contains a single table with a row size of 1000 bytes. What is the minimum page size for the table space in order for the table to contain 200 million rows?
A. 4 KB
B. 8 KB
C. 16 KB
D. 32 KB
Answer: C

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

Click Online chat to talk with us , get more informations about IBM DB2 000-704 practice exam study guides questions and answers

Test4pass 000-704 Exam Features

Quality and Value for the 000-704 Exam

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

100% Guarantee to Pass Your 000-704 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 DB2 000-704 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-704 Downloadable, Printable Exams (in PDF 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 actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our IBM 000-704 Exam will provide you with free 000-704 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-704 Exam:100% Guarantee to Pass Your DB2 exam and get your DB2 Certification.

Test4pass 000-704 exam
Test4pass 000-704 pdf exam
Test4pass 000-704 braindumps
Test4pass 000-704 study guides
Test4pass 000-704 trainning materials
Test4pass 000-704 simulations
Test4pass 000-704 testing engine
Test4pass 000-704 vce
Test4pass 000-704 torrent
Test4pass 000-704 dumps
free download 000-704
Test4pass 000-704 practice exam
Test4pass 000-704 preparation files
Test4pass 000-704 questions
Test4pass 000-704 answers

http://www.test4pass.com/000-704-exam.html The safer.easier way to get DB2 Certification .