最新的IBM DB2 9.7 SQL Procedure Developer - C2090-545免費考試真題
問題1
Click the Exhibit button.
How many rows will be in table INFO2 after the procedure MOVE_DATA shown in the exhibit is executed?
Click the Exhibit button.
How many rows will be in table INFO2 after the procedure MOVE_DATA shown in the exhibit is executed?
正確答案: A
問題2
Which statement can be used to declare a variable inside an SQL procedure that can be used to represent a monetary value?
Which statement can be used to declare a variable inside an SQL procedure that can be used to represent a monetary value?
正確答案: B
問題3
Click the Exhibit button.
Referring to the exhibit, which two statements are correct? (Choose two.)
Click the Exhibit button.
Referring to the exhibit, which two statements are correct? (Choose two.)
正確答案: A,B
問題4
Which tool can be used to get an Explain plan for all SQL statements used in a unit of work?
Which tool can be used to get an Explain plan for all SQL statements used in a unit of work?
正確答案: B
問題5
Given the following code
What would be value of parm2 if the following proc1 called as call proc1(3, ?)?
Given the following code
What would be value of parm2 if the following proc1 called as call proc1(3, ?)?
正確答案: B
問題6
In the stored procedure below:
What will the value of the P_ID parameter be if the procedure is invoked and a value of 2 is specified for the START_VALUE parameter?
In the stored procedure below:
What will the value of the P_ID parameter be if the procedure is invoked and a value of 2 is specified for the START_VALUE parameter?
正確答案: D
問題7
Which two DB2 commands can be performed using the ADMIN_CMD procedure? (Choose two.)
Which two DB2 commands can be performed using the ADMIN_CMD procedure? (Choose two.)
正確答案: B,C
問題8
Which tool can be used to get quick static SQL Explain data from packages?
Which tool can be used to get quick static SQL Explain data from packages?
正確答案: A