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

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

2. Given the following script:

What would be result from the SELECT * FROM audi1?

A) NLEVEL MESSAGE
5 FROM TRIGGER
B) NLEVEL MESSAGE
2 TEST1
C) NLEVEL MESSAGE 2 FROM TRIGGER
D) NLEVEL MESSAGE 1 FROM TRIGGER

3. Which statement will change the value of a special register?

A) UPDATE SPECIAL REGISTER TIME = ?2:30:00?UPDATE SPECIAL REGISTER TIME = ?2:30:00
B) SET CURRENT TIME = ?2:30:00?SET CURRENT TIME = ?2:30:00
C) UPDATE SPECIAL REGISTER SCHEMA = 'DB2ADMIN'
D) SET CURRENT SCHEMA = 'DB2ADMIN'

4. Given that CREATE MODULE salesModule statement has been successfully executed, what is the correct method to manage this MODULE?

A) UPDATE salesModule MODULE FOR
B) ALTER MODULE salesModule
C) CREATE OR REPLACE selesModule UPDATE salesFunc
D) REPLACE MODULE salesModule

5. Which three optional clauses can be used when creating an external function? (Choose three.)

A) SCRATCHPAD
B) DATABASEINFO
C) NOTEPAD
D) LANGUAGE
E) EXTERNAL NAME

質問と回答：