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

質問 1：
Which statement will create a scalar function named FCN1?
A. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)
B. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3)
C. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3)
D. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)
正解：C

質問 2：
Given the following script:

What would be result from the SELECT * FROM audi1?
A. NLEVEL MESSAGE 1 FROM TRIGGER
B. NLEVEL MESSAGE
2 TEST1
C. NLEVEL MESSAGE 2 FROM TRIGGER
D. NLEVEL MESSAGE
5 FROM TRIGGER
正解：C

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

質問 4：
Which statement is permitted within a scalar user-defined function body?
A. COMMIT
B. SIGNAL
C. INSERT
D. LOOP
正解：B

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

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