IBM DB2 9.7 SQL Procedure Developer - C2090-545 Free Exam Questions

A. SQL procedures cannot be called from triggers.

B. SQL procedures reside outside of the database for easy portability.

C. SQL procedures support the PRINT statement.

D. SQL procedures support recursion.

E. SQL procedures may return multiple result sets to the caller or to a client application.

A. DECLARE var1 ANCHOR DATA TYPE TO tab1.col1

B. DECLARE var1 tab1.col1%TYPE

C. DECLARE var1 ANCHOR DATA TYPE TO tab1.col1%TYPE

D. DECLARE var1 REFERENCES tab1.col1

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

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

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

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

A. NLEVEL MESSAGE
5 FROM TRIGGER

B. NLEVEL MESSAGE 2 FROM TRIGGER

C. NLEVEL MESSAGE 1 FROM TRIGGER

D. NLEVEL MESSAGE
2 TEST1

A. NULL

B. Error: ID 1 is not valid

C. Application Error

D. SQLSTATE 80000 will be returned, with the custom error message "Error: ID 1 is not valid"

A. RECOVER

B. RUNSTATS

C. CREATE DATABASE

D. RESTORE

E. BACKUP

A. The cursor will not be closed as a consequence of a commit operation.

B. The cursor can be used to perform positioned delete operations.

C. The result table of the cursor is intended to be used as a result set that will be returned from a procedure.

D. The cursor does not have sensitivity to insert, update, or delete operations that are made to rows in the underlying result table.