IBM DB2 10.1 Fundamentals - 000-610 Exam Questions [2026]

QUESTION NO: 1
Which statement about INSERT operations is true?

A. Inserted values must satisfy the conditions of any check constraints defined on the table. B. If the underlying table of a view being referenced by an INSERT statement has one or more unique indexes, each row inserted does not have to conform to the constraints imposed by those indexes. C. If an INSERT statement omits any column from the inserted row that is defined as NULL or NOT NULL WITH DEFAULT, the statement will fail. D. The INSERT statement is used to insert rows into a table, view, or table function.

Correct Answer: A

QUESTION NO: 2
What is the primary function of an Online Transaction Processing (OLTP) workload?

A. To analyze large amounts of data to find patterns. B. To combine data from multiple sources. C. To make changes to a small number of records within a single transaction. D. To discover hidden relationships in data.

Correct Answer: C

QUESTION NO: 3
Which two activities indicate the need for a data warehouse? (Choose two.)

A. Confirm product inventory. B. Summarize sales by region. C. Monitor product availability. D. Identify patterns for products sold in the last five years. E. Associate one or more products with a purchase order.

Correct Answer: B,D

QUESTION NO: 4
Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement?

A. Reset the sequence to its starting value. B. Change the increment between future values. C. Change the data type of the sequence. D. Establish new minimum or maximum values.

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
What factor influences lock conversion/promotion?

A. Lock size B. Number of locks C. Available real storage D. Lock mode needed

Correct Answer: D

QUESTION NO: 6
A table named EMPLOYEE was created as follows:

Which action will prevent unauthorized users from accessing SSN data?

A. Alter the table definition so that SSN data is stored in a separate schema that only authorized users can access. B. Assign the SSN column to a restricted role that only authorized users can access. C. Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data. D. Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.

Correct Answer: D

QUESTION NO: 7
When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?

A. A schema with the userid of the UDF definer. B. The SYSFUN schema. C. A schema with the name of the UDF. D. The SYSIBM schema.

Correct Answer: A

QUESTION NO: 8
A new user named USER1 needs to retrieve information from a database named MYDB. What authority must be granted to user USER1?

A. DBCTRL authority B. ACCESSCTRL authority C. SQLADM authority D. DATAACCESS authority

Correct Answer: D

QUESTION NO: 9
The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of the following?

A. Define a view that only consists of columns that have check constraints defined. B. Define a view on one or more tables or views. C. Revalidate all invalid objects that are referenced on a view's fullselect. D. Ensure that any inserted or updated rows conform to the definition of the view.

Correct Answer: D

QUESTION NO: 10
Which operation normally does NOT require an exclusive lock?

A. BIND B. SELECT C. GRANT D. DROP

Correct Answer: B