最新のA2090-545問題集で試験を準備する

IBM A2090-545 試験概要:

IBM A2090-545 試験シラバストピック:

IBM Assessment: DB2 9.7 SQL Procedure Developer 認定 A2090-545 試験問題：

1. Given the following CREATE PROCEDURE statement: In what order must declarations occur within the lines ap: BEGIN and END ap?

A) Variables, cursors, and condition handlers
B) Condition handlers, cursors, variables
C) Cursors, variables, condition handlers
D) Condition handlers, variables, cursors

2. Which command can be used to optimize static SQL statements containing parameterized queries?

A) SET CURRENT EXPLAIN MODE=REOPT
B) SET CURRENT EXPLAIN MODE=YES
C) SET CURRENT EXPLAIN MODE=EXPLAIN
D) SET CURRENT EXPLAIN MODE=PARAM

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

A) group privileges on the table or view specified in the procedure
B) IMPLICIT_SCHEMA authority on the database
C) DBADM authority
D) ownership of the existing procedure

4. Click the Exhibit button.

Given the user-defined function shown in the exhibit, what will the function return if invoked using the statement shown below?
SELECT check_id(1) FROM SYSIBM.SYSDUMMY1

A) NULL
B) SQLSTATE 80000 will be returned, with the custom error message "Error: ID 1 is not valid"
C) Application Error
D) Error: ID 1 is not valid

5. What is correct use of the MODULE?

A) Encryption and encapsulation
B) Supporting referential integrity
C) Improving performance of transactions
D) Grouping object definitions together that has a common business purpose

質問と回答：