Free IBM A2090-610 Practice Test & Real Exam Questions

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

Exam Questions: 138
Updated On: Jun 03, 2026

Question #1

Which operation normally does NOT require an exclusive lock?

A. BIND

B. DROP

C. SELECT

D. GRANT

Discussion 0

Correct Answer: C Vote an answer

Question #2

What privilege is required to create a view on a table that you are not the owner of?

A. INSERT

B. CREATE

C. TRIGGER

D. SELECT

Discussion 0

Correct Answer: D Vote an answer

Question #3

Which platform supports DB2 pureScale environments?

A. z/OS

B. AIX

C. Windows

D. iOS

Discussion 0

Correct Answer: B Vote an answer

Question #4

Which object can a buffer pool be assigned to?

A. Stored procedure

B. Storage group

C. Schema

D. Table space

Discussion 0

Correct Answer: D Vote an answer

Question #5

A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAME. Which SQL statement will return the number of states in each region, ordered by number of states?

A. SELECT region_cd, COUNT(*)
FROM states
GROUP BY state_cd
ORDER BY COUNT(*);

B. SELECT state_cd, COUNT(*)
FROM states
ORDER BY COUNT(*);

C. SELECT region_cd, COUNT(*)
FROM states
GROUP BY region_cd
ORDER BY COUNT(*);

D. SELECT state_cd, COUNT(*)
FROM states
GROUP BY state_cd
ORDER BY state_cd;

Discussion 0

Correct Answer: C Vote an answer

Question #6

Which statement about application-period temporal tables is true?

A. Is based on explicitly-supplied timestamps that define the time periods during which data is valid.

B. Consists of explicitly-supplied timestamps and a separate associated history table.

C. Is useful when one wants to keep both user-based period information and system-based historical information.

D. Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current.

Discussion 0

Correct Answer: A Vote an answer

Question #7

Which protocol provides applications the ability to connect to and update multiple DB2 databases within the same transaction?

A. Type-3 connect

B. Type-1 connect

C. Type-4 connect

D. Type-2 connect

Discussion 0

Correct Answer: D Vote an answer

Download Free IBM A2090-610 Demo

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