C2090-610 Online Practice Questions and Answers

You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal?

A. CLI

B. XML

C. JDBC

D. RUBY

When an index is created for a table, where is the metadata for that index stored?

A. In the table definition.

B. In the system catalog.

C. In the schema that the index resides in.

D. In the metadata of the table the index was created for.

What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?

A. locator

B. pointer

C. address

D. reference

Which two activities indicate the need for a data warehouse? (Choose two.)

A. Confirm product inventory.

B. Monitor product availability.

C. Summarize sales by region.

D. Identify patterns for products sold in the last five years.

E. Associate one or more products with a purchase order.

What is the primary function of an Online Transaction Processing (OLTP) workload?

A. To combine data from multiple sources.

B. To discover hidden relationships in data.

C. To analyze large amounts of data to find patterns.

D. To make changes to a small number of records within a single transaction.

In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?

A. Locked

B. Waiting

C. Pending

D. Unconnected

Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?

A. SALES can be the name of a schema.

B. SALES can be the name of a package.

C. SALES can be the name of an existing alias.

D. SALES can be the name of a declared global temporary table.

Which DB2 object limits the user's ability to retrieve data from a table by defining a SQL statement in the object?

A. View

B. Index

C. Trigger

D. Check constraint

When a COMMIT statement is executed, what happens?

A. All locks held on the database are automatically released.

B. Data stored in global temporary tables is automatically deleted.

C. Open cursors defined WITH HOLD are closed, but their data is retained.

D. The current transaction is terminated and a new transaction boundary is started.

User USER1 wants to define a required relationship between two tables named TAB1 and TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are deleted from table TAB2. What must user USER1 do to accomplish this?

A. 1) Create a primary key on table TAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE CASCADE rule.

B. 1) Create a primary key on table TAB2; 2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE CASCADE rule.

C. 1) Create a primary key on table TAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE RESTRICT rule.

D. 1) Create a primary key on table TAB2; 2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE RESTRICT rule.