IBM meilleur examen 000-545, questions et réponses

On peut télécharger quelques parties de Q&A gratuites dans le site Pass4Test à propos de test Certification IBM 000-545. Vous pouvez tester notre fiabilité via le démo. Choisir Pass4Test, c'est-à-dire que vous êtes proche d'un pic ensuite de l'Industrie IT.

L'équipe de Pass4Test rehcerche la Q&A de test certification IBM 000-545 en visant le test IBM 000-545. Cet outil de formation peut vous aider à se préparer bien dans une courte terme. Vous vous renforcerez les connaissances de base et même prendrez tous essences de test Certification. Pass4Test vous assure à réussir le test IBM 000-545 sans aucune doute.

Pass4Test a une équipe se composant des experts qui font la recherche particulièrement des exercices et des Q&As pour le test certification IBM 000-545, d'ailleurs ils peuvent vous proposer à propos de choisir l'outil de se former en ligne. Si vous avez envie d'acheter une Q&A de Pass4Test, Pass4Test vous offrira de matériaux plus détailés et plus nouveaux pour vous aider à approcher au maximum le test réel. Assurez-vous de choisir le Pass4Test, vous réussirez 100% le test IBM 000-545.

Maintenant, beaucoup de professionnels IT prennent un même point de vue que le test IBM 000-545 est le tremplin à surmonter la pointe de l'Industrie IT. Beaucoup de professionnels IT mettent les yeux au test Certification IBM 000-545.

La population de la Certification IBM 000-545 est très claire dans l'Industrie IT. Pass4Test se contribue à vous aider à réussir le test, de plus, un an de la mise à jour gratuite pendant est gratuite pour vous. Pass4Test sera le catalyseur de la réalisation de votre rêve. Pour le succès demain, Pass4Test est votre von choix. Vous serez le prochain talent de l'Indutrie IT sous l'aide de Pass4Test.

Code d'Examen: 000-545
Nom d'Examen: IBM (DB2 9.7 SQL Procedure Developer)
Questions et réponses: 109 Q&As

Beaucoup de travailleurs dans l'Industrie IT peut obenir un meilleur travail et améliorer son niveau de vie à travers le Certificat IBM 000-545. Mais la majorité des candidats dépensent beaucoup de temps et d'argent pour préparer le test, ça ne coûte pas dans cette société que le temps est tellement précieux. Pass4Test peut vous aider à économiser le temps et l'effort pendant le cours de la préparation du test IBM 000-545. Choisir le produit de Pass4Test particulier pour le test Certification IBM 000-545 vous permet à réussir 100% le test. Votre argent sera tout rendu si malheureusement vous ne passez pas le test.

000-545 Démo gratuit à télécharger: http://www.pass4test.fr/000-545.html

NO.1 What is a reason to use SQL procedures in DB2?
A. to use different programming languages B. to reduce code sharing
C. to move business logic rules into the database
D. to eliminate the need for testing
Answer: C

IBM examen   000-545 examen   000-545

NO.2 In the stored procedure below: What will the value of the P_ID parameter be if the procedure is
invoked and a value of 2 is specified for the START_VALUE parameter?
A. 1
B. 2
C. 3
D. 4
Answer: C

IBM   certification 000-545   000-545   000-545 examen

NO.3 The CREATE OR REPLACE PROCEDURE statement is similar semantically to which of the following
combined statements?
A. DROP and CREATE PROCEDURE
B. ALTER and CREATE PROCEDURE
C. UPDATE and CREATE PROCEDURE
D. DROP and ALTER PROCEDURE
Answer: A

certification IBM   certification 000-545   certification 000-545   000-545   000-545

NO.4 A developer needs to create a user-defined function that will return a list of employees who work in a
particular department. Which statement will successfully create a function that meets this objective?
A. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE LANGUAGE SQL
READS SQL DATA RETURN SELECT empno, lastname AS l_name, firstnme AS f_name FROM
employee WHERE employee.workdept = dept_employees.deptno
B. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE DYNAMIC RESULT
SETS 1 LANGUAGE SQL READS SQL DATA DECLARE emp_info CURSOR WITH RETURN FOR
SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE
employee.workdept = dept_employees.deptno OPEN emp_info; RETURN
C. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE (empno CHAR(6),
l_nameVARCHAR(15), f_nameVARCHAR(12)) LANGUAGE SQL READS SQL DATA RETURN SELECT
empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE employee.workdept =
dept_employees.deptno
D. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE (empno CHAR(6),
l_nameVARCHAR(15), f_nameVARCHAR(12)) DYNAMIC RESULT SETS 1 LANGUAGE SQL READS
SQL DATA DECLARE emp_info CURSOR WITH RETURN FOR
SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE
employee.workdept = dept_employees.deptno OPEN emp_info; RETURN
Answer: C

IBM   certification 000-545   000-545   000-545

NO.5 Given the following SQL:
Which statement is incorrect?
A. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result
set.
B. The cursor declaration requires the WITH RETURN TO CLIENT clause in order to return a result set.
C. The cursor declaration requires the WITH RETURN TO CALLER clause in order to return a result set.
D. The cursor declaration requires the WITH RETURN clause in order to return a result set.
Answer: A

certification IBM   000-545   certification 000-545   000-545   certification 000-545

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

IBM   000-545 examen   000-545   000-545

NO.7 Click on the Exhibit button.
Referring to the exhibit, what is the OUT_PHONENUMBERS result set when the SQL procedure is
invoked by the call statement shown below? CALL
find_customers(ARRAY[?16-305-3745? ?05-416-4565? ?16-305-3746? '905-414-4566'], ?16??)
A. [?16-305-3745??05-416-4565? ?16-305-3746']
B. [?16-305-3745??05-416-4565? ?16-305-3746? '905-414-4566']
C. [?05-416-4565? '905-414-4566']
D. [?16-305-3745? ?16-305-3746[?16-305-3745? ?16-305-3746?
Answer: D

certification IBM   000-545   000-545   000-545 examen   certification 000-545

NO.8 Which SQL procedure declaration is coded correctly?
A. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE
EXIT HANDLER FOR SQLEXCEPTION SET commission = 0; DECLARE my_cur CURSOR FOR
SELECT * FROM employee; DECLARE a DOUBLE; SET a = .06 * salary; SET commission = a; END
B. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE
EXIT HANDLER FOR SQLEXCEPTION SET commission = 0; DECLARE a DOUBLE; DECLARE my_cur
CURSOR FOR SELECT * FROM employee; SET a = .06 * salary; SET commission = a; END
C. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE a
DOUBLE; DECLARE EXIT HANDLER FOR SQLEXCEPTION SET commission = 0; DECLARE my_cur
CURSOR FOR SELECT * FROM employee; SET a = .06 * salary; SET commission = a; END
D. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE a
DOUBLE; DECLARE my_cur CURSOR FOR SELECT * FROM employee; DECLARE EXIT HANDLER
FOR SQLEXCEPTION
SET commission = 0; SET a = .06 * salary; SET commission = a; END
Answer: D

IBM   000-545 examen   certification 000-545   000-545

NO.9 If this statement was used to create an SQL procedure named P_EXIT:
A. 10
B. 20
C. 99
D. NULL
Answer: C

IBM examen   000-545 examen   000-545

NO.10 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 the 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

IBM   certification 000-545   000-545

NO.11 Which statement is permitted within a scalar user-defined function body?
A. COMMIT
B. INSERT
C. SIGNAL
D. LOOP
Answer: C

certification IBM   000-545   000-545   000-545 examen   certification 000-545

NO.12 Given the following SQL:
Which of the following statements is true?
A. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result
set.
B. The cursor declaration requires WITH RETURN TO CLIENT clause in order to return a result set.
C. The cursor declaration requires WITH RETURN TO CALLER clause in order to return a result set.
D. The cursor declaration requires WITH RETURN clause in order to return a result set.
Answer: B

certification IBM   000-545   certification 000-545   000-545

NO.13 A developer wants to code the following statements in an SQL procedure:
A. 1, 2, 3, 4
B. 2, 4, 3, 1
C. 3, 4, 2, 1
D. 4, 3, 2, 1
Answer: B

IBM   000-545   certification 000-545   certification 000-545

NO.14 Which procedure demonstrates the correct use of dynamic SQL?
A. CREATE PROCEDURE update_count1 (INnew_count INTEGER, IN item_code INTEGER) BEGIN
DECLARE v_dynSQL VARCHAR(200); SET v_dynSQL = 'UPDATE stock SET quantity_on_hand=?
WHERE item_number=?'; PREPARE v_stmt1 FROM v_dynSQL; EXECUTE v_stmt1 USING new_count,
item_code; END
B. CREATE PROCEDURE update_count2 (INtab_name VARCHAR(128), IN new_count INTEGER, IN
item_code INTEGER) BEGIN DECLARE v_dynSQL VARCHAR(200); SET v_dynSQL = 'UPDATE ? SET
quantity_on_hand=? WHERE item_number=?'; PREPARE v_stmt1 FROM v_dynSQL; EXECUTE
v_stmt1 USING tab_name, new_count, item_code; END
C. CREATE PROCEDURE update_count4 (INtab_name VARCHAR(128), IN col_name1
VARCHAR(128), IN col_name2 VARCHAR(128), IN new_countINTEGER, IN item_code INTEGER)
BEGIN
DECLARE v_dynSQL VARCHAR(200); SET v_dynSQL = 'UPDATE ? SET ?=? WHERE ?=?'; PREPARE
v_stmt1 FROM v_dynSQL; EXECUTE v_stmt1 USING tab_name, col_name1, new_count, col_name2,
item_code; END
D. CREATE PROCEDURE update_count5 (INnew_count INTEGER, IN item_code INTEGER) BEGIN
DECLARE v_dynSQL VARCHAR(200); DECLARE v_col_name VARCHAR(128); SET v_col_name =
'item_number'; SET v_dynSQL = 'UPDATE stock SET quantity_on_hand=? WHERE ?=?'; PREPARE
v_stmt1 FROM v_dynSQL; EXECUTE v_stmt1 USING new_count, v_col_name, item_code; END
Answer: A

IBM   000-545   certification 000-545

NO.15 Which statement correctly describes characteristics of external functions?
A. External functions cannot return tables.
B. All cursors opened within an external function should stay open until the database isquiesced.
C. Scratchpads can be used to allocate dynamic memory required for multiple function invocations.
D. Transactions can be terminated within external functions.
Answer: C

IBM   000-545   000-545   000-545 examen

NO.16 The CREATE PROCEDURE statement shown below was executed against a database called MYDB.
CREATE PROCEDURE myschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3 SMALLINT)
BEGIN SET p2 = 'abc'; END Which two CREATE PROCEDURE statements, when executed against the
same database, will succeed? (Choose two.)
A. CREATE PROCEDUREmyschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER) BEGIN SET p2 = 123;
END
B. CREATE PROCEDUREmyschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3 CHAR(4))
BEGIN SET p2 = 'abc'; END
C. CREATE PROCEDUREmyschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER, OUT p3 SMALLINT)
BEGIN SET p2 = 123; END
D. CREATE PROCEDUREotherschema.proc1(IN p1 CHAR(4), OUT p2 CHAR(4), OUT p3 CHAR(4))
BEGIN SET p2 = 'abc'; END
E. CREATE PROCEDUREmyschema.proc1(IN p1 NUMBER, OUT p2 NUMBER, OUT p3 NUMBER)
BEGIN SET p2 = 'abc';END
Answer: A,D

IBM examen   000-545   000-545 examen   000-545   000-545 examen   000-545 examen

NO.17 Which three optional clauses can be used when creating an external function? (Choose three.)
A. SCRATCHPAD
B. NOTEPAD
C. LANGUAGE
D. EXTERNAL NAME
E. DATABASEINFO
Answer: A,C,D

certification IBM   000-545   000-545   certification 000-545

NO.18 In the function shown below:
A. SELECT * FROMTABLE(fcn1('B01'))
B. SELECTTABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1
C. SELECT * FROMfcn1('B01')
D. SELECTfcn1('B01') FROM SYSIBM.SYSDUMMY1
Answer: A

IBM   000-545   000-545 examen   certification 000-545   000-545 examen   000-545

NO.19 Click the Exhibit button.
Referring to the exhibit, how many rows will be returned by the SQL query shown below? SELECT *
FROM TABLE(getnumemployee(21?) AS dSELECT * FROM TABLE(getnumemployee(?21?) AS d
A.0
B.1
C.7
D.10
Answer: C

certification IBM   000-545 examen   000-545 examen   000-545

NO.20 Given the two SQL procedures shown below: What is the expected output if procedure S1 is invoked
with the value 1 provided for parameter V1?
A. NULL
B. 2
C. 5
D. 7
Answer: D

IBM examen   000-545 examen   certification 000-545   000-545 examen

La Q&A lancée par Pass4Test est bien poupulaire. Pass4Test peut non seulement vous permettre à appendre les connaissances professionnelles, et aussi les expériences importantes résumées par les spécialistes dans l'Industrie IT. Pass4Test est un bon fournisseur qui peut répondre une grande demande des candidats. Avec l'aide de Pass4Test, vous aurez la confiance pour réussir le test. Vous n'aurez pas aucune raison à refuser le Pass4Test.

Le matériel de formation de l'examen de meilleur IBM 000-545

Le test simulation offert par Pass4Test est bien proche du test réel. Vous pouvez apprendre tous essences d'un test réel à courte terme avec l'aide de Pass4Test. Pass4Test peut vous assurer le succès 100% de test IBM 000-545.

Le succès n'est pas loin de vous si vous choisissez Pass4Test. Vous allez obtenir le Certificat de IBM 000-545 très tôt. Pass4Test peut vous permettre à réussir 100% le test IBM 000-545, de plus, un an de service en ligne après vendre est aussi gratuit pour vous.

Code d'Examen: 000-545
Nom d'Examen: IBM (DB2 9.7 SQL Procedure Developer)
Questions et réponses: 109 Q&As

Pass4Test est un site de vous ramener au succès. Pass4Test peut vous aider à promouvoir les connaissances essentielles pour le test IBM 000-545 et passer le test à la première fois.

Peut-être vous voyez les guides d'études similaires pour le test IBM 000-545, mais nous avons la confiance que vous allez nous choisir finalement grâce à notre gravité d'état dans cette industrie et notre profession. Pass4Test se contribue à amérioler votre carrière. Vous saurez que vous êtes bien préparé à passer le test IBM 000-545 lorsque vous choisissez la Q&A de Pass4Test. De plus, un an de service gratuit en ligne après vendre est aussi disponible pour vous.

000-545 Démo gratuit à télécharger: http://www.pass4test.fr/000-545.html

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

certification IBM   000-545 examen   000-545   certification 000-545

NO.2 Which procedure demonstrates the correct use of dynamic SQL?
A. CREATE PROCEDURE update_count1 (INnew_count INTEGER, IN item_code INTEGER) BEGIN
DECLARE v_dynSQL VARCHAR(200); SET v_dynSQL = 'UPDATE stock SET quantity_on_hand=?
WHERE item_number=?'; PREPARE v_stmt1 FROM v_dynSQL; EXECUTE v_stmt1 USING new_count,
item_code; END
B. CREATE PROCEDURE update_count2 (INtab_name VARCHAR(128), IN new_count INTEGER, IN
item_code INTEGER) BEGIN DECLARE v_dynSQL VARCHAR(200); SET v_dynSQL = 'UPDATE ? SET
quantity_on_hand=? WHERE item_number=?'; PREPARE v_stmt1 FROM v_dynSQL; EXECUTE
v_stmt1 USING tab_name, new_count, item_code; END
C. CREATE PROCEDURE update_count4 (INtab_name VARCHAR(128), IN col_name1
VARCHAR(128), IN col_name2 VARCHAR(128), IN new_countINTEGER, IN item_code INTEGER)
BEGIN
DECLARE v_dynSQL VARCHAR(200); SET v_dynSQL = 'UPDATE ? SET ?=? WHERE ?=?'; PREPARE
v_stmt1 FROM v_dynSQL; EXECUTE v_stmt1 USING tab_name, col_name1, new_count, col_name2,
item_code; END
D. CREATE PROCEDURE update_count5 (INnew_count INTEGER, IN item_code INTEGER) BEGIN
DECLARE v_dynSQL VARCHAR(200); DECLARE v_col_name VARCHAR(128); SET v_col_name =
'item_number'; SET v_dynSQL = 'UPDATE stock SET quantity_on_hand=? WHERE ?=?'; PREPARE
v_stmt1 FROM v_dynSQL; EXECUTE v_stmt1 USING new_count, v_col_name, item_code; END
Answer: A

IBM examen   certification 000-545   000-545   000-545

NO.3 A developer wants to code the following statements in an SQL procedure:
A. 1, 2, 3, 4
B. 2, 4, 3, 1
C. 3, 4, 2, 1
D. 4, 3, 2, 1
Answer: B

IBM examen   000-545   certification 000-545   000-545   certification 000-545   000-545 examen

NO.4 Which three optional clauses can be used when creating an external function? (Choose three.)
A. SCRATCHPAD
B. NOTEPAD
C. LANGUAGE
D. EXTERNAL NAME
E. DATABASEINFO
Answer: A,C,D

IBM examen   000-545   000-545 examen   certification 000-545   certification 000-545

NO.5 Click on the Exhibit button.
Referring to the exhibit, what is the OUT_PHONENUMBERS result set when the SQL procedure is
invoked by the call statement shown below? CALL
find_customers(ARRAY[?16-305-3745? ?05-416-4565? ?16-305-3746? '905-414-4566'], ?16??)
A. [?16-305-3745??05-416-4565? ?16-305-3746']
B. [?16-305-3745??05-416-4565? ?16-305-3746? '905-414-4566']
C. [?05-416-4565? '905-414-4566']
D. [?16-305-3745? ?16-305-3746[?16-305-3745? ?16-305-3746?
Answer: D

IBM examen   000-545 examen   certification 000-545   certification 000-545   certification 000-545

NO.6 The CREATE PROCEDURE statement shown below was executed against a database called MYDB.
CREATE PROCEDURE myschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3 SMALLINT)
BEGIN SET p2 = 'abc'; END Which two CREATE PROCEDURE statements, when executed against the
same database, will succeed? (Choose two.)
A. CREATE PROCEDUREmyschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER) BEGIN SET p2 = 123;
END
B. CREATE PROCEDUREmyschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3 CHAR(4))
BEGIN SET p2 = 'abc'; END
C. CREATE PROCEDUREmyschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER, OUT p3 SMALLINT)
BEGIN SET p2 = 123; END
D. CREATE PROCEDUREotherschema.proc1(IN p1 CHAR(4), OUT p2 CHAR(4), OUT p3 CHAR(4))
BEGIN SET p2 = 'abc'; END
E. CREATE PROCEDUREmyschema.proc1(IN p1 NUMBER, OUT p2 NUMBER, OUT p3 NUMBER)
BEGIN SET p2 = 'abc';END
Answer: A,D

IBM   000-545 examen   000-545 examen   000-545

NO.7 In the stored procedure below: What will the value of the P_ID parameter be if the procedure is
invoked and a value of 2 is specified for the START_VALUE parameter?
A. 1
B. 2
C. 3
D. 4
Answer: C

certification IBM   000-545   000-545   certification 000-545   certification 000-545   certification 000-545

NO.8 If this statement was used to create an SQL procedure named P_EXIT:
A. 10
B. 20
C. 99
D. NULL
Answer: C

IBM examen   000-545   000-545   000-545

NO.9 Click the Exhibit button.
Referring to the exhibit, how many rows will be returned by the SQL query shown below? SELECT *
FROM TABLE(getnumemployee(21?) AS dSELECT * FROM TABLE(getnumemployee(?21?) AS d
A.0
B.1
C.7
D.10
Answer: C

IBM   certification 000-545   certification 000-545   000-545 examen   certification 000-545

NO.10 Which statement correctly describes characteristics of external functions?
A. External functions cannot return tables.
B. All cursors opened within an external function should stay open until the database isquiesced.
C. Scratchpads can be used to allocate dynamic memory required for multiple function invocations.
D. Transactions can be terminated within external functions.
Answer: C

IBM examen   000-545 examen   000-545   000-545   000-545

NO.11 In the function shown below:
A. SELECT * FROMTABLE(fcn1('B01'))
B. SELECTTABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1
C. SELECT * FROMfcn1('B01')
D. SELECTfcn1('B01') FROM SYSIBM.SYSDUMMY1
Answer: A

IBM examen   certification 000-545   certification 000-545

NO.12 Given the two SQL procedures shown below: What is the expected output if procedure S1 is invoked
with the value 1 provided for parameter V1?
A. NULL
B. 2
C. 5
D. 7
Answer: D

IBM   000-545   000-545   000-545

NO.13 Given the following SQL:
Which statement is incorrect?
A. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result
set.
B. The cursor declaration requires the WITH RETURN TO CLIENT clause in order to return a result set.
C. The cursor declaration requires the WITH RETURN TO CALLER clause in order to return a result set.
D. The cursor declaration requires the WITH RETURN clause in order to return a result set.
Answer: A

IBM examen   000-545   000-545   certification 000-545   000-545 examen   000-545

NO.14 Which statement is permitted within a scalar user-defined function body?
A. COMMIT
B. INSERT
C. SIGNAL
D. LOOP
Answer: C

certification IBM   000-545 examen   000-545   000-545 examen

NO.15 A developer needs to create a user-defined function that will return a list of employees who work in a
particular department. Which statement will successfully create a function that meets this objective?
A. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE LANGUAGE SQL
READS SQL DATA RETURN SELECT empno, lastname AS l_name, firstnme AS f_name FROM
employee WHERE employee.workdept = dept_employees.deptno
B. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE DYNAMIC RESULT
SETS 1 LANGUAGE SQL READS SQL DATA DECLARE emp_info CURSOR WITH RETURN FOR
SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE
employee.workdept = dept_employees.deptno OPEN emp_info; RETURN
C. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE (empno CHAR(6),
l_nameVARCHAR(15), f_nameVARCHAR(12)) LANGUAGE SQL READS SQL DATA RETURN SELECT
empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE employee.workdept =
dept_employees.deptno
D. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE (empno CHAR(6),
l_nameVARCHAR(15), f_nameVARCHAR(12)) DYNAMIC RESULT SETS 1 LANGUAGE SQL READS
SQL DATA DECLARE emp_info CURSOR WITH RETURN FOR
SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE
employee.workdept = dept_employees.deptno OPEN emp_info; RETURN
Answer: C

IBM examen   certification 000-545   000-545   000-545   000-545

NO.16 Given the following SQL:
Which of the following statements is true?
A. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result
set.
B. The cursor declaration requires WITH RETURN TO CLIENT clause in order to return a result set.
C. The cursor declaration requires WITH RETURN TO CALLER clause in order to return a result set.
D. The cursor declaration requires WITH RETURN clause in order to return a result set.
Answer: B

IBM examen   certification 000-545   000-545

NO.17 The CREATE OR REPLACE PROCEDURE statement is similar semantically to which of the following
combined statements?
A. DROP and CREATE PROCEDURE
B. ALTER and CREATE PROCEDURE
C. UPDATE and CREATE PROCEDURE
D. DROP and ALTER PROCEDURE
Answer: A

IBM   000-545   000-545 examen   000-545

NO.18 Which SQL procedure declaration is coded correctly?
A. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE
EXIT HANDLER FOR SQLEXCEPTION SET commission = 0; DECLARE my_cur CURSOR FOR
SELECT * FROM employee; DECLARE a DOUBLE; SET a = .06 * salary; SET commission = a; END
B. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE
EXIT HANDLER FOR SQLEXCEPTION SET commission = 0; DECLARE a DOUBLE; DECLARE my_cur
CURSOR FOR SELECT * FROM employee; SET a = .06 * salary; SET commission = a; END
C. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE a
DOUBLE; DECLARE EXIT HANDLER FOR SQLEXCEPTION SET commission = 0; DECLARE my_cur
CURSOR FOR SELECT * FROM employee; SET a = .06 * salary; SET commission = a; END
D. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE a
DOUBLE; DECLARE my_cur CURSOR FOR SELECT * FROM employee; DECLARE EXIT HANDLER
FOR SQLEXCEPTION
SET commission = 0; SET a = .06 * salary; SET commission = a; END
Answer: D

certification IBM   000-545   000-545 examen

NO.19 What is a reason to use SQL procedures in DB2?
A. to use different programming languages B. to reduce code sharing
C. to move business logic rules into the database
D. to eliminate the need for testing
Answer: C

IBM   000-545   000-545

NO.20 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 the 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

IBM   000-545   000-545   000-545

Participer au test IBM 000-545 est un bon choix, parce que dans l'Industire IT, beaucoup de gens tirent un point de vue que le Certificat IBM 000-545 symbole bien la professionnalité d'un travailleur dans cette industrie.

Guide de formation plus récente de IBM 000-555 000-545 000-421 000-375 000-173

Le Pass4Past possède une équipe d'élite qui peut vous offrir à temps les matériaux de test Certification IBM 000-555 000-545 000-421 000-375 000-173. En même temps, nos experts font l'accent à mettre rapidement à jour les Questions de test Certification IT. L'important est que Pass4Test a une très bonne réputation dans l'industrie IT. Bien que l'on n'ait pas beaucoup de chances à réussir le test de 000-555 000-545 000-421 000-375 000-173, Pass4Test vous assure à passer ce test par une fois grâce à nos documentations avec une bonne précision et une grande couverture.

Le produit de Pass4Test peut assurer les candidats à réussir le test IBM 000-555 000-545 000-421 000-375 000-173 à la première fois, mais aussi offrir la mise à jour gratuite pendant un an, les clients peuvent recevoir les ressources plus nouvelles. Pass4Test n'est pas seulement un site, mais aussi un bon centre de service.

Vous pouvez tout d'abord télécharger le démo IBM 000-555 000-545 000-421 000-375 000-173 gratuit dans le site Pass4Test. Une fois que vous décidez à choisir le Pass4Test, Pass4Test va faire tous efforts à vous permettre de réussir le test. Si malheureusement, vous ne passez pas le test, nous allons rendre tout votre argent.

Il y a beaucoup de gans ambitieux dansn l'Industrie IT. Pour monter à une autre hauteur dans la carrière, et être plus proche du pic de l'Industrie IT. On peut choisir le test IBM 000-555 000-545 000-421 000-375 000-173 à se preuver. Mais le taux du succès et bien bas. Participer le test IBM 000-555 000-545 000-421 000-375 000-173 est un choix intelligent. Dans l'Industrie IT de plus en plus intense, on doit trouver une façon à s'améliorer. Vous pouvez chercher plusieurs façons à vous aider pour réussir le test.

Vous pouvez trouver un meilleur boulot dans l'industrie IT à travers d'obtenir le test IBM 000-555 000-545 000-421 000-375 000-173, la voie à la réussite de votre professionnel sera ouverte pour vous.

Code d'Examen: 000-555

Nom d'Examen: IBM (IBM Informix Dynamic Server 11.50 Fundamentals)

Questions et réponses: 115 Q&As

Code d'Examen: 000-545

Nom d'Examen: IBM (DB2 9.7 SQL Procedure Developer)

Questions et réponses: 109 Q&As

Code d'Examen: 000-421

Nom d'Examen: IBM (InfoSphere DataStage v8.5)

Questions et réponses: 194 Q&As

Code d'Examen: 000-375

Nom d'Examen: IBM (IBM WebSphere Process Server V6.2, System Administration)

Questions et réponses: 107 Q&As

Code d'Examen: 000-173

Nom d'Examen: IBM (IBM BPM Blueprint; IBM WebSphere Lombardi Edition V7.1, Application Development)

Questions et réponses: 72 Q&As

000-421 Démo gratuit à télécharger: http://www.pass4test.fr/000-421.html

NO.1 You set environment variable $APT_ORACLE_LOAD_OPTIONS=PTIONS(DIRECT=TRUE,
PARALLEL=TRUE)?for loading index organized tables.You set environment variable
$APT_ORACLE_LOAD_OPTIONS=?PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading index
organized tables. Which statement is accurate regarding the resulting effect of this environment variable
setting?
A. Oracle load will fail when executed.
B. Oracle load will run in parallel and bypassDataStage Director.
C. The Oracle load will run in parallel using simple direct path mode.
D. The Oracle database stage will run in parallel using conventional path mode.
Answer: A

IBM   certification 000-421   000-421 examen   000-421   000-421 examen

NO.2 When you configure a domain for source code integration a source control workspace is created. What
are two reasons for the source control workspace? (Choose two.)
A. default directory foristool exports.
B. directory for deployment package files
C. local transfer area for assets being submitted to the source control system
D. provides a place to store the archive created by IS source code control integration
Answer: C,D

IBM   000-421 examen   000-421   certification 000-421

NO.3 You have been asked to delete a shared container from the project by your customer. Before you do
this you want to make sure it will not impact other objects in the project. How will you ensure that deleting
the shared container will not cause a failure when jobs are recompiled?
A. Select the shared container, Right-click on the Where used command.
B. Select the shared container, Right-click on the Where used (deep) command.
C. Select the shared container, Right-click on the Dependencies (deep) command.
D. Advanced find, set Dependencies Of field equal to the container name, and Check the Option
toInclude nested results for Dependency searches.
Answer: B

IBM examen   certification 000-421   000-421   000-421

NO.4 What would help debug the run-time environment?
A. $APT_VERBOSE
B. $OSH_PRINT_SCHEMAS
C. Check the message filters for the job.
D. View detailed runtime stats through Job monitor in Director Client.
Answer: B

certification IBM   000-421   000-421 examen

NO.5 You are responsible for deploying objects into your customers production environment. To ensure the
stability of the production system the customer does not permit compilers on production machines. They
have also protected the project and only development machines have the required compiler. What two
options will allow jobs with a parallel transformer to execute in the customers production machines?
(Choose two.)
A. Add $APT_COMPILE_OPT=-portable
B. Set $APT_COPY_TRANSFORM_OPERATOR
C. Export the jobs with Information Server Manager with the executables.
D. Create a package with Information Server Manager and select the option to include executables.
Answer: C,D

IBM   certification 000-421   000-421 examen   000-421

NO.6 Click on the Exhibit button.
Provided you have enough system resources, what is the maximum number of jobs that could be running
concurrently in this image?
A. 2
B. 3
C. 4
D. 5
Answer: B

certification IBM   000-421   certification 000-421   000-421

NO.7 You are responsible for the projects Source Code Repository. When a developer notifies you that
changes are ready to deploy you must first check them in. You will use the Information Server Source
Code integration features to check in the changed assets. How will you identify the DataStage assets the
developer modified in order to send them to the workspace?
A. From the Information Server Manager Select theproject then right-click on Synchronize with source
code control system.
B. Use Designer client Advanced Find, specify a modification date and the developer's username in the
Modified by fields.
C. From Information Server Manager use Search with advanced options, specify a date modified and the
developer's user name in the Modified by fields.
D. From the workspace perspective select the project Right-click then Refresh fromrepository,specify a
modification date and the developer's username in the Modified by fields.
Answer: C

certification IBM   000-421   000-421

NO.8 Click on the Exhibit button.
A. 3 processes on 2 nodes
B. 3 processes on 3 nodes
C. 2 processes on 2 nodes
D. 2 processes on 3 nodes
Answer: A

IBM   000-421   000-421   000-421

NO.9 Where are project level message handlers defined?
A. DSENV
B. Director Client
C. Designer Client
D. Administrator Client
Answer: D

IBM   000-421   000-421 examen   000-421   000-421 examen

NO.10 You are experiencing performance issues for a given job. You are assigned the task of understanding
what is happening at run time for that job. What are the first two steps you should take to understand the
job performance issues? (Choose two.)
A. Review the objectives of the job.
B. Run job with $APT_TRACE_RUN set to true.
C. Run job with $APT_DUMP_SCORE set to true.
D. Replace Transformer stages with custom operators.
Answer: A,C

IBM   000-421   certification 000-421   000-421 examen   000-421   000-421 examen

NO.11 Click the exhibit button.
You submit a job from DataStage Director and then log onto your DataStage Linux server to issue the
command "ps -ef | grep ds" and receive the following screen: Which process is a player?
A. 7117
B. 7215
C. 7216
D. 7217
Answer: D

certification IBM   000-421   000-421

NO.12 You are working on a project that contains a large number of jobs contained in many folders. You would
like to review the jobs created by the former developer of the project. How can you find these jobs?
A. Filter jobs in Director Client's Repository window.
B. Sort the jobs by date in the Repository window.
C. Use the Advanced Find feature contained in the Designer interface.
D. While selecting the top folder in the project, choose Find Dependencies.
Answer: C

IBM   000-421   000-421 examen

NO.13 In which two situations is it appropriate to use a Sparse Lookup? (Choose two.)
A. When accessing DB2 data using the DB2 API stage.
B. When the output of the Lookup stage needs to be hashed partitioned.
C. When reference data is significantly larger than the streaming data (100:1).
D. When invoking a stored procedure within a database per row in the streaming link.
Answer: C,D

IBM   certification 000-421   certification 000-421   000-421   000-421 examen

NO.14 Which two property areas must be configured when using the ODBC connector stage as a target in
your job design? (Choose two.)
A. Define columns for the output link.
B. Specify the remote server property.
C. Specify properties for the input link.
D. Define the connection properties to an ODBC data source.
Answer: C,D

certification IBM   certification 000-421   000-421 examen   certification 000-421   000-421

NO.15 Which two statements are accurate regarding usage of database stages? (Choose two.)
A. Plug-in stages match columns by name.
B. Native database stages match columns by name.
C. DataStage provides native Oracle database stages.
D. Database stages cannot create tables and must be done externally.
Answer: B,C

IBM examen   000-421   000-421

NO.16 To better understand the data flowing through a job, it is desirable to have structural information about
the datasets captured in the job log. Which environment variable can provide this information?
A. $OSH_STDOUT_MSG
B. $OSH_PRINT_SCHEMAS
C. $APT_PM_PLAYER_MEMORY
D. $APT_NO_PART_INSERTION
Answer: B

certification IBM   000-421   certification 000-421

NO.17 You are about to begin major changes to jobs in a project. You want to conveniently identify job
changes on an ad hoc basis. What two tasks will allow you to identify changes to your jobs? (Choose
two.)
A. Import the original job from a .dsx export.
B. Select the job,then right click Compare within.
C. Select the job,then right click Cross Project Compare.
D. Before making a change to a job make a copy of the job in a different category folder.
Answer: B,D

IBM   000-421   000-421   000-421   certification 000-421   000-421

NO.18 You would like to pass values into parameters that will be used in a variety of downstream activity
stages within a job sequence. What are three valid ways to do this? (Choose three.)
A. Use local parameters.
B. Use environment variables.
C. Place a parameter set stage on the job sequence.
D. Check the "Propagate Parameters" checkbox in the Sequence Job properties.
E. Use theUserVariablesActivity Stage to populate the local parameters from an outside source such as a
file.
Answer: A,B,E

IBM   000-421 examen   certification 000-421   000-421

NO.19 DataStageoffers database connectivity through connectors, native parallel and plug-in stage types.
Which two statements are correct? (Choose two.)
A. ODBC API is a plug-in stage.
B. Next to the connector stage it is best to use the native parallel database stages.
C. The connector stage offers better functionality and performance and is the best to use.
D. For maximum parallel performance, scalability, and features it is best to use the native parallel
database stages.
Answer: B,C

IBM   000-421   000-421   certification 000-421

NO.20 hich three of the following options does the dsjob command have? (Choose three.)
A. Stopping a job
B. Setting an alias for a job
C. Specifying an appropriate log file
D. Listing projects, jobs, stages, links, and parameters
Answer: A,B,D

IBM   certification 000-421   000-421

Le meilleur matériel de formation examen IBM 000-545

Pass4Test est un site de provider les chances à se former avant le test Certification IT. Il y a de différentes formations ciblées aux tous candidats. C'est plus facile à passer le test avec la formation de Pass4Test. Parmi les qui ont déjà réussi le test, la majorité a fait la préparation avec la Q&A de Pass4Test. Donc c'est pourquoi, Pass4Test a une bonne réputation dansn l'Industrie IT.

Le test simulation offert par Pass4Test est bien proche du test réel. Vous pouvez apprendre tous essences d'un test réel à courte terme avec l'aide de Pass4Test. Pass4Test peut vous assurer le succès 100% de test IBM 000-545.

Code d'Examen: 000-545

Nom d'Examen: IBM (DB2 9.7 SQL Procedure Developer)

Questions et réponses: 109 Q&As

Les produits de Pass4Test a une bonne qualité, et la fréquence de la mise à jour est bien impressionnée. Si vous avez déjà choisi la Q&A de Pass4Test, vous n'aurez pas le problème à réussir le test IBM 000-545.

Aujoud'hui, dans cette indutrie IT de plus en plus concurrentiel, le Certificat de IBM 000-545 peut bien prouver que vous avez une bonne concurrence et une space professionnelle plus grande à atteindre. Dans le site Pass4Test, vous pouvez trouver un outil de se former très pratique. Nos IT experts vous offrent les Q&As précises et détaillées pour faciliter votre cours de préparer le test IBM 000-545 qui vous amenera le succès du test IBM 000-545, au lieu de traivailler avec peine et sans résultat.

L'équipe de Pass4Test autorisée offre sans arrêt les bonnes resources aux candidats de test Certification IBM 000-545. Les documentations particulièrement visée au test IBM 000-545 aide beaucoup de candidats. La Q&A de la version plus nouvelle est lancée maintenant. Vous pouvez télécharger le démo gratuit en Internet. Généralement, vous pouvez réussir le test 100% avec l'aide de Pass4Test, c'est un fait preuvé par les professionnels réputés IT. Ajoutez le produit au panier, vous êtes l'ensuite à réussir le test IBM 000-545.

Participer au test IBM 000-545 est un bon choix, parce que dans l'Industire IT, beaucoup de gens tirent un point de vue que le Certificat IBM 000-545 symbole bien la professionnalité d'un travailleur dans cette industrie.

Au 21er siècle, il manque encore grand nombreux de gens qualifié de IT. Le test Certificat IT est une bonne façon à examiner les hommes de talent. Ce n'est pas un test facile à réussir. Un bon choix de formation est une assurance pour le succès de test. Le test simulation est bien proche que test réel. Vous pouvez réussir 100%, bien que ce soit la première à participer le test.

000-545 Démo gratuit à télécharger: http://www.pass4test.fr/000-545.html

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

IBM examen   certification 000-545   000-545   000-545 examen   000-545

NO.2 Click the Exhibit button.
Referring to the exhibit, how many rows will be returned by the SQL query shown below? SELECT *
FROM TABLE(getnumemployee(21?) AS dSELECT * FROM TABLE(getnumemployee(?21?) AS d
A.0
B.1
C.7
D.10
Answer: C

IBM   000-545   000-545

NO.3 The CREATE OR REPLACE PROCEDURE statement is similar semantically to which of the following
combined statements?
A. DROP and CREATE PROCEDURE
B. ALTER and CREATE PROCEDURE
C. UPDATE and CREATE PROCEDURE
D. DROP and ALTER PROCEDURE
Answer: A

certification IBM   000-545 examen   000-545

NO.4 In the function shown below:
A. SELECT * FROMTABLE(fcn1('B01'))
B. SELECTTABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1
C. SELECT * FROMfcn1('B01')
D. SELECTfcn1('B01') FROM SYSIBM.SYSDUMMY1
Answer: A

IBM examen   certification 000-545   000-545   000-545

NO.5 Which statement correctly describes characteristics of external functions?
A. External functions cannot return tables.
B. All cursors opened within an external function should stay open until the database isquiesced.
C. Scratchpads can be used to allocate dynamic memory required for multiple function invocations.
D. Transactions can be terminated within external functions.
Answer: C

certification IBM   000-545 examen   000-545 examen

NO.6 A developer wants to code the following statements in an SQL procedure:
A. 1, 2, 3, 4
B. 2, 4, 3, 1
C. 3, 4, 2, 1
D. 4, 3, 2, 1
Answer: B

IBM examen   certification 000-545   000-545 examen   certification 000-545

NO.7 A developer needs to create a user-defined function that will return a list of employees who work in a
particular department. Which statement will successfully create a function that meets this objective?
A. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE LANGUAGE SQL
READS SQL DATA RETURN SELECT empno, lastname AS l_name, firstnme AS f_name FROM
employee WHERE employee.workdept = dept_employees.deptno
B. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE DYNAMIC RESULT
SETS 1 LANGUAGE SQL READS SQL DATA DECLARE emp_info CURSOR WITH RETURN FOR
SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE
employee.workdept = dept_employees.deptno OPEN emp_info; RETURN
C. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE (empno CHAR(6),
l_nameVARCHAR(15), f_nameVARCHAR(12)) LANGUAGE SQL READS SQL DATA RETURN SELECT
empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE employee.workdept =
dept_employees.deptno
D. CREATE FUNCTIONdept_employees (deptno CHAR(3)) RETURNS TABLE (empno CHAR(6),
l_nameVARCHAR(15), f_nameVARCHAR(12)) DYNAMIC RESULT SETS 1 LANGUAGE SQL READS
SQL DATA DECLARE emp_info CURSOR WITH RETURN FOR
SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE
employee.workdept = dept_employees.deptno OPEN emp_info; RETURN
Answer: C

certification IBM   000-545 examen   certification 000-545   000-545 examen   certification 000-545

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

certification IBM   000-545   000-545

NO.9 Which SQL procedure declaration is coded correctly?
A. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE
EXIT HANDLER FOR SQLEXCEPTION SET commission = 0; DECLARE my_cur CURSOR FOR
SELECT * FROM employee; DECLARE a DOUBLE; SET a = .06 * salary; SET commission = a; END
B. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE
EXIT HANDLER FOR SQLEXCEPTION SET commission = 0; DECLARE a DOUBLE; DECLARE my_cur
CURSOR FOR SELECT * FROM employee; SET a = .06 * salary; SET commission = a; END
C. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE a
DOUBLE; DECLARE EXIT HANDLER FOR SQLEXCEPTION SET commission = 0; DECLARE my_cur
CURSOR FOR SELECT * FROM employee; SET a = .06 * salary; SET commission = a; END
D. CREATE PROCEDUREmyproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE a
DOUBLE; DECLARE my_cur CURSOR FOR SELECT * FROM employee; DECLARE EXIT HANDLER
FOR SQLEXCEPTION
SET commission = 0; SET a = .06 * salary; SET commission = a; END
Answer: D

IBM   000-545   000-545 examen   certification 000-545

NO.10 Which procedure demonstrates the correct use of dynamic SQL?
A. CREATE PROCEDURE update_count1 (INnew_count INTEGER, IN item_code INTEGER) BEGIN
DECLARE v_dynSQL VARCHAR(200); SET v_dynSQL = 'UPDATE stock SET quantity_on_hand=?
WHERE item_number=?'; PREPARE v_stmt1 FROM v_dynSQL; EXECUTE v_stmt1 USING new_count,
item_code; END
B. CREATE PROCEDURE update_count2 (INtab_name VARCHAR(128), IN new_count INTEGER, IN
item_code INTEGER) BEGIN DECLARE v_dynSQL VARCHAR(200); SET v_dynSQL = 'UPDATE ? SET
quantity_on_hand=? WHERE item_number=?'; PREPARE v_stmt1 FROM v_dynSQL; EXECUTE
v_stmt1 USING tab_name, new_count, item_code; END
C. CREATE PROCEDURE update_count4 (INtab_name VARCHAR(128), IN col_name1
VARCHAR(128), IN col_name2 VARCHAR(128), IN new_countINTEGER, IN item_code INTEGER)
BEGIN
DECLARE v_dynSQL VARCHAR(200); SET v_dynSQL = 'UPDATE ? SET ?=? WHERE ?=?'; PREPARE
v_stmt1 FROM v_dynSQL; EXECUTE v_stmt1 USING tab_name, col_name1, new_count, col_name2,
item_code; END
D. CREATE PROCEDURE update_count5 (INnew_count INTEGER, IN item_code INTEGER) BEGIN
DECLARE v_dynSQL VARCHAR(200); DECLARE v_col_name VARCHAR(128); SET v_col_name =
'item_number'; SET v_dynSQL = 'UPDATE stock SET quantity_on_hand=? WHERE ?=?'; PREPARE
v_stmt1 FROM v_dynSQL; EXECUTE v_stmt1 USING new_count, v_col_name, item_code; END
Answer: A

IBM   000-545   000-545 examen   certification 000-545

NO.11 Click on the Exhibit button.
Referring to the exhibit, what is the OUT_PHONENUMBERS result set when the SQL procedure is
invoked by the call statement shown below? CALL
find_customers(ARRAY[?16-305-3745? ?05-416-4565? ?16-305-3746? '905-414-4566'], ?16??)
A. [?16-305-3745??05-416-4565? ?16-305-3746']
B. [?16-305-3745??05-416-4565? ?16-305-3746? '905-414-4566']
C. [?05-416-4565? '905-414-4566']
D. [?16-305-3745? ?16-305-3746[?16-305-3745? ?16-305-3746?
Answer: D

IBM   000-545   000-545

NO.12 Given the two SQL procedures shown below: What is the expected output if procedure S1 is invoked
with the value 1 provided for parameter V1?
A. NULL
B. 2
C. 5
D. 7
Answer: D

certification IBM   000-545   000-545

NO.13 What is a reason to use SQL procedures in DB2?
A. to use different programming languages B. to reduce code sharing
C. to move business logic rules into the database
D. to eliminate the need for testing
Answer: C

certification IBM   certification 000-545   000-545   certification 000-545

NO.14 Given the following SQL:
Which of the following statements is true?
A. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result
set.
B. The cursor declaration requires WITH RETURN TO CLIENT clause in order to return a result set.
C. The cursor declaration requires WITH RETURN TO CALLER clause in order to return a result set.
D. The cursor declaration requires WITH RETURN clause in order to return a result set.
Answer: B

IBM   000-545   000-545 examen   000-545

NO.15 In the stored procedure below: What will the value of the P_ID parameter be if the procedure is
invoked and a value of 2 is specified for the START_VALUE parameter?
A. 1
B. 2
C. 3
D. 4
Answer: C

certification IBM   000-545 examen   000-545   000-545 examen   000-545 examen

NO.16 The CREATE PROCEDURE statement shown below was executed against a database called MYDB.
CREATE PROCEDURE myschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3 SMALLINT)
BEGIN SET p2 = 'abc'; END Which two CREATE PROCEDURE statements, when executed against the
same database, will succeed? (Choose two.)
A. CREATE PROCEDUREmyschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER) BEGIN SET p2 = 123;
END
B. CREATE PROCEDUREmyschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3 CHAR(4))
BEGIN SET p2 = 'abc'; END
C. CREATE PROCEDUREmyschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER, OUT p3 SMALLINT)
BEGIN SET p2 = 123; END
D. CREATE PROCEDUREotherschema.proc1(IN p1 CHAR(4), OUT p2 CHAR(4), OUT p3 CHAR(4))
BEGIN SET p2 = 'abc'; END
E. CREATE PROCEDUREmyschema.proc1(IN p1 NUMBER, OUT p2 NUMBER, OUT p3 NUMBER)
BEGIN SET p2 = 'abc';END
Answer: A,D

IBM   000-545   000-545   certification 000-545   000-545 examen

NO.17 Which statement is permitted within a scalar user-defined function body?
A. COMMIT
B. INSERT
C. SIGNAL
D. LOOP
Answer: C

IBM examen   000-545   000-545   certification 000-545   000-545

NO.18 Given the following SQL:
Which statement is incorrect?
A. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result
set.
B. The cursor declaration requires the WITH RETURN TO CLIENT clause in order to return a result set.
C. The cursor declaration requires the WITH RETURN TO CALLER clause in order to return a result set.
D. The cursor declaration requires the WITH RETURN clause in order to return a result set.
Answer: A

certification IBM   000-545   000-545   000-545

NO.19 If this statement was used to create an SQL procedure named P_EXIT:
A. 10
B. 20
C. 99
D. NULL
Answer: C

IBM   certification 000-545   certification 000-545   000-545 examen

NO.20 Which three optional clauses can be used when creating an external function? (Choose three.)
A. SCRATCHPAD
B. NOTEPAD
C. LANGUAGE
D. EXTERNAL NAME
E. DATABASEINFO
Answer: A,C,D

IBM   000-545 examen   000-545   000-545 examen

On doit faire un bon choix pour passer le test IBM 000-545. C'est une bonne affaire à choisir la Q&A de Pass4Test comme le guide d'étude, parce que vous allez obtenir la Certification IBM 000-545 en dépensant d'un petit invertissement. D'ailleur, la mise à jour gratuite pendant un an est aussi gratuite pour vous. C'est vraiment un bon choix.