A2090-545無料問題集「IBM Assessment: DB2 9.7 SQL Procedure Developer」

質問 1

Which statement is TRUE about associative arrays?

（A）Associative array values can be stored in table columns.

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

（C）The index values for an associative array must be a continuous set of integer values.

（D）Associative array cannot be a type of a table column.

正解：D 解答を投票する

質問 2

Which two statements are true? (Choose two.)

（A）The SQL procedure is always associated with a package that contains access paths of SQL statements in the procedure.

（B）SQL procedures can contain static and/or dynamic SQL statements.

（C）SQL procedures can have COMMIT or ROLLBACK within atomic compound statements.

（D）It is necessary for an end-user to have object level privileges if that user has execute privileges on an associated package and the SQL procedure.

（E）Static or dynamic SQL execution is not associated with a package.

正解：A、B 解答を投票する

質問 3

Click the Exhibit button.

If the procedure TEST1 shown in the exhibit is called with the value 'A00' specified for the SOMEID parameter, what is the expected return code?

（A）-2

（B）-1

（C）0

（D）-3

正解：C 解答を投票する

質問 4

Click the Exhibit button.

A trigger was created as shown in the exhibit.
The UPDATE statement shown below is executed. UPDATE dept SET sales_id = '300' WHERE sales_id = '200'
How many row(s) are updated in the EMPLOYEE table?

（A）3

（B）1

（C）2

（D）0

正解：B 解答を投票する

質問 5

Which option is used when declaring a global temporary table that will keep its data across transaction boundaries?

（A）ON ROLLBACK PRESERVE ROWS

（B）ON ROLLBACK DELETE ROWS

（C）ON COMMIT DELETE ROWS

（D）ON COMMIT PRESERVE ROWS

正解：D 解答を投票する

質問 6

Which object is used to return a result set from an SQL procedure?

（A）Temporary table

（B）Array

（C）Cursor

（D）Scratchpad

正解：C 解答を投票する

質問 7

The CREATE PROCEDURE statement shown below was executed against a database called MYDB.
CREATE PROCEDURE myschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3 SMALLINT)
BEGIN
SET p2 = 'abc';
END
Which two CREATE PROCEDURE statements, when executed against the same database, will succeed? (Choose two.)

（A）CREATE PROCEDURE myschema.proc1(IN p1 NUMBER, OUT p2 NUMBER, OUT p3 NUMBER) BEGIN SET p2 = 'abc'; END

（B）CREATE PROCEDURE myschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER, OUT p3
SMALLINT)
BEGIN
SET p2 = 123;
END

（C）CREATE PROCEDURE myschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3
CHAR(4))
BEGIN
SET p2 = 'abc';
END

（D）CREATE PROCEDURE myschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER)
BEGIN
SET p2 = 123;
END

（E）CREATE PROCEDURE otherschema.proc1(IN p1 CHAR(4), OUT p2 CHAR(4), OUT p3 CHAR(4)) BEGIN SET p2 = 'abc'; END

正解：D、E 解答を投票する

A2090-545 無料問題集「IBM Assessment: DB2 9.7 SQL Procedure Developer」

弊社を連絡する

関連リンク

トップ試験