IBM A2090-545 問題集

質問 1：
A developer wants to code the following statements in an SQL procedure:

What order must these statements be coded in?
A. 4, 3, 2, 1
B. 3, 4, 2, 1
C. 2, 4, 3, 1
D. 1, 2, 3, 4
正解：C

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

質問 3：
Click the Exhibit button.

Which statement correctly describes the result of the FOR loop shown in the exhibit?
A. FULLNAME is set to the last name of the employee, followed by a comma, the first name, a blank space, and the middle initial for each row. Each value for FULLNAME is inserted into table TNAMES in alphabetical order.
B. FULLNAME is set to the last name of the employee, followed by a comma, the first name, a blank space, and the middle initial. Only the first value for FULLNAME is inserted into table TNAMES.
C. FULLNAME is set to the last name of the employee, followed by a comma, the first name, a blank space, and the middle initial. Only the last value for FULLNAME is inserted into table TNAMES.
D. FULLNAME is set to the last name of the employee, followed by a comma, the first name, a blank space, and the middle initial for each row. Each value for FULLNAME is inserted into table TNAMES.
正解：D

質問 4：
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 FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLMSG;
D. DECLARE ERROR HANDLING SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLERRN;
正解：A

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

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

質問 6：
Which command can be used to optimize static SQL statements containing parameterized queries?
A. SET CURRENT EXPLAIN MODE=PARAM
B. SET CURRENT EXPLAIN MODE=YES
C. SET CURRENT EXPLAIN MODE=EXPLAIN
D. SET CURRENT EXPLAIN MODE=REOPT
正解：D

質問 7：
Which statement will successfully create an SQL procedure that returns the name of the current month?
A. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
SET month = MONTHNAME(SELECT (CURRENT_DATE))
END
B. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
DECLARE today DATE;
SELECT (CURRENT_DATE) INTO today;
SET month = MONTHNAME(today);
END
C. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
DECLARE today DATE;
VALUES (CURRENT_DATE) INTO today;
SET month = MONTHNAME(today);
END
D. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
DECLARE today DATE;
SET (today = CURRENT_DATE);
SET month = MONTHNAME(today);
END
正解：C

質問 8：
Click the Exhibit button.

The table and triggers in the exhibit have been created successfully, when the statements shown below are executed.
INSERT INTO emp_hours VALUES('KAY', '9:00', '17:00');
INSERT INTO emp_hours (emp_name, starting) VALUES('BILL', '9:00');
What is the result?
A. Table EMP_HOURS will contain these rows: KAY 9:00:00 AM 5:00:00 PM BILL 9:00:00 AM
B. Table EMP_HOURS will contain these rows: KAY 9:00:00 AM 5:00:00 PM BILL 9:00:00 AM 10:00:00 AM
C. Table EMP_HOURS will contain this row: BILL 9:00:00 AM 17:00:00 PM
D. Table EMP_HOURS will contain this row: BILL 9:00:00 AM
正解：B