pass4sure ibm 000-731

DB2 9 DBA for Linux, UNIX and Windows : 000-731 Exam
Test Information:
• Number of questions: 69
• Time allowed in minutes: 90
• Required passing score: 59%

Related certifications:
• IBM Certified Database Administrator — DB2 9 DBA for Linux UNIX and Windows
• IBM Certified Advanced Database Administrator – DB2 9 for Linux UNIX and Windows
• IBM Certified Advanced Deployment Professional – Tivoli Storage Management Solutions 2007
• IBM Certified Advanced Deployment Professional – Tivoli Security Management Solutions 2007
• IBM Certified Advanced Deployment Professional – Tivoli Enterprise Management Solutions 2007

Exam Topics Include:
• DB2 Server Management
• Data Placement
• Database Access
• Analyzing DB2 Activity
• Utilities
• High Availability
• Security
Product Description

Exam Number/Code: 000-731

Exam Name:DB2 9 DBA for Linux, UNIX and Windows

“DB2 9 DBA for Linux, UNIX and Windows”, also known as 000-731 exam, is a IBM certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 138 Q&As to your 000-731 Exam preparation. In the 000-731 exam resources, you will cover every field and category in IBM certifications helping to ready you for your successful IBM Certification.

Exam Details

If you are knowledgeable with DB2 9 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role. To attain the IBM Certified Database Administrator

QUESTION 1
1. A system Managed Table space is created with three containers. Container 1 is limited to 1 GB of storage. Containers 2 each. Approximately, what is the maximum amount of data that can be stored in this table space?

A. 1 GB B. 3 GB C. 5 GB D. 11 GB

Answer: B

QUESTION 2
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

QUESTION 3
Which of the following statements prevents two employees with the same first name, middle initial and last name from being inserted into the table, but allows NULL values?

A. CREATE INDEX e1 on Employee(firstname, midinit, lastname)
B. CREATE UNIQUE INDEX e1 on employee(firstname, midinit, lastname) C. ALTER TABLE EMPLOYEE ADD CONSTRAINT Const1
UNIQUE(Firstname,midinit,lastname)
D. ALTER TABLE employee ADD CONSTRAINT const1 Primary
KEY(Firstname,midinit,lastname)

Answer: B

QUESTION 4
A. 0
B. 1
C. 2
D. 3

Answer: A

QUESTION 5
Please refer to the exhibit.
A. CREATE UNIQUE INDEX inx1 ON t1 (c1) B. CREATE INDEX inx1 ON t1 (c1,c2,c3)
C. CREATE INDEX inx1 ON t1 INCLUDE (c2,c3)
D. CREATE UNIQUE INDEX inx1 ON t1(c1) INCLUDE(c2,c3) Answer: D
QUESTION 6
Which of the following event monitor types is defined and active for all by default?

A. DATABASE B. DEADLOCKS
C. BUFFERPOOLS D. CONNECTIONS

Answer: B

QUESTION 7
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

QUESTION 8
Which of the following TWO commands will apply AUTOCONFIGURE
recommended changes to buffer pools?

A. AUTOCONFIGURE USING APPLY NONE
B. AUTOCONFIGURE USING APPLY DB ONLY
C. AUTOCONFIGURE USING APPLY db AND dbm
D. AUTOCONFIGURE USING E. AUTOCONFIGURE USING APPLY DB AND BUFFERPOOLS ONLY Answer: B,C
QUESTION 9
Which of the following settings would allow 20 sorts with a maximum of 10MB each
to run currently on a 64-bit instance?

A. Set the DB SHEAPTHERS to 50000 and DB SORTHEAP to 2500
B. Set the DBM SHEAPTHERES to 50000 and DB SORTHEAP to 2500
C. Set the DBM SHEAPTHERS to 50000 and DBM SORTHEAP to 2500
D. Set the DBM SHEAPTHERS_SHR to 50000 and DBM SHEAPTHRES to 2500

Answer: B

QUESTION 10
Which of the following is the most complete list of methods by which the EXPORT
utility can be invoked?

A. Control Center and the CLP
B. Control Center, CLI and the CLP
C. Control Center, CLP and the ADMIN_CMD stored procedures
D. Control Center, CLI,CLP and ADMIN_CMD stored procedures

Answer: D

*pass4sure ibm 000-731 Questions and Answers : 138 Q&As
* Updated: October 3rd , 2008
* Price: $159.99 $99.99
Free down:Testking ibm 000-731
Free down:Pass4sure ibm 000-731

IBM Free Downloads

Type	Exam Bible	New Questions & Answers	Latest Updated	Download link
	All Ibm 's Exam Pack	767	1 days ago	Download

Random Posts

• 000-M42
• pass4sure ibm 000-741
• LOT-983
• LOT-822
• 000-528
• 000-236
• passguide 000-737
• Actualtests ibm 000-749
• passguide 000-m20
• Actualtests ibm 000-466
• Actualtests ibm 000-993
• pass4sure ibm 000-299
• 000-028
• 000-793
• Testking ibm 000-875