最新なIBM 000-545問題集（115題）、真実試験の問題を全部にカバー！

質問 1：
Given that CREATE MODULE salesModule statement has been successfully executed, what is the correct method to manage this MODULE?
A. REPLACE MODULE salesModule
B. CREATE OR REPLACE selesModule UPDATE salesFunc
C. UPDATE salesModule MODULE FOR
D. ALTER MODULE salesModule
正解：D

質問 2：
Click the Exhibit button.

A user-defined function was created using the statement shown in the exhibit. Which additional option can be added to the CREATE FUNCTION statement to tell the optimizer that the function does not always return the same results for a given argument value?
A. STATIC DISPATCH
B. NO EXTERNAL ACTION
C. NOT FENCED
D. NOT DETERMINISTIC
正解：D

質問 3：
Click the Exhibit button.

Which statement is true about the CASE statement shown in the exhibit?
A. An employee with a rating of 1 receives a 10% salary increase.
B. An employee with a rating of 3 receives no salary increase.
C. All employees will receive at least a 5% salary increase.
D. An employee with a rating of 2 receives a 3% salary increase.
正解：A

質問 4：
In the code segment shown below:

Which statement accurately describes the result?
A. The statement will fail since MERGE is not a supported operator.
B. For activities whose description has not changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
C. For activities whose description has changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
D. For activities whose description has changed, update the description in the ACTIVITY table. For new activities, insert into the ACTIVITIES table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
正解：C

質問 5：
Given the following SQL:

Which statement is incorrect?
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 clause in order to return a result set.
C. The cursor declaration requires the WITH RETURN TO CLIENT 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.
正解：D