000-545問題集、IBM実際の試験問題

質問 1

Which statement is TRUE about associative arrays?

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

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

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

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

正解: C

質問 2

Which statement will create a scalar function named FCN1?

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

質問 3

Which statement is TRUE about associative arrays?

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

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

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

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

正解: C

質問 4

Click the Exhibit button.

How many rows will be in table INFO2 after the procedure MOVE_DATA shown in the exhibit is executed?

A. 4

B. 5

C. 0

D. 7

正解: A

質問 5

Click the Exhibit button.
Referring to the exhibit, 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. 1

B. 10

C. 0

D. 7

正解: D

質問 6

Click the Exhibit button.

The procedure TEST5 shown in the exhibit was invoked. How many rows will be added to the DEPT table?

A. 3

B. 4

C. 1

D. 2

正解: A

質問 7

Which SQL statement is allowed in a BEFORE trigger?

A. MERGE

B. INSERT

C. CALL

D. UPDATE

正解: C

質問 8

Which statement can be used to define variable that can be shared between procedures?

A. DEFINE GLOBAL VARIABLE my_gl_var INTEGER

B. DECLARE my_gl_var INTEGER DEFAULT 1

C. CREATE GLOBAL VARIABLE my_gl_var

D. CREATE OR REPLACE VARIABLE my_gl_var INTEGER

正解: D

質問 9

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

A. Ruby

B. SQL

C. PL/SQL

D. Perl

E. PHP

正解: B,C

IBM DB2 9.7 SQL Procedure Developer - 000-545 模擬練習