最新的IBM Assessment: DB2 9.7 SQL Procedure Developer - A2090-545免費考試真題

A. USER TEMPORARY

B. REGULAR

C. SYSTEM TEMPORARY

D. LONG

A. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result set.

B. The cursor declaration requires WITH RETURN TO CLIENT clause in order to return a result set.

C. The cursor declaration requires WITH RETURN clause in order to return a result set.

D. The cursor declaration requires WITH RETURN TO CALLER clause in order to return a result set.

A. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE SCALAR 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 FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE 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. 1000

B. 500

C. 5200

D. 5500

A. db2look

B. db2exfmt

C. DB2 Command Center

D. Data Studio

A. 2

B. 4

C. 1

D. 3