pass4sure ibm 000-730

DB2 9 Fundamentals : 000-730 Exam
Test Information:
• Number of questions: 64
• 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 Database Administrator – DB2 9 DBA for z/OS
• IBM Certified Database Associate — DB2 9 Fundamentals
• IBM Certified Solution Designer — DB2 Business Intelligence V8
• IBM Certified Advanced Database Administrator – DB2 9 for Linux UNIX and Windows
• IBM Certified Application Developer – DB2 9

Exam Topics Include:
• Planning
• Security
• Working with Databases and Database Objects
• Working with DB2 Data using SQL
• Working with DB2 Tables, Views and Indexes
• Data Concurrency

Product Description

Exam Number/Code: 000-730

Exam Name:DB2 9 Fundamentals

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

Exam Details

This Database Associate is an entry level DBA or a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 9 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how DB2 9 is packaged and installed, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation. To attain the IBM Certified Database Associate – DB2 9 Fundamentals certification, candidates must pass 1 test(000-730).
QUESTION 1
Which object may be used during query optimization to improve the performance for a subset of SELECT queries?

A. MQT B. Trigger
C. Read Only Cursor
D. Stored Procedure

Answer: A

QUESTION 2
Which of the following commands is used to retrieve database named from the local catalog for DRDA host databases on system I and system z?

A. List DB Directory B. List DCS Directory C. List Node Directory
D. List Active Databases

Answer: B

QUESTION 3
Which of the following describes the object of a DB2 database and their relationship?

A. Instance
B. Table Space
C. System Catalog
D. Schema Repository

Answer: C

QUESTION 4
Which of the following is a characteristic of a sequence?

A. A sequence will never generate duplicate values
B. The MAXVLAUE of a sequence can be equal to the MINVALUE
C. It is not possible to create a sequence that generates a constant since the INCREMENT
value must be greater than zero
D. When a sequence cycles back to the either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries

Answer: B

QUESTION 5
Which of the following database objects can be used to raise an error if a table is updated?

A. Package
B. Trigger
C. Stored Procedure
D. Informational Constraint

Answer: B

QUESTION 6
A “Trusted” Client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?

A. User ID/Password File B. Communications Layer C. Client Applications
D. Operating System

Answer: D

QUESTION 7
The following triggers were defined for table TAB1 in the order shown:
If an event occurs that causes all of them to activate, which trigger will be activated first?

A. TRIG_A B. TRIG_B C. TRIG_C D. TRIG_D

Answer: A

QUESTION 8
Which of the following will DELETE all of the rows from the table T03?

A. DELETE * FROM TABLE T03
B. DELETE ALL FROM T03
C. DELETE * FROM T03
D. DELETE FROM T03

Answer: D

QUESTION 9
Which of the following tools for DB2 V9 allows a user to create and debug a SQL
stored procedure?

A. Control Center
B. Development Center
C. Developer Workbench
D. Stored Procedure Builder

Answer: C

QUESTION 10
Application A is designed to execute the following SQL statements within a Single
Unit of Work(UOW).
Application A and Application B execute their first SQL statements at the same time. When Application A and Application B try to execute their Second SQL
statement, a deadlock occurs. What will happen?

A. The database manager will rollback the transaction in both applications
B. The database manager will rollback the transaction in one of the two applications
C. Application B will successfully update the EMPLOYEE and DEPARTMNET tables; Application A will placed in a lock wait state
D. Application A will successfully update the EMPLOYEE and DEPARTMNET tables; Application B will terminate when the lock timeout value is reached

Answer: B

QUESTION 11
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?

# pass4sure ibm 000-730 Questions and Answers : 128 Q&A
# Updated: October 1st , 2008
# Price: $159.99 $99.99
Free down:Testking ibm 000-730
Free down:Pass4sure ibm 000-730

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-935
• passguide 000-m20
• 000-436
• pass4sure ibm 000-514
• passguide 000-m13
• Actualtests ibm 000-702
• Actualtests ibm 000-154
• 000-704
• 000-850
• 000-937
• 000-430
• passguide 000-918
• 000-906
• passguide 000-m27
• Actualtests ibm 000-817