Home > IBM > DB2 > 000-706

000-706 Exam

db2 v8.1 for linux,unix and windows db admin upgrade

Exam Number/Code : 000-706
Exam Name : db2 v8.1 for linux,unix and windows db admin upgrade
Questions and Answers : 60 Q&As
Update Time: 2013-04-05
Price: ~~$ 119.00~~ $ 69.00
000-706 Hard Copy (PDF)
000-706 Test Engine

000-706

Free 000-706 Demo Download

Test4pass offers free demo for DB2 000-706 exam (db2 v8.1 for linux,unix and windows db admin 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-706 exam test is the hot exam of IBM certification. Test4pass offer you all the Q&A of the 000-706 real test . It is the examination of the perfect combination and it will help you pass 000-706 exam at the first time!

Why choose Test4pass 000-706 braindumps

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

Quality and Value for the 000-706 Exam

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

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

Hot KeyWords On 000-706 test

How to pass your 000-706 exam

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

��
��
Exam : IBM 000-706
Title : DB2 V8.1 For Linux,Unix And Windows DB Admin Upgrade

1. If type-1 indexes exist on table ADMIN.EMP, which of the following will change them to type-2 indexes?
A. RUNSTATS ON TABLE admin.emp AND INDEXES ALL
B. REORG INDEXES ALL FOR TABLE admin.emp CONVERT
C. REORG INDEXES ALL FOR TABLE admin.emp CLEANUP ONLY ALL
D. REORG INDEXES ALL FOR TABLE admin.emp CLENAUP ONLY PAGES
Answer: B

2. Given that there are two containers in table space TS1 and following statement:
ALTER TABLESPACE ts1
REDUCE (ALL 100 M)
Which of the following describes the result of the statement?
A. The total size of table space TS1 will be reduced to 100 MB.
B. Each container in table space TS1 will be reduced in size by 100 MB.
C. Each container in table space TS1 will be reduced in size to 100 MB.
D. Each container in table space TS1 that has no data will be reduced in size to 100 MB.
E. Each container in table space TS1 that has no data will be reduced in size by 100 MB.
Answer: B

3. Which of the following Command Line Processer (CLP) commands will display and make changes to the database manager congfiguration?
A. AUTOCONFIGURE APPLY DBM
B. AUTOCONFIGURE CHANGE DBM ONLY
C. AUTOCONFIGURE APPLY DB AND DBM
D. AUTOCONFIGURE CHANGE DB AND DBM
Answer: C

4. Following an ATTACH, to view the current values and the delayed values for database manager configuration, what command should be issued?
A. GET DATABASE MANAGER CONFIGURATION *
B. GET DATABASE MANAGER CONFIGURATION ALL VALUES
C. GET DATABASE MANAGER CONFIGURATION SHOW DETAIL
D. GET DATABASE MANAGER CONFIGURATION DELAYED VALUES
Answer: C

5. Which of the following combinations of constraint attributes causes the constraint to be used by the SQL compiler, but could allow for data that does not meet the constraint to be inserted into the table?
A. CREATE TABLE ... CONSTRAINT <constraint name>
CHECK (<check condition>) ENFORCED ENABLE QUERY OPTIMZATION
B. CREATE TABLE ... CONSTRAINT <constraint name>
CHECK (<check condition>) ENFORCED DISABLE QUERY OPTIMIZATION
C. CREATE TABLE ... CONSTRAINT <constraint name>
CHECK (<check condition>) NOT ENFORCED ENABLE QUERY OPTIMIZATION
D. CREATE TABLE ... CONSTRAINT <constraint name>
CHECK (<check condition>) NOT ENFORCED DISABLE QUERY OPTIMIZATION
Answer: C

6. USER1 needs to start and stop the DAS on the AIX server. Which ok the following is the minimum authority level that will enable USER1 to be able to do this?
A. USER1 must be in the DASADM_GROUP
B. USER1 must be in the SYSADM_GROUP
C. USER1 must be in the SYSCTRL_GROUP
D. USER1 must be in the SYSMAINT_GROUP
Answer: A

7. When using AUTOCONFIGURE and a workload that is of type OLTP, what should be used for the workload_type parameter?
A. dss
B. mixed
C. simple
D. complex
Answer: C

8. The following command is issued:
REORG INDEXES ALL FOR TABLE staff
Which of the following identifies the concurrent access allowed during the running of this REORG command?
A. The table STAFF is not accessible
B. The table STAFF is accessible, but its indexes cannot be used.
C. The table STAFF and all of its indexes are available for read only access.
D. The table STAFF and all of its indexes are accessible for read or write access.
Answer: A

9. To determine the state of a table space and the location of all containers for that table space, which of the following commands would be used?
A. LIST TABLESPACES SHOW DETAIL
B. GET SNAPSHOT FOR TABLESPACES ON <dbname>
C. LIST TABLESPACE CONTAINERS FOR <tablespace id>
D. GET SNAPSHOT FOR TABLESPACES ON <dbname> SHOW DETAIL
Answer: B

10. The following command is issued:
LOAD FROM staff.ixf OF IXF REPLACE INTO staff
What locks are help during the execution of this load?
A. Share lock on table STAFF
B. Exclusive lock on table STAFF
C. Exclusive lock on all table spaces holding components of the STAFF table
D. Exclusive lock only on table space holding data component of the STAFF table
Answer: B

11. Given the following command and output:
LOAD QUERY TABLE staff
.......
Tablestate:
Load in Progress
Read Access Only
Which of the following LOAD commands is currently executing?
A. LOAD FROM staff.ixf OF IXF INSERT INTO staff
B. LOAD FROM staff.ixf OF IXF REPLACE INTO staff
C. LOAD FROM staff.ixf OF IXF REPLACE INTO staff ALLOW READ ACCESS
D. LOAD FROM staff.ixf OF IXF INSERT INTO staff ALLOW READ ACCESS USE tempspace1
Answer: D

12. A table space delta backup contains which of the following?
A. A copy of all table space data that has changed since the last successful backupl of the table space
B. A copy of all table space data that has changed since the most recent, successful, full backup operation
C. A list of all the table spaces that have been added to the database since the most recent, successful, full backup operation
D. A formatted list of all the database operations that have occurred against the table space since the most recent, successful, full backup operation
Answer: A

13. Use the exhibit button to display the exhibit for this question.
What is indicated by the output from the Health Monitor in the exhibit?
A. 1 warning alert on NTINST, 2 alarm and 1 warning alert on NTDB
B. 1 warning alert on NTINST, 1 alarm and 1 warning alert on NTDB
C. 1 alarm and 1 warning alert on NTINST, 2 alarm and 1 warning alert on NTDB
D. 1 alarm and 1 warning alert on NTINST, 1 alarm and 1 warning alert on NTDB
Answer: B

14. In a system set up for dual logging, to change the location of the second set of logs from c:logpath2 to d:seclogpath, which of the following commands should be used?
A. UPDATE DB CFG USING logpath2 d:seclogpath
B. UPDATE DB CFG USING newlogpath d:seclogpath
C. UPDATE DB CFG USING mirrorlogpath d:seclogpath
D. UPDATE DB CFG USING overflowlogpath d:seclogpath
Answer: C