Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs?

A. DB2 Everyplace

B. DB2 Express Edition

C. DB2 Workgroup Server Edition

D. DB2Enterprise Server Edition

An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?

A. GRANT DROP ON INDEXempid_x TO user1

B. GRANT DELETE ON INDEXempid_x TO user1

C. GRANT INDEX ON TABLE employee TO user1

D. GRANT CONTROL ON INDEXempid_x TO user1

A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?

A. Table

B. Columns

C. Table and Alias

D. Columns and Alias

Given the following table:

TEMP_DATA

TEMP DATE

45 12/25/2006 51 12/26/2006 67 12/27/2006 72 12/28/2006 34 12/29/2006 42 12/30/2006

And the following SQL statement:

CREATE FUNCTION degf_to_c (temp INTEGER) RETURNS INTEGER LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC BEGIN ATOMIC DECLARE newtemp INTEGER; SET newtemp = temp - 32; SET newtemp = newtemp * 5; RETURN newtemp / 9; END

Which two of the following SQL statements illustrate the proper way to invoke the scalar function DEGF_TO_C?

A. VALUESdegf_to_c(32)

B. SELECT date,degf_to_c(temp) AS temp_c FROM temp_data

C. CALLdegf_to_c(32)

D. SELECT * FROMTABLE(degf_to_c(temp)) AS temp_c

E. VALUESdegf_to_c(32) AS temp_c

What is the maximum size that can be specified when creating an XML column in a DB2 table?

A. No size is specified

B. The buffer pool size

C. The page size for the table space

D. The extent size for the table space