Exam Code : 000-704
Exam Name : DB2
Questions and Answers : 114 Q&As

Questions and Answers : 114 Q&As
The 000-704 Questions & Answers cover the latest real test and with all the correct answer.we promise the Q&A for IBM 000-704
DB2 Certification
of original title complete coverage.000-704 Questions & Answers help you pass the exam.

It is well known that 000-704 dumps test is the hot exam of IBM certification . examsoon offer you all the Q&As 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!

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

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

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

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

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

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

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

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

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

Free examsoon 000-704 Pdf and Practice Engine Questions and Answers Download

Free Download 000-704 Exams

examsoon Practice Exams for IBM Certification 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 000-704 Exam