Home > IBM > DB2 > 000-735

000-735 Exam

DB2 9.5 SQL Procedure Developer

Exam Number/Code : 000-735
Exam Name : DB2 9.5 SQL Procedure Developer
Questions and Answers : 99 Q&As
Update Time: 2013-06-06
Price: ~~$ 119.00~~ $ 69.00
000-735 Hard Copy (PDF)
000-735 Test Engine

000-735

Free 000-735 Demo Download

Test4pass offers free demo for DB2 000-735 exam (DB2 9.5 SQL Procedure Developer). 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.

Exam Description

It is well known that 000-735 exam test is the hot exam of IBM certification. Test4pass offer you all the Q&A of the 000-735 real test . It is the examination of the perfect combination and it will help you pass 000-735 exam at the first time!

Why choose Test4pass 000-735 braindumps

Quality and Value for the 000-735 Exam
100% Guarantee to Pass Your 000-735 Exam
Downloadable, Interactive 000-735 Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.

Test4pass 000-735 Exam Features

Quality and Value for the 000-735 Exam

Test4pass Practice Exams for IBM 000-735 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 000-735 Exam

If you prepare for the exam using our Test4pass testing engine, we guarantee your success in the first attempt. If you do not pass the DB2 000-735 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

IBM 000-735 Downloadable, Printable Exams (in PDF format)

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.

000-735 Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our IBM 000-735 Exam will provide you with free 000-735 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 000-735 Exam:100% Guarantee to Pass Your DB2 exam and get your DB2 Certification.

Hot KeyWords On 000-735 test

How to pass your 000-735 exam

You can search on Search Engine and Find Best IT Certification site: Test4pass.com - Find the Method to succeed 000-735 test,The safer.easier way to get DB2 Certification .

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

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

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

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

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

5. What are two valid DECLARE statements in an SQL procedure? (Choose two.)
A. DECLARE var1 INTEGER;
B. DECLARE var1 DECIMAL [9];
C. DECLARE var1 XML;
D. DECLARE var1 CURRENT DATE;
E. DECLARE var1[10] INTEGER;
Answer: AC

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

7. Which statement will successfully create an SQL procedure that returns the name of the current month?
A. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
DECLARE today DATE;
SET (today = CURRENT_DATE);
SET month = MONTHNAME(today);
END
B. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
DECLARE today DATE;
SELECT (CURRENT_DATE) INTO today;
SET month = MONTHNAME(today);
END
C. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
DECLARE today DATE;
VALUES (CURRENT_DATE) INTO today;
SET month = MONTHNAME(today);
END
D. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
SET month = MONTHNAME(SELECT (CURRENT_DATE))
END
Answer: C

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

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

10. What are two valid special registers? (Choose two.)
A. CURRENT_CLIENT_ACCT
B. CURRENT_SCHEMA
C. CURRENT_PATH
D. CURRENT_DATETIME
E. CURRENT_PARTITION
Answer: BC

11. Which steps must be followed to return a result set from an SQL procedure?
A. 1. Create the procedure using the DYNAMIC RESULT SETS clause.
2. Declare the cursor.
3. Open the cursor in the SQL procedure.
4. Close the cursor.
5. Return to the application.
B. 1. Create the procedure using the DYNAMIC RESULT SETS clause.
2. Declare the cursor using the WITH RETURN clause.
3. Open the cursor in the SQL procedure.
4. Return to the application.
C. 1. Create the procedure using the WITH RETURN clause.
2. Declare the cursor using the DYNAMIC RESULT SETS clause.
3. Open the cursor in the SQL procedure.
4. Return to the application.
D. 1. Create the procedure using the WITH RETURN clause.
2. Declare the cursor using the DYNAMIC RESULT SETS clause.
3. Open the cursor in the SQL procedure.
4. Close the cursor.
Answer: B

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

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

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