C2090-730 Online Practice Questions and Answers

Which of the following products is allowed to access other DB2 servers, but cannot accept requests from other remote clients?

A. DB2 Personal Edition

B. DB2 Workgroup Server Edition

C. DB2Enterprise Server Edition

D. DB2 Data Warehouse Edition

Which of the following tasks can NOT be performed using the Developer Workbench?

A. Develop and debug an SQL stored procedure

B. Develop and debug a user-defined data type

C. Develop and debug a user-defined function

D. Develop and run XML queries

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

A. DB2 Express Edition

B. DB2 Personal Edition

C. DB2 Workgroup Server Edition

D. DB2Enterprise Server Edition

Which of the following DB2 products are required on an iSeries or System I server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?

A. DB2 for i5/OS

B. DB2 Runtime Client

C. DB2 ConnectEnterprise Edition

D. DB2 for i5/OS SQL Development Kit

If the following SQL statements are executed in the order shown:

CREATE TABLE orders (order_num INTEGER NOT NULL, buyer_name VARCHAR(35), amount NUMERIC(5,2));

CREATE UNIQUE INDEX idx_orderno ON orders (order_num);

Which of the following describes the resulting behavior?

A. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values

B. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows will be displayed in no particular order

C. Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS table that reference the ORDER_NUM column

D. Every ORDER_NUM value entered must be unique; no other index can be created for the ORDERS table that reference the ORDER_NUM column

Which of the following queries will correctly return the manager information sorted by the manager's last name, department and project name?

A. SELECTlastname, dept, projname, manager, startdate FROM (SELECT name, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = empno) AS empproj ORDER BY name, dept, projname

B. SELECTlastname, dept, projname, manager, startdate FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = mgrno) AS empproj SORT BY lastname, firstname, dept, projname

C. SELECTlastname, dept, projname, manager, startdate FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = mgrno) AS empproj ORDER BY lastname ASC SORT BY dept, projname DESC

D. SELECTlastname, dept, projname, manager, startdate FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = mgrno) AS empproj ORDER BY lastname, dept, projname

Given the following table definition:

SALES

SALES_DATE DATE

SALES_PERSON CHAR(20)

REGION CHAR(20)

SALES INTEGER

Which of the following SQL statements will remove all rows that had a SALES_DATE in the year 1995?

A. DELETE * FROM sales WHEREYEAR(sales_date) = 1995

B. DELETE FROM sales WHEREYEAR(sales_date) = 1995

C. DROP * FROM sales WHEREYEAR(sales_date) = 1995

D. DROP FROM sales WHEREYEAR(sales_date) = 1995

A trigger can be created on which of the following objects?

A. View

B. Catalog Table

C. Stored Procedure

D. Global Temporary Table

Which of the following is a valid DB2 data type?

A. NUMBER

B. INTERVAL

C. BYTE

D. NUM

Application A holds an Exclusive lock on table TAB1 and needs to acquire an Exclusive lock on table TAB2. Application B holds an Exclusive lock on table TAB2 and needs to acquire an Stability isolation level, which of the following will occur?

A. Applications A and B will cause a deadlock situation

B. Application B will read the copy of table TAB1 that was loaded into memory when Application A first read it

C. Application B will read the data in table TAB1 and see uncommitted changes made by Application A

D. Application B will be placed in a lock-wait state until ApplicationA releases its lock