000-701 Exam

Quality and Value for the 000-701 Exam

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

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

Hot KeyWords On 000-701 test

We collect some hot keywords about this exam:
Test4pass , Pass 4 Sure , Test in Side ,Pass Guide ,Test King 000-701 exam | 000-701 pdf exam | 000-701 braindumps | 000-701 study guides | 000-701 trainning materials | 000-701 simulations | 000-701 testing engine | 000-701 vce | 000-701 torrent | 000-701 dumps | free download 000-701 | 000-701 practice exam | 000-701 preparation files | 000-701 questions | 000-701 answers.

How to pass your 000-701 exam

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

��
��
Exam : IBM 000-701
Title : IBM DB2 UDB V8.1 DataBase Admin For Linux Unix&Windows


1. Assuming a user has CREATETAB privileges, which of the following privileges will allow the user to create a table T2 with a foreign key that references table T1?
A. SYSCTRL
B. SYSMAINT
C. UPDATE on table T1
D. CONTROL on table T1
Answer: D

2. Which of the following is required to specify the output data during an EXPORT?
A. Union
B. Key range
C. Equi-join
D. Fullselect
Answer: D

3. On which of the following event types can a WHERE clause be used to filter the data returned by the event monitor?
A. TABLES
B. DEADLOCKS
C. TABLESPACES
D. CONNECTIONS
Answer: D

4. Which of the following statements is required to register a federated database source?
A. CREATE VIEW
B. CREATE WRAPPER
C. CREATE TRANSFORM
D. CREATE TYPE MAPPING
Answer: B

5. Given the following tables:
Referential integrity must be supported between parent table CANDIDATE and dependent table TEST_TAKEN. Which of the following unique constraints can be used to support this referential integrity?
A. Foreign key on table CANDIDATE
B. Primary key on table CANDIDATE
C. Foreign key on table TEST_TAKEN
D. Primary key on table TEST_TAKEN
Answer: B

6. Which two of the following DB2 commands can be used independently to update the statistical information used by the optimizer when choosing an access path?
A. REORG
B. IMPORT
C. REBIND
D. RUNSTATS
E. CREATE INDEX
Answer: DE

7. Given the following DB2DIAG.LOG entry:
"Crash Recovery is needed."
and the database configuration parameter AUTORESTART is set to off.
Which of the following would be required to initiate crash recovery?
A. CONNECT TO
B. RESTART database
C. RECOVER database
D. RESTORE database
Answer: B

8. Given the following statement:
CREATE TABLESPACE dms1 MANAGED BY DATABASE USING (FILE 'dms01' 1024K)
How many pages will be created for the table space?
A. 128
B. 256
C. 512
D. 1024
Answer: B

9. Which of the following will the REORGCHK command display?
A. Only packages that need to be rebound
B. Only tables that need to be reorganized
C. Information to determine which tables need to be reorganized
D. The timestamp indicating the last time each table was reorganized
Answer: C

10. Which two of the following are only possible using a redirected restore?
A. Redefining table space containers
B. Replacing a damaged recovery history file
C. Recovering table spaces in roll-forward pending
D. Specifying an alternate log path for roll forward
E. Restoring the database onto a different server with the same operating system
Answer: AE

11. Which of the following DB2 utilities can insert data into a view?
A. LOAD
B. UPLOAD
C. IMPORT
D. LOADVIEW
Answer: C

12. Given an application with the embedded static SQL statement:
INSERT INTO admin.payroll (employee, salary) VALUES ("Joe Smith",30000)
Which two of the following privileges are required to successfully bind the application?
A. ALTER
B. INSERT
C. UPDATE
D. BINDADD
E. EXECUTE
Answer: BD

13. Given an application with the embedded static SQL statement:
INSERT INTO admin.payroll (employee, salary) VALUES ("Becky Smith",80000)
Which of the following privileges must a user hold to run the application?
A. ALTER on the table
B. INSERT on the table
C. DBADM on the database
D. EXECUTE on the package
Answer: D

14. After a successful table space restore command, which of the following states will the table space be in?
A. Restore pending
B. Recovery pending
C. Restore in progress
D. Roll forward pending
Answer: D