Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?

A. DB2 Express-C

B. DB2 Express

C. DB2 Personal Edition

D. DB2Enterprise Server Edition

Which of the following is NOT a characteristic of a data warehouse?

A. Summarized queries that perform aggregations and joins

B. Heterogeneous data sources

C. Voluminous historical data

D. Sub-second response time

Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?

A. Journal

B. Task Center

C. Activity Monitor

D. Command Line Processor

On which of the following database objects may the SELECT privilege be controlled?

A. Sequence

B. Schema

C. Group

D. View

Which of the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?

A. REVOKE CONNECT ON DATABASE FROM user2

B. REVOKE CREATETAB ON DATABASE FROM user2

C. REVOKE BIND ON DATABASE FROM user2

D. REVOKE BINDADD ON DATABASE FROM user2

Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?

A. LIST DB DIRECTORY

B. LIST DCS DIRECTORY

C. LIST NODE DIRECTORY

D. LIST ACTIVE DATABASES

Given the following table definitions:

DEPARTMENT

DEPTNO CHAR(3) DEPTNAME CHAR(30) MGRNO INTEGER ADMRDEPT CHAR(3)

EMPLOYEE

EMPNO INTEGER FIRSTNAME CHAR(30) MIDINIT CHAR LASTNAME CHAR(30) WORKDEPT CHAR(3)

Which of the following statements will list every employee number and last name, along with the employee number and last name of their manager, including employees that have not been assigned to a manager?

A. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT INNER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

B. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT OUTER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

C. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT OUTER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

D. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT INNER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

Given the following CREATE TABLE statement:

CREATE TABLE customer(custid INTEGER, info XML)

And the following INSERT statements:

INSERT INTO customer VALUES (1000,

' John Doe

25 East Creek Drive

Raleigh

North Carolina

27603

919-555-1212

[email protected]

');

INSERT INTO customer VALUES (1000,

' Paul Smith

412 Stewart Drive

Toronto

Ontario

M8X-3T6

919-555-4444

[email protected]

');

What is the result of the following XQuery expression?

XQUERY declare default element namespace "http://custrecord.dat"; for $info in db2-fn:xmlcolumn ('CUSTOMER.INFO')/customerinfo where $info/addr/state-prov="Ontario" return $info/name/text();

A. Paul Smith

B. Paul Smith

C. Paul Smith

D. Paul Smith

Which two of the following are optional and do not have to be specified when creating a table?

A. Table name

B. Column name

C. Default constraint

D. Column data type

E. NOT NULL constraint

To which of the following resources can a lock NOT be applied?

A. Table spaces

B. Buffer pools

C. Tables

D. Rows