IBM A2090-545 問題集

質問 1：
In the given text below: What will be the value of the output variable BONUS?

A. 1000
B. 5200
C. 500
D. 5500
正解：C

質問 2：
Which CREATE PROCEDURE statement option should be used if you plan on issuing a DECLARE GLOBAL TEMPORARY TABLE statement from within the SQL procedure body?
A. MODIFIES SQL DATA
B. READS SQL DATA
C. LANGUAGE SQL
D. CONTAINS SQL
正解：A

質問 3：
In the code segment shown below: Which statement accurately describes the result?

A. 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.
B. The statement will fail since MERGE is not a supported operator.
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 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

質問 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：
Which of the following statements is true?
A. The result of a GET DIAGNOSTICS statement cannot be assigned to a variable.
B. A DATETIME value can be assigned to a DATE variable.
C. Values cannot be assigned to variables inside ERROR HANDLERS.
D. A TIMESTAMP value can be assigned to a TIME variable.
正解：D

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

質問 7：
Click the Exhibit button.

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

質問 8：
Click the Exhibit button.

An SQL function was created using the statement shown in the exhibit. Assume this function is invoked by executing the SQL statement shown below:
VALUES e_degree(SMALLINT(17))
What will be returned?
A. 1
BACHELOR 1 record(s) selected.
B. SQL0440N No authorized routine named "E_DEGREE" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884
C. 1
UNKNOWN 1 record(s) selected.
D. 1
MASTER 1 record(s) selected.
正解：C