Product Description
Exam Number/Code: 000-735
Exam name: DB2 9.5 SQL Procedure Developer
000-735 test is the important of IBM certifaction. Only you pass the 000-735 exam you could have the chance to get IBM certifaction. To help examinee, Exambible publish the Questions and Answers about 000-735 exam. And the 99 simulation exam are all designed by expert from Exambible. Examinees could have an enough prepare by these simulation exercises and pass the 000-735 test successfully.
Exambible also provide free 000-735 Demo, examinees can download and use before buying 000-735 Q&As, then decide if they need to purchase.
More IBM DB2 Resources
Recommended IBM exams
- IBM 000-M18 exam: IBM Information Mgmt Informix Dyn Svr Tech Sales Mastery v1
- IBM 000-048 exam: Rhapsody in C++
- IBM 000-834 exam: Object Oriented Analysis and Design-Part2(Design)
- IBM LOT-701 exam: IBM Lotus Notes Domino 7 Application Development Update
- IBM 000-016 exam: IBM Tivoli Asset Management for IT V7.1 Implementation
- IBM 000-748 exam: IBM Storage Sales Solutions, Version 8
- IBM 000-793 exam: ibm tivoli security compliance manager v5.1 implementation
- IBM 000-643 exam: rational ucm essentials
- IBM 000-137 exam: Advanced Rational Application Developer v7
- IBM 000-446 exam: IBM Exam 446 Exam - IBM Content Manager OnDemand for i5/OS
- IBM LOT-841 exam: IBM Lotus Notes Domino 8 Implementing +Administering Security
- IBM 000-637 exam: rational-requirements management with use cases-part2
IBM DB2 000-735 Web Demo
This webdemo is just a demo data, only for reference and learning, there is no other purposes.
1.Click the Exhibit button.
CREATE PROCEDURE testproc( IN i1 INT, INOUT i3 INT)
SPECIFIC testproc
BEGIN
SET i3 = i1;
END
CREATE PROCEDURE testproc( IN i1 INT, INOUT i2 INT, INOUT i3 INT)
SPECIFIC testp
BEGIN
SET i3 = i1 * i2;
END
Given that the statements in the exhibits have executed successfully, which solution contains the complete set of
commands that could be used to drop both procedures in the order presented?
A. DROP PROCEDURE testp;
DROP PROCEDURE testp;
B. DROP PROCEDURE testp;
DROP PROCEDURE testproc;
C. DROP SPECIFIC PROCEDURE testproc;
DROP PROCEDURE testproc;
D. DROP PROCEDURE testproc(INT);
DROP PROCEDURE testproc(INT);
Answer: C
3. Which CREATE PROCEDURE statement option should be used if you plan on issuing a DECLARE GLOBAL
TEMPORARY TABLE statement from within the SQL procedure body?
A. CONTAINS SQL
B. READS SQL DATA
C. MODIFIES SQL DATA
D. LANGUAGE SQL
Answer: C
4. Given the statement shown below:
SELECT ROW CHANGE TOKEN FOR dept, RID_BIT (dept)
FROM dept WHERE deptno = 'A00' WITH UR
Which two statements are true? (Choose two.)
A. The statement is selecting two columns from DEPT table.
B. The statement will allow the latest ROW CHANGE TOKEN value to be returned.
C. The statement will allow the earliest ROW CHANGE TOKEN value to be returned.
D. The statement will return a TIMESTAMP value.
E. The statement uses optimistic locking.
Answer: BE
5. What will be the initial value of V_MAX in the declaration statement shown below?
DECLARE v_max DECIMAL(9,2);
A. 0.0
B. 2
C. 9
D. NULL
Answer: D
6. Given the SQL statement shown below:
DECLARE test CURSOR FOR
SELECT hiredate
FROM employee
FOR UPDATE;
Which statement correctly describes the cursor that is created?
A. The cursor will be considered a read-only cursor.
B. The cursor can only be used to perform positioned updates.
C. The cursor can only be used to perform positioned deletes.
D. The cursor can be used to perform positioned updates and deletes.
Answer: D
7. Given the statements shown below:
DECLARE c_dept CURSOR WITH HOLD FOR
SELECT * FROM dept;
OPEN c_dept;
Which two conditions are true? (Choose two.)
A. C_DEPT will remain open after a ROLLBACK.
B. C_DEPT will remain open after a COMMIT.
C. C_DEPT will be returned to the caller of the routine.
D. C_DEPT will be positioned before the next logical row.
E. All locks held by C_DEPT will be released after a COMMIT.
Answer: BD
8. Which statement can be used to define an array of 30 names that have a maximum size of 25 characters each?
A. CREATE TYPE names AS VARCHAR(25) ARRAY[30];
B. CREATE ARRAY names[30] VARCHAR(25);
C. CREATE TYPE names[30] VARCHAR(25);
D. CREATE ARRAY names AS VARCHAR(25);
Answer: A
2. Click the Exhibit button.
CREATE FUNCTION sum(a INT, b INT)
RETURNS INTEGER
SPECIFIC sum_of_2
RETURN a + b;
CREATE FUNCTION sum(a INT, b INT, c INT)
RETURNS INTEGER
SPECIFIC sum_of_3
RETURN a + b + c;
Given the two functions in the exhibit, what is the correct command to invoke the function which calculates the
sum of two numbers from an SQL procedure?
A. SELECT sum_of_2 FROM table1;
B. SELECT sum(2,4,?);
C. SET res_sum = sum(2,6);
D. CALL sum(?,?,?);
Answer: C
