Home > IBM > IBM certifications II > 000-734

000-734 Exam

DB2 9 Advanced DB Administrator for Linux,UNIX,and Windows

Exam Number/Code : 000-734
Exam Name : DB2 9 Advanced DB Administrator for Linux,UNIX,and Windows
Questions and Answers : 102 Q&As
Update Time: 2013-04-05
Price: ~~$ 119.00~~ $ 69.00
000-734 Hard Copy (PDF)
000-734 Test Engine

000-734

Free 000-734 Demo Download

Test4pass offers free demo for IBM certifications II 000-734 exam (DB2 9 Advanced DB Administrator for Linux,UNIX,and Windows). 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-734 exam test is the hot exam of IBM certification. Test4pass offer you all the Q&A of the 000-734 real test . It is the examination of the perfect combination and it will help you pass 000-734 exam at the first time!

Why choose Test4pass 000-734 braindumps

Quality and Value for the 000-734 Exam
100% Guarantee to Pass Your 000-734 Exam
Downloadable, Interactive 000-734 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.

Test4pass 000-734 Exam Features

Quality and Value for the 000-734 Exam

Test4pass Practice Exams for IBM 000-734 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-734 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 IBM certifications II 000-734 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-734 Downloadable, Printable Exams (in PDF format)

Our Exam 000-734 Preparation Material provides you everything you will need to take your 000-734 Exam. The 000-734 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-734 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-734 Exam will provide you with free 000-734 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-734 Exam:100% Guarantee to Pass Your IBM certifications II exam and get your IBM certifications II Certification.

Hot KeyWords On 000-734 test

How to pass your 000-734 exam

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

��
��
Exam : IBM 000-734
Title : DB2 9 Advanced DB Administrator for Linux, UNIX, and Windows

1. A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)?
A. one server having at least two processors
B. two servers having one processor and one logical database partition
C. one server having four processors and two logical database partitions
D. two servers each having four processors and two logical database partitions
Answer: C

2. A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?
A. db2advis -d proddb -i workload.sql -P
B. db2advis -d proddb -i workload.sql -partitioning
C. db2advis -d proddb -i workload.sql -m P
D. db2advis -d proddb -i workload.sql -m ALL
Answer: C

3. Which statement is true about clustering indexes in a DPF environment?
A. The partitioning key columns should be added to all indexes with the INCLUDE option.
B. It is not possible to have a clustering index in a DPF environment.
C. The index columns should be prefixed by the partitioning key columns.
D. The partitioning key columns should be added immediately after the column in the index with the highest cardinality.
Answer: C

4. Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful? (Choose two.)
A. INTRA_PARALLEL NO
B. MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100
C. MAX_AGENTS 100, MAX_CONNECTIONS 2000
D. MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000
E. INTRA_PARALLEL YES
Answer: BE

5. Which server houses the database partitions in the AIX BCU V2.1?
A. IBM System p5 570
B. IBM System p5 575
C. IBM System p5 590
D. IBM System p5 595
Answer: B

6. If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?
A. All sorts will be done in a temporary table space.
B. The shared sort memory allocation will be calculated by DB2.
C. No shared memory is allocated for sorting.
D. All sorts will be done in shared memory.
Answer: D

7. Which data organization schemes are supported?
A. PARTITION BY HASH and ORGANIZE BY
B. PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE
C. PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE
D. PARTITION BY RANGE and ORGANIZE BY
Answer: D

8. If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance, which statement is correct?
A. All existing databases in the instance are expanded to the new database partition but data cannot be stored on the new partition until it has been added to a partition group.
B. Database partition groups within existing databases will automatically include the new database partition and will redistribute their existing data to the new partition.
C. Any single partition databases within the instance will automatically become multi-partition databases once the new partition is added to the instance.
D. A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition to the instance.
Answer: A

9. When a database administrator chooses the dimensions for an MDC table, which two characteristics should be considered? (Choose two.)
A. the query transaction rate
B. numeric data versus character data
C. extent size
D. the cardinality of the candidate columns
E. prefetch size
Answer: CD

10. In which two environments would intra-partition parallelism be used? (Choose two.)
A. Single database partition, single processor
B. Single database partition, multiple processors
C. Multiple database partitions, single processor
D. Multiple database partitions, multiple processors
Answer: BD

11. A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start on time. What is one way to help the application complete quickly?
A. Code the application to issue a LOCK TABLE statement.
B. Code the application to issue a LOCK ROW statement.
C. Decrease the number of I/O servers.
D. Increase the locklist parameter.
Answer: A

12. A database administrator needs to update a table named TRANSACT by removing February 2005 data and replacing it with February 2007 data. What are the proper steps, in the correct order, required to accomplish this?
A. 1) ALTER TABLE transact DETACH PARTITION feb05 INTO newtable
2) LOAD FROM transact.del OF DEL REPLACE INTO newtable
3) ALTER TABLE transact ATTACH PARTITION feb07 STARTING '02/01/2007' ENDING '02/28/2007' FROM new table
4) SET INTEGRITY FOR transact
B. 1) ALTER TABLE transact DETACH PARTITION feb05 INTO newtable
2) LOAD FROM transact.del OF DEL REPLACE INTO newtable
3) ALTER TABLE transact ATTACH PARTITION feb07 STARTING '01/01/2007' ENDING '02/28/2007' FROM new table
4) SET INTEGRITY FOR transact
C. 1) ALTER TABLE transact DETACH PARTITION feb05 INTO newtable
2) LOAD FROM transact.del OF DEL REPLACE INTO newtable
3) ALTER TABLE transact ATTACH PARTITION feb07 STARTING '02/01/2007' ENDING '02/28/2007' FROM new table
4) RUNSTATS ON TABLE transact
D. 1) ALTER TABLE transact DETACH PARTITION feb05 INTO newtable
2) LOAD FROM transact.del OF DEL REPLACE INTO newtable
3) ALTER TABLE transact ATTACH PARTITION feb07 STARTING '02/01/2007' ENDING '02/28/2007' FROM new table
4) REORG TABLE transact
Answer: A

13. A database administrator needs to create a table with key columns C1 (i.e. YearDay), C2, and C This table needs to be partitioned by column C1 with three months per data partition. Additionally, data needs to be organized by columns C2 and C3, so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this objective?
A. CREATE TABLE tab1
(c1 INT,
c2 CHAR(2),
c3 INT,
c4 CHAR(2))
PARTITION BY RANGE (c2) (STARTING 200601 ENDING 200612 EVERY 3)
ORGANIZE BY DIMENSIONS (c2, c3))
B. CREATE TABLE tab1
(c1 INT,
c2 CHAR(2),
c3 INT,
c4 CHAR(2))
PARTITION BY RANGE (c1) (STARTING 200601 ENDING 200612 EVERY 3)
ORGANIZE BY DIMENSIONS (c2, c3))
C. CREATE TABLE tab1
(c1 INT,
c2 CHAR(2),
c3 INT,
c4 CHAR(2))
PARTITION BY RANGE (c1) (STARTING 200601 ENDING 200612 EVERY 3)
ORGANIZE BY DIMENSIONS (c2))
D. CREATE TABLE tab1
(c1 INT,
c2 CHAR(2),
c3 INT,
c4 CHAR(2))
PARTITION BY RANGE (c1) (STARTING 200601 ENDING 200612 EVERY 3)
ORGANIZE BY DIMENSIONS (c3))
Answer: B

14. Which procedure will successfully configure the memory areas within a database, including buffer pools, to use the Self Tuning Memory Manager (STMM)?
A. 1) Set the SELF_TUNING_MEM database configuration parameter to ON.
2) Set the relevant configuration parameters within the database configuration file to AUTOMATIC.
3) Use the ALTER BUFFERPOOL command to change the size of all buffer pools to AUTOMATIC.
B. 1) Set the SELF_TUNING_MEM database configuration parameter to ON.
2) Use the ALTER BUFFERPOOL command to change the size of all buffer pools to AUTOMATIC.
C. 1) Set the SELF_TUNING_MEM database configuration parameter to ON.
Answer: A