最新的IBM Assessment: DB2 9.7 SQL Procedure Developer - A2090-545免費考試真題
When you right-click a SQL procedure in the Data Source Explorer of IBM Data Studio and select Drop from the options menu, what happens?
正確答案: A
If this statement was used to create an SQL procedure named P_EXIT:
What will the return status be?
What will the return status be?
正確答案: D
Assuming C1 and C2 are cursor type variables, which of the following operations cannot be performed?
正確答案: B
Click the Exhibit button.
How many rows will be in table INFO2 after the procedure MOVE_DATA shown in the exhibit is executed?
How many rows will be in table INFO2 after the procedure MOVE_DATA shown in the exhibit is executed?
正確答案: A
Which statement can be used to declare a variable inside an SQL procedure that can be used to represent a monetary value?
正確答案: C
Click the Exhibit button.
If the procedure TEST1 shown in the exhibit is called with the value 'A00' specified for the SOMEID parameter, what is the expected return code?
If the procedure TEST1 shown in the exhibit is called with the value 'A00' specified for the SOMEID parameter, what is the expected return code?
正確答案: C
Given the following DDL:
what will the SALARY be?
what will the SALARY be?
正確答案: D