For which types of servers can you use IBM Data Studio to create and manage SQL procedures?

A. DB2 for LUW, DB2 for z/OS, Oracle

B. DB2 for LUW, DB2 for z/OS, SQL Server

C. DB2for LUW, DB2 for z/OS, MySQL

D. DB2 for LUW, DB2 for z/OS, Sybase

Which CREATE TRIGGER statement is valid?

A. CREATE TRIGGER test1 NO CASCADE AFTER INSERT ON employee REFERENCING NEW AS n FOR EACH ROW MODE DB2SQL WHEN (n.bonus ISNULL) SET n.salary = n.salary + 2000

B. CREATE TRIGGER test1 NO CASCADE BEFORE INSERT ON employee REFERENCING NEW AS n FOR EACH ROW MODE DB2SQL WHEN (n.bonus IS NULL) SET n.salary = n.salary + 2000

C. CREATE TRIGGER test1 AFTER DELETE ON employee REFERENCING OLD_TABLE AS oldemployee FOR EACH STATEMENT MODE DB2SQL DELETE FROM staff WHERE id IN (SELECT empno FROM oldemployee)

D. CREATE TRIGGER test1 NO CASCASE BEFORE DELETE ON employee FOR EACH STATEMENT MODE DB2SQL DELETE FROM staff WHERE id IN (SELECT empnoFROM oldemployee)

Which SQL statement is allowed in a BEFORE trigger?

A. INSERT

B. CALL

C. MERGE

D. UPDATE

Given the function:

What is the output of the statement: VALUES LENGTH(fcn1(' one good day '))?

A. 'one good day'

B. 12

C. ' one good day '

D. 14

Which statement will create a scalar function named FCN1?

A. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3)

B. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)

C. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)

D. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE FUNCTIONfcn1(v1 CHAR(3)) RETURNS CHAR(3)

Which two types of storedprocedures can be developed in IBM Data Studio? (Choose two.)

A. SQL

B. PHP

C. PL/SQL

D. Perl

E. Ruby

Given that CREATEMODULE salesModule statement has been successfully executed, what is the correct method to manage this MODULE?

A. REPLACE MODULE salesModule

B. UPDATE salesModule MODULE FOR

C. ALTER MODULE salesModule

D. CREATE OR REPLACE selesModule UPDATE salesFunc

Which statement is true about the NUMBER data type?

A. In DB2, theNUMBER data type has maximum precision of 31; in Oracle, it has a maximum precision of 38.

B. In DB2, the NUMBER data type is the same as in Oracle, provided the DB2 database was created in Oracle compatibility mode.

C. Declaring a column as NUMBER(10,-2)is valid both in Oracle and in DB2 provided the DB2 database was created in Oracle compatibility mode.

D. Declaring a column as NUMBER(6,8) is valid both in Oracle and in DB2 provided the DB2 database was created in Oracle compatibility mode.

Click the Exhibit button.

Referring to the exhibit, which two statements are correct? (Choose two.)

A. If the EMPLOYEE_TEMP table exists, the execution order is 1,2,3.

B. If the EMPLOYEE_TEMP table does not exist, the execution order is 1,4,3.

C. If the EMPLOYEE_TEMP table exists, the execution order is 4,1,2,3.

D. If the EMPLOYEE_TEMP table does not exist, the execution order is 4,1,3.

E. If the messages table does not exist, the SQL procedure will still compile.

Which code fragment illustrates the proper way to perform error checking in SQL stored procedures?

A. ... IF EXCEPTION < 0 ELSE THEN; NULL; ENDIF; ...

B. ... BEGIN EXCEPTION < 0 ELSE; NULL; END; ...

C. ... IF SQLCODE < 0 THEN RETURN -6786; END IF; ...

D. ... BEGIN IF SQLCODE <0 THEN RETURN -6786 END;