IBM C2090-545 - DB2 9.7 SQL Procedure Developer Exam
Page: 3 / 11
Total 55 questions
Question #11 (Topic: Topic 2)
Which statement will create a scalar function named FCN1?
A. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3)
B. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)
C. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)
D. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE FUNCTIONfcn1(v1 CHAR(3)) RETURNS CHAR(3)
Answer: D
Question #12 (Topic: Topic 2)
Which statement is TRUE about associative arrays?
A. Associative array values can be stored in table columns.
B. The index values for an associative array must be a continuous set of integer values.
C. Associative array cannot be a type of a table column.
D. The index data type for an associated array must be an integer.
Answer: C
Question #13 (Topic: Topic 2)
Which of the following can be used to assign multiple values to a row data type variable?
A. A SELECT * statement, a VALUES * statement, or a FETCH * statement.
B. A SELECT INTO statement, a VALUES INTO statement, or a FETCH INTO statement.
C. A DIRECT ASSIGNMENT statement.
D. D. A VARIABLE VALUES statement.
Answer: B
Question #14 (Topic: Topic 2)
ION NO: 54
Which rule applies to the REFERENCING clause in a CREATE TRIGGER statement?
Which rule applies to the REFERENCING clause in a CREATE TRIGGER statement?
A. The OLD correlation-name and the OLD TABLE identifier can be used if the trigger event is an INSERT operation.
B. The scope of each correlation-name and identifierused is the entire trigger definition.
C. The OLD TABLE or NEW TABLE identifiers can be defined in a BEFORE trigger.
D. A NEW correlation-name can be specified more than once for a trigger.
Answer: B
Question #15 (Topic: Topic 2)
Given the following code
[IBM-C2090-545-6.0/IBM-C2090-545-9_2.png]
What would be value of parm2 if the following proc1 called as call proc1(3, ?)?
[IBM-C2090-545-6.0/IBM-C2090-545-9_2.png]
What would be value of parm2 if the following proc1 called as call proc1(3, ?)?
A. 0
B. 10
C. 3
D. 8
Answer: B
