Vendor: IBM
Exam Code: C2190-735
Exam Name: DB2 9.5 SQL Procedure Developer
QUESTION 1
Which statement can be used to declare a variable inside an SQL procedure that can be used to represent a monetary value?
A. DECLARE v_money MONEY;
B. DECLARE v_money DOUBLE;
C. DECLARE v_money DECIMAL(9,2);
D. DECLARE v_money CURRENCY;
Answer: C
QUESTION 2
Click the Exhibit button.
A user-defined function was created using the statement shown in the exhibit. Which additional option can be added to the CREATE FUNCTION statement to tell the optimizer that function does not always return the same results for a given argument value?
A. NO EXTERNAL ACTION
B. NOT FENCED
C. NOT DETERMINISTIC
D. STATIC DISPATCH
Answer: C
QUESTION 3
Which statement describes what must be done to create an SQL procedure that returns a result set?
A. Specify the clause DYNAMIC RESULT SETS 1 in the CREATE PROCEDURE statement; declare
a cursor within the procedure body; open the cursor; exit the procedure without closing the cursor.
B. Specify the clause DYNAMIC RESULT SETS 1 in the CREATE PROCEDURE statement; code a
SELECT statement in the procedure body.
C. Execute the CREATE PROCEDURE statement using the defaults; declare a cursor within the
procedure body; open the cursor; exit the procedure without closing the cursor.
D. Execute the CREATE PROCEDURE statement using the defaults; declare a cursor within the
procedure body; open the cursor; retrieve each row into output variables; close the cursor before
exiting the procedure.
Answer: A
QUESTION 4
A database developer using Data Studio needs to view sample data in a table. Which view should be used?
A. Database Explorer
B. Data Project Explorer
C. Data Output
D. Properties
Answer: A
QUESTION 5
Given the function shown below, what is the output of the statement: VALUES LENGTH(fcn1(‘ one good day ‘))? CREATE FUNCTION fcn1(v1 VARCHAR(50)) RETURNS VARCHAR(50) RETURN LTRIM(RTRIM(v1));
A. ‘one good day’
B. 12
C. ‘ one good day ‘
D. 14
Answer: B
QUESTION 6
In which type of table space must global temporary tables be created?
A. REGULAR
B. LONG
C. SYSTEM TEMPORARY
D. USER TEMPORARY
Answer: D
QUESTION 7
Which statement should be used to declare an array with at most 10 elements of type INTEGER?
A. DECLARE sub_total INTEGER[10];
B. DECLARE sub_total[10] INTEGER;
C. CREATE TYPE sub_total AS INTEGER[10];
D. CREATE TYPE sub_total[10] AS INTEGER;
Answer: C
QUESTION 8
Click the Exhibit button. A developer attempted to create a procedure to determine the oldest employee celebrating a birthday in a particular month by executing the SQL statement shown in the exhibit. Tests show the procedure does not work as planned. What are two ways to make the procedure work as intended? (Choose two.)
A. Add the statement LSE RETURN; before the statement AND IF;
B. Change the statement ALSEIF UCASE(b_month) != UCASE(month) THEN to ALSEIF
UCASE(b_month) = UCASE(month) THEN
C. Add the statement ALSE BREAK; before the statement AND IF;
D. Change the statement ALSEIF UCASE(b_month) != UCASE(month) THEN ITERATE this_loop;
to ALSEIF UCASE(b_month) = UCASE(month) THEN LEAVE this_loop;?
E. Add the statement ALSE CONTINUE; before the statement AND IF;
Answer: AD
QUESTION 9
An SQL procedure uses the statement shown below to insert a record into a global temporary table named TEMP_TABLE INSERT INTO temp_table VALUES (1, ‘a’) Which schema name should be used to qualify the temporary table in the INSERT statement?
A. SESSION
B. DB2ADMIN
C. DB2USER
D. SYSIBM
Answer: A
QUESTION 10
Which two DB2 commands can be performed using the ADMIN_CM rocedure? (Choose two.)
A. RUNSTATS
B. BACKUP
C. RESTORE
D. RECOVER
E. CREATE DATABASE
Answer: AB
If you want to pass IBM C2190-735 successfully, donot missing to read latest lead2pass IBM C2190-735 practice tests.
If you can master all lead2pass questions you will able to pass 100% guaranteed.