DB2 10.1 Fundamentals

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

You have 138 total questions to study from
Each page has 5 questions, making a total of 28 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on December 30, 2025
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?

Correct Answer: A

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);

Correct Answer: D

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

Correct Answer: D

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.

Correct Answer: C

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

Correct Answer: A