DB2 10.1 Fundamentals

Here you have the best IBM C2090-610 practice exam questions

You have 138 total questions across 28 pages (5 per page)
These questions were last updated on February 13, 2026
This site is not affiliated with or endorsed by IBM.

Question 1 of 138

If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?

Question 2 of 138

Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?

ALTER TABLE sales ADD COLUMN item CHAR(40);

ALTER TABLE sales ALTER COLUMN item CHAR(40);

ALTER TABLE sales MODIFY COLUMN item CHAR(40);

ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);

Question 3 of 138

Which DB2 object can be used to improve the execution performance of qualified SELECT statements?

Trigger

SQL Procedure

Sequence Object

Materialized Query Table

Question 4 of 138

When is it appropriate to use a sequence?

When you want to control the order in which triggers are fired.

When you want to control the order in which stored procedures can be invoked.

When you want to automatically generate a numeric value that is not tied to any specific column or table.

When you want to automatically generate a numeric value for each row that is added to a specific table.

Question 5 of 138

Which clause should be included in a ALTER TABLE statement to update a table definition with a new column?

ADD COLUMN

ALTER COLUMN

APPEND COLUMN

RENAME COLUMN

About the IBM C2090-610 Certification Exam

About the Exam

The IBM C2090-610 (DB2 10.1 Fundamentals) validates your knowledge and skills. Passing demonstrates proficiency and can boost your career prospects in the field.

How to Prepare

Work through all 138 practice questions across 28 pages. Focus on understanding the reasoning behind each answer rather than memorizing responses to be ready for any variation on the real exam.

Why Practice Exams?

Practice exams help you familiarize yourself with the question format, manage your time, and reduce anxiety on the test day. Our C2090-610 questions are regularly updated to reflect the latest exam objectives.