IBM test 000-736 exam dumps Exam 000-736 DB2 9 Database Admin for Linux,UNIX,and Windows Upgrade 000-736 Testing Engine - Test4pass

000-736 Exam

DB2 9 Database Admin for Linux,UNIX,and Windows Upgrade

  • Exam Number/Code : 000-736
  • Exam Name : DB2 9 Database Admin for Linux,UNIX,and Windows Upgrade
  • Questions and Answers : 76 Q&As
  • Update Time: 2011-09-21
  • Price: $ 119.00 $ 69.00
checkout
000-736

Free 000-736 Demo Download

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

Why choose Test4pass 000-736 braindumps

Quality and Value for the 000-736 Exam
100% Guarantee to Pass Your 000-736 Exam
Downloadable, Interactive 000-736 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 IBM certifications II 000-736 exam braindumps questions and answers

¡¡
¡¡
Exam : IBM 000-736
Title : DB2 9 Database Admin for Linux, UNIX, and Windows Upgrade


1. Self tuning memory simplifies the task of memory configuration by automatically setting values for memory configuration parameters and sizing buffer pools. When enabled, the memory tuner dynamically distributes available memory resources between _____.
A. several buffer pools
B. several memory consumers including sort, package cache, lock list areas, and buffer pools
C. several memory consumers including sort, package cache, monitor heap, and lock list areas
D. several memory consumers including load and buffer pools
Answer: B

2. Given the following server information:
Instance name: db2inst1
Port number: 50000
Service name: db2c_db2inst1
Hostname: 1080:0:0:0:8:800:200C:417A
Database: db2tcp
Which command will catalog a node for this server?
A. CATALOG TCPIP6 NODE db2tcp 1080:0:0:0:8:800:200C:417A SERVER 50000
B. CATALOG TCPIP6 NODE db2tcp REMOTE 1080:0:0:0:8:800:200C:417A SERVER 50000
C. CATALOG TCPIP4 NODE db2tcp 1080:0:0:0:8:800:200C:417A SERVER 50000
D. CATALOG TCPIP4 NODE db2tcp REMOTE 1080:0:0:0:8:800:200C:417A SERVER 50000
Answer: B

3. Which explanation describing the AUTOCONFIGURE command is valid?
A. The AUTOCONFIGURE command will only make recommendations based on the assumption of a single database per instance.
B. When explicitly invoking the Configuration Advisor using the AUTOCONFIGURE command, the registry setting of DB2_ENABLE_AUTOCONFIG_DEFAULT will be honored; this variable must be set to ON in order for the AUTOCONFIGURE command to be run successfully.
C. The AUTOCONFIGURE command does not require an explicit database connection.
D. When using the BUFFERPOOL keyword and a value of 50, AUTOCONFIGURE will tell DB2 to use 50% of the database shared memory for the buffer pools.
Answer: A

4. Which three tasks should be performed to enable self tuning memory for all conditions? (Choose three.)
A. Set the Database Configuration parameter SELF_TUNING_MEM to ON.
B. Set the relevant Database Configuration parameters to AUTOMATIC.
C. Set the DB2 registry variable SELF_TUNING_MEM to YES.
D. Set the Database Manager Configuration parameter SELF_TUNING_MEM to ON.
E. Set all buffer pool sizes to AUTOMATIC.
Answer: ABE

5. Which commands will set the throttling percentage for a running backup operation that has a Utility ID of 2 for a database named DBTEST in an instance named DB2INST1 to 10 percent?
A. db2set UTIL_IMPACT_LIMIT=ON;
SET UTIL_IMPACT_PRIORITY FOR 2 TO 10;
B. UPDATE DB CFG FOR dbtest USING UTIL_IMPACT_LIM ON;
SET UTIL_IMPACT_LIM FOR 2 TO 10;
C. UPDATE DBM CFG USING UTIL_IMPACT_PRIORITY ON;
SET UTIL_IMPACT_LIMIT FOR 2 TO 10;
D. UPDATE DBM CFG USING UTIL_IMPACT_LIM ON;
SET UTIL_IMPACT_PRIORITY FOR 2 TO 10;
Answer: D

6. Click the Exhibit button.
Table CUSTOMER has an XML column named CUSTINFO which contains XML document values shown in the exhibit.
Which statement will define an XML index that can be used by queries that return customer records with a specific ZIP/postal code?
A. CREATE INDEX custindex ON customer(custinfo)
GENERATE KEY USING XPATH '/customerinfo/addr/@zip-pcode'
AS SQL DOUBLE
B. CREATE INDEX custindex ON customer(custinfo)
GENERATE KEY USING XMLPATTERN '/customerinfo/addr/@zip-pcode'
AS SQL DOUBLE
C. CREATE INDEX custindex ON customer(custinfo)
GENERATE KEY USING XPATH '/customerinfo/addr/zip-pcode'
AS SQL DOUBLE
D. CREATE INDEX custindex ON customer(custinfo)
GENERATE KEY USING XMLPATTERN '/customerinfo/addr/zip-pcode'
AS SQL DOUBLE
Answer: B

7. During a routine inspection of database MYDB, a database administrator obtained the following information by executing the command GET DB CFG FOR mydb. (Note: output has been reduced to conserve space.)
Automatic maintenance (AUTO_MAINT) = OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = ON
Automatic reorganization (AUTO_REORG) = ON
Which command will activate automatic statistics collection for the database MYDB?
A. UPDATE DB CFG FOR mydb USING AUTO_MAINT ON AUTO_STATS_PROF OFF AUTO_PROF_UPD OFF
B. UPDATE DB CFG FOR mydb USING AUTO_RUNSTATS ON AUTO_STATS_PROF ON
C. UPDATE DB CFG FOR mydb USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_RUNSTATS ON
D. UPDATE DB CFG FOR mydb USING AUTO_TBL_MAINT ON AUTO_STATS_PROF ON
Answer: C

8. The test database MYDB requires frequent table and index reorganization to support ongoing application development. A database administrator obtained the following information by executing the command GET DB CFG FOR mydb. (Note: output has been reduced to conserve space.)
Automatic maintenance (AUTO_MAINT) = OFF
Automatic database backup AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF
Which commands will enable automatic table and index reorganization for the database MYDB?
A. REORG TABLE ALL FOR DB mydb AUTOMATICALLY;
REORG INDEXES ALL FOR DB mydb AUTOMATICALLY;
B. UPDATE DB CFG FOR mydb USING AUTO_MAINT ON;
UPDATE DB CFG FOR mydb USING AUTO_REORG ON;
C. UPDATE DB CFG FOR mydb USING AUTO_TABLE_MAINT ON;
UPDATE DB CFG FOR mydb USING AUTO_REORG ON;
D. RESET DB CFG FOR mydb;
UPDATE DB CFG FOR mydb USING AUTO_REORG ON;
Answer: D

9. A database administrator needs to obtain the self tuning settings for a database named MYDB. Which command should be issued?
A. db2set -all
B. GET DBM CFG SHOW DETAIL
C. GET DB CFG FOR mydb SHOW DETAIL
D. LIST MEMORY SETTINGS FOR mydb
Answer: C

10. Which list of keywords contains values that are all valid input parameters for the AUTOCONFIGURE command?
A. mem_percent, workload_type, tpm, isolation
B. mem_percent, workload_type, stmm, isolation
C. workload_type, isolation, num_apps, tpm
D. mem_percent, tpm, stmm, isolation
Answer: A

11. Given the following command:
BACKUP DB dbtest UTIL_IMPACT_PRIORITY 20
Which command should be executed prior to the BACKUP command in order for the backup operation to run in throttled mode?
A. UPDATE DB CFG FOR dbtest USING UTIL_IMPACT_LIM ON
B. UPDATE DBM CFG USING UTIL_IMPACT_LIM 100
C. UPDATE DBM CFG USING UTIL_IMPACT_PRIORITY ON
D. UPDATE DBM CFG USING UTIL_IMPACT_LIM 50
Answer: D

12. Which XML function would be used to return a character string value from an XML document?
A. XMLPARSE()
B. XMLSERIALIZE()
C. XMLCAST()
D. XMLTEXT()
Answer: B

13. A database administrator wishes to enable automatic table and index reorganization. Which set of Database Configuration parameters must be set to ON for automatic table and index reorganization to be enabled?
A. AUTO_MAINT, AUTO_REORG
B. AUTO_MAINT, AUTO_TBL_MAINT, AUTO_REORG
C. AUTO_MAINT, AUTO_RUNSTATS, AUTO_REORG
D. AUTO_TBL_MAINT, AUTO_REORG
Answer: B

14. Which command exports all files necessary to register XML schemas and DTDs at the target database?
A. db2look -d dbdev -x -xml -xd /home/xml/ddl/
B. db2look -d dbdev -xd -xpath /home/smith
C. db2look -d dbdev -xml -o dbdev.ddl
D. db2look -d dbdev -a -e -xs -xdir /home/jones
Answer: D


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

Test4pass 000-736 Exam Features

Quality and Value for the 000-736 Exam

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

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

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

http://www.test4pass.com/000-736-exam.html The safer.easier way to get IBM certifications II Certification .


Guarantee | Buying Process | F.A.Q. | Payment | Refundment Term | Semples | Testing Engine | privacy | Contact | Sitemap 1 2 3 4

Copyright©2006-2009 sale test4pass Limited. All Rights Reserved

sale test4pass materials do not contain actual questions and answers from Microsoft's Cisco's Certification Exams.