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

質問 1：
A trigger was created using the CREATE TRIGGER statement shown below.

Which statement is true about the INCRS_COMM trigger?
A. This trigger will be executed after a row is inserted into the STAFF table.
B. The trigger will be executed if the STAFF table is populated by a load operation.
C. The trigger will be executed before a row is inserted into the STAFF table.
D. This trigger will increase the COMM value of a newly inserted row by 10 percent.
正解：A

質問 2：
Which code fragment illustrates the proper way to capture and save SQL error handler values so they can be used to control procedure logic?
A. DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLCODE;
B. DECLARE ERROR HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = EXCEPTION;
C. DECLARE ERROR HANDLING SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLERRN;
D. DECLARE ERROR HANDLING FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLMSG;
正解：A

質問 3：
Given the SQL statement shown below: Which privilege allows a user to execute the CREATE TRIGGER statement shown?

A. SYSCTRL authority
B. SELECT and UPDATE privilege on the EMPLOYEE table
C. SELECT and ALTER privilege on the EMPLOYEE table
D. SYSMAINT authority
正解：B

質問 4：
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

質問 5：
Which of the following can be done while debugging a SQL procedure with IBM Data Studio?
A. Edit the procedure and continue.
B. Change the value of any variables used.
C. Re-execute the current statement.
D. Change the order of statements being executed.
正解：B

質問 6：
Given the following procedures:

What would be value of the variable TOTAL_SCORE if the PROCESS_SCORES procedure is called with the value 23 provided as input?
A. 66
B. 0
C. 2323
D. 1010
正解：A

質問 7：
Given the function shown below:

Which statement will execute successfully?
A. SELECT to_upper('Seize the day!')
B. SELECT * FROM TABLE(to_upper_fcn('Seize the day!')) AS T
C. SELECT to_upper('Seize the day!') FROM SYSIBM.SYSDUMMY1;
D. SELECT * FROM to_upper_fcn('Seize the day!')
正解：C

質問 8：
Given the following SQL:

Which of the following statements is true?
A. The cursor declaration requires WITH RETURN TO CALLER clause in order to return a result set.
B. The cursor declaration requires WITH RETURN clause in order to return a result set.
C. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result set.
D. The cursor declaration requires WITH RETURN TO CLIENT clause in order to return a result set.
正解：D

質問 9：
Which two statements are true when working with triggers? (Choose two.)
A. Triggers can be used to enforce data integrity rules.
B. Triggers can be used on Materialized Query Tables.
C. Triggers can be altered.
D. Triggers can be used on Created Temporary Tables.
E. Triggers can be used with both tables and views.
正解：A,E