IBM C2090-610 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-610
Exam Name/Title: DB2 10.1 Fundamentals
Certification Provider: IBM
Corresponding Certification: IBM Certified Application Developer

Exam Questions: 138
Updated On: Jun 01, 2026

Question #13

What is the primary purpose of a view?

A. To ensure data clustering.

B. To enable uniqueness.

C. To optimize queries ran against multiple tables.

D. To combine data from multiple tables.

Discussion 0

Correct Answer: D Vote an answer

Question #14

Which statement is true about an index that is used to support a UNIQUE constraint?

A. It cannot be used in a referential constraint.

B. It must be defined as UNIQUE WHERE NOT NULL.

C. It must not contain more than one column.

D. It must be defined with the UNIQUE attribute.

Discussion 0

Correct Answer: D Vote an answer

Question #15

A table named DEPARTMENT contains the following data:

What will happen?

A. The statement will succeed; the last record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.

B. The statement will succeed; the first record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.

C. The statement will fail because a subquery cannot be used in an UPDATE statement.

D. The statement will fail because the result set produced by the subquery will contain more than one row.

Discussion 0

Correct Answer: D Vote an answer

Question #16

Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named EMPLOYEE?

A. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY SALARY
ORDER BY job;

B. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY MIN(salary), MAX(salary)
ORDER BY job;

C. SELECT job, MIN(salary), MAX(salary)
FROM employee
ORDER BY job;

D. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job
ORDER BY job;

Discussion 0

Correct Answer: D Vote an answer

Question #17

When is an INTENT EXCLUSIVE (IX) lock required?

A. When a transaction intends to change the system catalog.

B. When a transaction intends to change but not read data.

C. When a transaction intends to read but not change data.

D. When a transaction intends to read or change data.

Discussion 0

Correct Answer: D Vote an answer

Question #18

Which type of table should you use if you want to define specific time periods when data is valid?

A. Declared global temporary table

B. Materialized query table

C. System-period temporal table

D. Application-period temporal table

Discussion 0

Correct Answer: D Vote an answer

Download Free IBM C2090-610 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM C2090-610 exam.