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

質問 1：
Which steps must be followed to return a result set from an SQL procedure?
A. 1. Create the procedure using the WITH RETURN clause.
2.Declare the cursor using the DYNAMIC RESULT SETS clause.
3.Open the cursor in the SQL procedure.
4.Close the cursor.
B. 1. Create the procedure using the WITH RETURN clause.
2.Declare the cursor using the DYNAMIC RESULT SETS clause.
3.Open the cursor in the SQL procedure.
4.Return to the application.
C. 1. Create the procedure using the DYNAMIC RESULT SETS clause.
2.Declare the cursor using the WITH RETURN clause.
3.Open the cursor in the SQL procedure.
4.Return to the application.
D. 1. Create the procedure using the DYNAMIC RESULT SETS clause.
2.Declare the cursor.
3.Open the cursor in the SQL procedure.
4.Close the cursor.
5.Return to the application.
正解：C

質問 2：
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. SQL0440N No authorized routine named "E_DEGREE" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884
B. 1
BACHELOR 1 record(s) selected.
C. 1
MASTER 1 record(s) selected.
D. 1
UNKNOWN 1 record(s) selected.
正解：D

質問 3：
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
DECLARE today DATE;
SET (today = CURRENT_DATE);
SET month = MONTHNAME(today);
END
B. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
DECLARE today DATE;
VALUES (CURRENT_DATE) INTO today;
SET month = MONTHNAME(today);
END
C. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
SET month = MONTHNAME(SELECT (CURRENT_DATE))
END
D. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
DECLARE today DATE;
SELECT (CURRENT_DATE) INTO today;
SET month = MONTHNAME(today);
END
正解：B

質問 4：
Which statement is TRUE about associative arrays?
A. Associative array cannot be a type of a table column.
B. The index data type for an associated array must be an integer.
C. Associative array values can be stored in table columns.
D. The index values for an associative array must be a continuous set of integer values.
正解：A

質問 5：
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.
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 in alphabetical order.
正解：A