Certinside – IT certifications Blog

About Visualexams

Visualexams also called CI is a popular IBM Certifications dumps provider. We have prepared highest quality SimExam 000-735 Study Guide and best online 000-735 Dumps for IT certification professionals to pass IBM 000-735 Exam for sure. Different from Testking or Testinside 000-735 download, Visualexams 000-735 Questions and Answers are so thorough and comprehensive that nearly every field and category of content networking has been covered to assure IT professionals of obtaining IBM Certification successfully.

Visualexams 000-735 Exam Detail

Exam Number/Code : 000-735

Exam Name : DB2 9.5 SQL Procedure Developer

Questions and Answers : 99

Update Time: 2009-10-28

　
　
Exam : IBM 000-735
Title : DB2 9.5 SQL Procedure Developer

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

Our 000-735 exam questions download from the examination center.And our Exam 000-735 Preparation Material provides you everything you will need to take your 000-735 Exam. The 000-735 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

Free 000-735 Demo Download

Visualexams offers 000-735 dumps download and 000-735 study guide download. You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.