IBM Assessment: DB2 9.7 SQL Procedure Developer - A2090-545 Exam Practice Test

A. LOOP

B. INSERT

C. SIGNAL

D. COMMIT

A. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the READS SQL DATA clause.

B. An SQL procedure cannot invoke procedures built in other languages (e.g., C, Java).

C. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the NO SQL clause.

D. An SQL procedure can invoke the same SQL procedure more than once.

E. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the MODIFIES SQL DATA clause.

A. The OLD TABLE or NEW TABLE identifiers can be defined in a BEFORE trigger.

B. The OLD correlation-name and the OLD TABLE identifier can be used if the trigger event is an INSERT operation.

C. A NEW correlation-name can be specified more than once for a trigger.

D. The scope of each correlation-name and identifier used is the entire trigger definition.

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

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

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

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

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

A. 10

B. 9

C. 1

D. 7

A. BIND RESULT SET WITH PARAMETERS FOR PROCEDURE callee;

B. SELECT * FROM callee;

C. ASSOCIATE RESULT SET LOCATOR( loc1) WITH PROCEDURE callee;

D. INSERT RESULT SET FROM callee INTO CURSOR c1;

A. DECLARE my_gl_var INTEGER DEFAULT 1

B. DEFINE GLOBAL VARIABLE my_gl_var INTEGER

C. CREATE GLOBAL VARIABLE my_gl_var

D. CREATE OR REPLACE VARIABLE my_gl_var INTEGER

A. The index data type for an associated array must be an integer.

B. Associative array values can be stored in table columns.

C. Associative array cannot be a type of a table column.

D. The index values for an associative array must be a continuous set of integer values.

A. External functions cannot return tables.

B. Transactions can be terminated within external functions.

C. Scratchpads can be used to allocate dynamic memory required for multiple function invocations.

D. All cursors opened within an external function should stay open until the database is quiesced.

A. 0

B. 2

C. 3

D. 1