C2090-730 Online Practice Questions and Answers

Which of the following DB2 products can only be installed on a System i server?

A. DB2 for z/OS

B. DB2 for i5/OS

C. DB2 Data Warehouse Edition

D. DB2Enterprise Server Edition

Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?

A. CLOB

B. BLOB

C. Hierarchically

D. Rows and columns

Which of the following events will NOT cause a trigger to be activated?

A. A select operation

B. An insert operation

C. An update operation

D. A delete operation

A sequence was created with the DDL statement shown below:

CREATE SEQUENCE my_sequence CACHE 10 ORDER

The following statements are successfully executed in sequence through separate database connections:

CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES

NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar What is the current value of the :con1hvar host variable?

A. 2

B. 3

C. 11

D. 30

The opening of cursor CSR01 produces the following result set:

STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey James T100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405

If this Fetch statement is executed:

FETCH csr01 INTO :studnum, :firstname, :lastname, :class

Which of the following DELETE statements will cause this row to be deleted?

A. DELETE ALL FROM tab01 FOR CURRENT OF csr01

B. DELETE FROM tab01 FOR CURRENT csr01 WITH RS

C. DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS

D. DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR

A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month's data?

A. Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.

B. Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re-create the view.

C. Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.

D. Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.

Given the following requirements:

Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Make the identity column unique.

Which of the following CREATE statements will successfully create this table?

A. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

B. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTNO))

C. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

D. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?

A. GRAPHIC

B. BINARY

C. IMAGE

D. BLOB

When does a view get populated?

A. When it is created

B. When it is referenced in an INSERT statement

C. The first time any executable SQL statement references it

D. Any time an executable SQL statement references it

How does DB2 protect the integrity of indexes when data is updated?

A. Locks are acquired on the data.

B. Locks are acquired on index keys.

C. Locks are acquired on index pages.

D. Locks are acquired on index pointers.