IBM C2090-545 - DB2 9.7 SQL Procedure Developer Exam
Page: 1 / 12
Total 55 questions
Question #1 (Topic: Topic 2)
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?
select Drop from the options menu, what happens?
A. The SQL procedure is temporarily hidden in the Data Source Explorer view.
B. The SQL procedure is removed from the data development project.
C. The SQL procedure is dropped from the database.
D. The SQL procedure is dropped from the database and removed from the data development project.
Answer: C
Question #2 (Topic: Topic 2)
: 45
Click the Exhibit button.
[IBM-C2090-545-6.0/IBM-C2090-545-3_2.png]
Referring to the exhibit, which two statements are correct? (Choose two.)
Click the Exhibit button.
[IBM-C2090-545-6.0/IBM-C2090-545-3_2.png]
Referring to the exhibit, which two statements are correct? (Choose two.)
A. If the EMPLOYEE_TEMP table exists, the execution order is 1,2,3.
B. If the EMPLOYEE_TEMP table does not exist, the execution order is 1,4,3.
C. If the EMPLOYEE_TEMP table exists, the execution order is 4,1,2,3.
D. If the EMPLOYEE_TEMP table does not exist, the execution order is 4,1,3.
E. If the messages table does not exist, the SQL procedure will still compile.
Answer: A,B
Question #3 (Topic: Topic 2)
Which object is used to return a result set from an SQLprocedure?
A. Temporary table
B. Array
C. Cursor
D. Scratchpad
Answer: C
Question #4 (Topic: Topic 2)
Given the following procedures:
[IBM-C2090-545-6.0/IBM-C2090-545-4_2.png]
What would be value of the variable TOTAL_SCORE if the PROCESS_SCORES
procedure is called with the value 23 provided as input?
[IBM-C2090-545-6.0/IBM-C2090-545-4_2.png]
What would be value of the variable TOTAL_SCORE if the PROCESS_SCORES
procedure is called with the value 23 provided as input?
A. 0
B. 6B.6
C. 23C.23
D. 10D.10
Answer: B
Question #5 (Topic: Topic 2)
Given the function shown below:
[IBM-C2090-545-6.0/IBM-C2090-545-5_2.png]
Which statement will execute successfully?
[IBM-C2090-545-6.0/IBM-C2090-545-5_2.png]
Which statement will execute successfully?
A. SELECT to_upper('Seize the day!')
B. SELECT * FROM to_upper_fcn('Seize the day!')
C. SELECT to_upper('Seize the day!') FROM SYSIBM.SYSDUMMY1;
D. SELECT * FROM TABLE(to_upper_fcn('Seize the day!')) AS T
Answer: C
