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

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

（B）An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the MODIFIES SQL DATA clause.

（C）An SQL procedure can invoke the same SQL procedure more than once.

（D）An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the READS SQL DATA clause.

（E）An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the NO SQL clause.

（A）NEWPROD will validate against a new schema.

（B）NEWPROD is marked as inoperative.

（C）NEWPROD will raise an exception.

（D）NEWPROD is dropped.

（A）The cursor declaration requires the WITH RETURN TO CALLER clause in order to return a result set.

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

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

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

（A）IMPLICIT_SCHEMA authority on the database

（B）group privileges on the table or view specified in the procedure

（C）DBADM authority

（D）ownership of the existing procedure

（A）1

（B）10

（C）7

（D）0

（A）This trigger will be executed after a row is inserted into the STAFF table.

（B）The trigger will be executed before a row is inserted into the STAFF table.

（C）This trigger will increase the COMM value of a newly inserted row by 10 percent.

（D）The trigger will be executed if the STAFF table is populated by a load operation.

（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.

（A）UPDATE DB CFG USING CURSOR_SHARING FORCED

（B）UPDATE DB CFG USING STMT_CONC ON

（C）UPDATE DB CFG USING LIT_PARM ON

（D）UPDATE DB CFG USING CURSOR_SHARING ON

（A）Scratchpads can be used to allocate dynamic memory required for multiple function invocations.

（B）External functions cannot return tables.

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

（D）Transactions can be terminated within external functions.

（A）3

（B）1

（C）2

（D）0