000-610 by IBM Valid Free Exam Practice Test

Question 1

Which command is used to back out a subset of database changes that have been made within a unit of work?

A. COMMIT TO SAVEPOINT B. ROLLBACK C. COMMIT D. ROLLBACK TO SAVEPOINT

Correct Answer: D

Question 2

What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

A. Uncommitted read (UR) B. Cursor stability (CS) C. Repeatable read (RR) D. Read stability (RS)

Correct Answer: C

Question 3

After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create a package that is stored in the database so it will take advantage of the new indexes. Which authority/privilege must user USER1 be granted in order to re-create the package?

A. BIND B. BIND_REBIND C. BINDADD D. REBIND

Correct Answer: A

Question 4

You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal?

A. JDBC B. XML C. CLI D. RUBY

Correct Answer: A

Question 5

Which data type should be used to store data in a column that represents money and accurately returns a two position scale?

A. BINARY B. BIGINT C. DOUBLE D. DECIMAL

Correct Answer: D

Question 6

Which statement about a deadlock is true?

A. The victim must wait until the holder releases the lock. B. The victim will read through the lock. C. The victim will be rolled back. D. Both victim and holder are rolled back.

Correct Answer: C

Question 7

Which object is used to cache table and index data as it is read from disk?

A. Database B. Table space C. Package cache D. Buffer pool

Correct Answer: D

IBM DB2 10.1 Fundamentals - 000-610 Exam Practice Test