Click the Exhibit button.

Referring to theexhibit, how many rows will be returned by the SQL query shown below?

SELECT * FROM TABLE(getnumemployee(21?) AS dSELECT * FROM TABLE(getnumemployee(?21?) AS d

A. 0

B. 1

C. 7

D. 10

A developer wants to code the following statements in an SQL procedure: What order must thesestatements be coded in?

A. 1, 2, 3, 4

B. 2, 4, 3, 1

C. 3, 4, 2, 1

D. 4, 3, 2, 1

If table TAB1 were created as follows:CREATE TABLE tab1 (col1 INT NOT NULL); Which statement illustrates the proper way to define an anchor variable that references column COL1 in table TAB1?

A. DECLARE var1 REFERENCES tab1.col1

B. DECLARE var1 tab1.col1%TYPE

C. DECLARE var1 ANCHOR DATA TYPETO tab1.col1

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

Which tool can be used to get an Explain plan for all SQL statements used in a unit of work?

A. db2look

B. DB2 Command Center

C. Data Studio

D. db2exfmt

Given the following DDL:

What will the SALARY be?

A. salary * 1.03

B. salary * 1.05

C. salary * 1.10

D. salary * 1.50

When considering authorization for CREATE OR REPLACE PROCEDURE statements, the authorization id must have:

A. DBADM authority

B. group privileges on the table or view specified in the procedure

C. IMPLICIT_SCHEMA authority on the database

D. ownership of the existing procedure

Which two statements are true about SQL procedures? (Choose 2)

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

B. SQL procedurescannot be called from triggers.

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

D. SQL procedures support recursion.

E. SQL procedures support the PRINT statement.

When you right-click a SQL procedure in the Data Source Explorer of IBM Data Studio and select Drop from the options menu, what happens?

A. The SQL procedure is temporarily hidden in the Data Source Explorer view.

B. The SQL procedure is removed from the data development project.

C. The SQL procedure is dropped from the database.

D. The SQL procedure is dropped from the database and removed from the data development project.

Given the SQL statement shown below:

Which statement correctly describesthe cursor MY_CURSOR?

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

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

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 can be used to perform positioned delete operations.

Inthe given text below:

What will be the value of the output variable BONUS?

A. 500

B. 1000

C. 5200

D. 5500