Examsoon 000-731.pdf

Loading ...
Global Do...
News & Politics
000-731 DB2 Braindump 
ExamSoon 000-731 Exams
IBM DB2 9 DBA for Linux,UNIX and Windows
 
O rder : 000-731 Exam
Practice Exam: 000-731
Exam Number/Code: 000-731
Exam Name: DB2 9 DBA for Linux,UNIX and Windows
Questions and Answers: 138 Q&As 
Free 000-731 Braindumps
  
  
Exam : IBM 000-731
Title : DB2 9 DBA for Linux,UNIX and Windows
1. 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
2. A DBA attempts to use the Task Center to schedule a daily database backup and is not successful. A GET 
ADMIN CFG command shows that TOOLSCAT_DB, TOOLSCAT_INST, and TOOLSCAT_SCHEMA are all NULL on 
the DB2 server where the backup task was attempted. What must be done to enable scheduling of tasks on this 
server using the Task Center?
A.Use the CREATE DATABASE command to create a database called TOOLSDB.
B.Use the CREATE TOOLS CATALOG command to create the DB2 tools catalog tables in a new or existing 
database.
C.Create a table space called SYSTOOLSPACE in the database that the Task Center was trying to schedule a 
Backup for using CREATE TABLESPACE.
D.Create a new schema called TOOLSCAT in the database that the Task Center was trying to schedule a Backup for 
and then use UPDATE ADMIN CFG to reference that database, instance and schema.
Answer: B
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. 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
5. 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
6. 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
7. 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
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. 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
10. 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
11. Given the following server information, which of the following commands will catalog this node?
A.CATALOG TCPIP NODE db2tcp REMOTE 10.205.15.100
B.CATALOG TCPIP NODE db2tcp REMOTE tcphost SERVER 60000
 
 
 

 
 
C.CATALOG TCPIP NODE db2tcp REMOTE tcphost SERVER db2inst1
D.CATALOG TCPIP NODE db2tcp REMOTE tcphost INSTANCE db2inst1
Answer: B
12. For a DB2 instance db2inst1 on a server with port 50000 available, which of the following commands must be run 
in order to configure DB2 to listen for incoming TCP/IP connections?
A.a, b, c
B.c, e, f
C.a, d, e
D.a, c, e
Answer: D
13. 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
14. 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
15. 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
16. The database sample is created using the following command:
In order to update statistics for only the tables that need it, between the hours of midnight and 2am, what actions 
must be taken?
A.Enable HEALTH MONITOR for the database.
B.Update the relevant database configuration parameters.
C.Update the relevant database manager configuration parameters.
D.Use automatic maintenance and define an appropriate maintenance window.
Answer: D
17. 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
 
 
 

 
18. 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
19. There is a job in Task Center scheduled to run every Saturday. The Scheduler is turned off on Friday for system 
maintenance and then restarted on Monday. Under which of the following conditions is the job scheduled for Saturday 
executed when the Scheduler is restarted?
A.The exec_exp_task DB2 registry is set to yes.
B.The exec_exp_task Database configuration parameter is set to yes.
C.The exec_exp_task Database Manager configuration parameter is set to yes.
D.The exec_exp_task Administration server configuration parameter is set to yes.
Answer: D
20. Which of the following commands can be used to force all users and applications from all databases?
A.FORCE ALL
B.FORCE USERS ALL
C.FORCE APPLICATION ALL
D.FORCE USERS, APPLICATION ALL
Answer: C
More 000-731 Braindumps Information 
Exam Description
1. ExamSoon offer free update service for three month.
After you purchase our product, we will offer free update in time for three month. 
2. High quality and Value for the 000-731 Exam. 
ExamSoon Practice Exams for 000-731 are written to the highest standards of technical accuracy, provided by our 
certified subject matter experts and published authors for development.
3. 100% Guarantee to Pass Your DB2 exam and get your DB2 Certification.
We guarantee your success in the first attempt. If you do not pass the DB2 "000-731" (DB2 9 DBA for Linux,UNIX and 
Windows on your first attempt, send us the official result. We will give you a FULLY REFUND of your purchasing fee 
and send you another same value product for free.
4. ExamSoon DB2 000-731 Exam Downloadable. 
Our PDF or Testing Engine Preparation Material of DB2 000-731 exam provides everything which you need to pass 
your exam. The DB2 Certification details are researched and produced by our Professional Certification Experts who 
are constantly using industry experience to produce precise, and logical. You may get "000-731 exam" questions 
from different websites or books, but logic is the key. Our Product will help you not only pass in the first DB2 9 DBA 
for Linux,UNIX and Windows( DB2 ) exam try, but also save your valuable time.
Comprehensive questions with complete details about 000-731 exam.  
000-731 exam questions accompanied by exhibits. Verified Answers Researched by Industry Experts and almost 
100% correct. 
 
 
 
  
 
 
 
 
  
  

 
  
 
Drag and Drop questions as experienced in the Real DB2 exam. 000-731 exam questions updated on regular basis.  
Like actual DB2 Certification exams, 000-731 exam preparation is in multiple-choice questions (MCQs). Tested by 
many real DB2 exams before publishing. 
Try free DB2 exam demo before you decide to buy it in http://www.ExamSoon.com 
High quality and Valued for the 000-731 Exam: 100% Guarantee to Pass Your 000-731 exam and get your DB2 
Certification. Come to http://www.ExamSoon.com The easiest and quickest way to get your DB2 Certification.
ExamSoon professional provides DB2 000-731 the newest Q&A, completely covers 000-731 test original topic. With 
our completed DB2 resources, you will minimize your DB2 cost and be ready to pass your 000-731 test on Your First 
Try, 100% Money Back Guarantee included! 
000-731 Exam Study Guide 
000-731 exam is regarded as one of the most favourite DB2 Certifications. Many IT professionals prefer to add 000-
731 exam among their credentials. ExamSoon not only caters you all the information regarding the 000-731 exam but 
also provides you the excellent 000-731 study guide which makes the certification exam easy for you. 
ExamSoon Engine Features
Comprehensive questions and answers about 000-731 exam  
000-731 exam questions accompanied by exhibits 
Verified Answers Researched by Industry Experts and almost 100% correct
000-731 exam questions updated on regular basis 
Same type as the certification exams, 000-731 exam preparation is in multiple-choice questions (MCQs). 
Tested by multiple times before publishing
Try free 000-731 exam demo before you decide to buy it in ExamSoon.com 
ExamSoon Help You Pass Any IT Exam
ExamSoon.com offers incredib le career enhancing opportunities. We are a team of IT professionals that focus on providing 
our customers with the most up to date material for any IT certification exam. This material is so effective that we Guarantee 
you will pass the exam or your money back.
000-730  DB2 9 Fundamentals  
000-355  iseries system administration v5r2  
000-731  DB2 9 DBA for Linux,UNIX and Windows  
000-732  DB2 9 for z/OS Database Administrator  
000-735  DB2 9.5 SQL Procedure Developer  
000-442  ibm content manager version 8  
000-702  db2 udb v8.1 for z/os database administration  
000-700  ibm db2 udb v8.1 family fundametals  
000-513  db2 udb v7.1 database administration for unix windows % os/2  
000-516  db2 udb database administration for os/390  
000-704  db2 udb v8.1 advanced db admin for linux,unix+windwos  
000-703  db2 udb v8.1 familu application development  
000-706  db2 v8.1 for linux,unix and windows db admin upgrade  
000-701  ibm db2 udb v8.1 database admin for linux unix&windows  
000-514  db2 udb v7.1 family application development  
000-541  DB2 9.7 DBA for Linux UNIX and Windows  
Related 000-731 Exams
 

 
  
 
  
Other IBM Exams
000-102 
000-744 
COG-125 
000-792 
000-643 
000-114 
005-002 
000-M04 
COG-132 
000-863 
000-138 
000-486 
000-816 
000-425 
000-808 
000-432 
000-314 
000-960 
000-424 
000-399