000-731 Exam

Quality and Value for the 000-731 Exam

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

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

Hot KeyWords On 000-731 test

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

How to pass your 000-731 exam

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

��
��
Exam : IBM 000-731
Title : DB2 9 DBA for Linux,UNIX and Windows


1. On a DB2 server with two instances, inst1 and inst2, inst1 is the default and current instance. Which of the following will successfully start the instance inst2?
A.db2start
B.db2start inst2
C.set db2instance=inst2 db2start
D.set db2instance inst2 db2start
Answer: C

2. Which of the following would prevent an application from waiting indefinitely to obtain a lock on table T1?
A.Alter table T1 locksize table
B.Update db cfg for sample using lock_wait 10000
C.Update db cfg for sample using locktimeout 10000
D.Update db cfg for sample using lock_wait automatic
Answer: C

3. Given the table MYTAB:
A.The index MYINX will not be created.
B.The word UNIQUE will be omitted by DB2 and a non-unique index MYINX will be created.
C.The unique index MYINX will be created and the rows with duplicate keys will be deleted from the table.
D.The unique index MYINX will be created and the rows with duplicate keys will be placed in an exception table.
Answer: A

4. A database administrator needs to benchmark a database for both SQL and XQUERY. What utility can be used to accomplish this task?
A.db2batch
B.db2explain
C.db2analyze
D.db2benchmark
Answer: A

5. Based on the following database manager configuration parameter values :
What is the maximum number of applications that can be executing concurrently in the instance?
A.50
B.100
C.200
D.400
Answer: B

6. An excerpt from an application snapshot reveals the following :
Which of the following configurations would be observed?
A.INTRA_PARALLEL ON and MAXAGENTS 4 and database configuration DFT_DEGREE 1
B.INTRA_PARALLEL ON and MAX_QUERYDEGREE 3 and database configuration DFT_DEGREE 4
C.INTRA_PARALLEL ON and MAX_QUERYDEGREE 6 and database configuration DFT_DEGREE 1
D.INTRA_PARALLEL ON and MAX_QUERYDEGREE 4 and database configuration DFT_DEGREE ANY
Answer: D

7. Given the following situation:
What happens after restoring the table space ts1 and issuing the following command?
db2 rollforward db sample to 2006-06-16-14.21.56 and stop tablespace(ts1)
A.The roll forward is executed to the end of logs.
B.The roll forward is not executed and an error message is generated.
C.The roll forward is executed and table t4 is placed in set integrity pending state.
D.The roll forward is executed and tables t1 and t4 are placed in set integrity pending state.
Answer: C

8. Which of the following REORG table options will compress the data in a table using the existing compression dictionary?
A.KEEPEXISTING
B.KEEPDICTIONARY
C.RESETDICTIONARY
D.EXISTINGDICTIONARY
Answer: B

9. Given the following notification log entry:
In order to determine the name of the application which encountered the error, which of the following actions must be taken?
A.Issue DB2 LIST DCS APPLICATIONS and search for AC14B132.OB12.0138C7070500
B.Issue DB2 LIST APPLICATIONS and search for AC14B132.OB12.0138C7070500
C.Issue DB2 LIST DCS APPLICATIONS and search for 660
D.Issue DB2 LIST APPLICATIONS and search for 660
Answer: B

10. Which of the following authorities should a user have in order to QUIESCE the DB2 instance?
A.DBADM
B.SECADM
C.SYSMON
D.SYSMAINT
Answer: D

11. Which of the following utilities provides a report of memory status for instances, databases, and agents?
A.db2mtrk
B.db2mchk
C.db2expln
D.db2memview
Answer: A

12. Which of the following settings would allow 20 sorts with a maximum of 10MB each to run concurrently on a 64-bit instance?
A.Set the DB SHEAPTHRES to 50000 and the DB SORTHEAP to 2500.
B.Set the DBM SHEAPTHRES to 50000 and the DB SORTHEAP to 2500.
C.Set the DBM SHEAPTHRES to 50000 and the DBM SORTHEAP to 2500.
D.Set the DBM SHEAPTHRES_SHR to 50000 and the DBM SHEAPTHRES to 2500.
Answer: B

13. The LIST APPLICATIONS command provides the following output:
The Database Administrator needs to force the application myapp executed by user usr1. Which command must be issued?
A.FORCE APPLICATION (25667)
B.FORCE APPLICATION (myapp)
C.FORCE APPLICATION (myapp user usr1)
D.FORCE APPLICATION (LOCAL.DB2.060609075930)
Answer: A

14. Which of the following statements about SCHEMA objects is true?
A.A schema must always be associated with a user.
B.Triggers and sequences do not have schemas associated with them.
C.After creating a new database, all users who successfully authenticate with the database have the ability to create a new schema.
D.If a schema is not explicitly specified in a SQL statement, the PUBLIC schema is assumed.
Answer: C