IBM C2090-545 - DB2 9.7 SQL Procedure Developer Exam
Page: 2 / 11
Total 55 questions
Question #6 (Topic: Topic 2)
Which two DB2 commands can be performed using the ADMIN_CMD procedure? (Choose
two.)
two.)
A. RUNSTATS
B. BACKUP
C. RESTORE
D. RECOVER
E. CREATE DATABASE
Answer: A,B
Question #7 (Topic: Topic 2)
Which of the following is the simplest way to define a recordwith fields corresponding to all
of the columns that are fetched from a cursor or cursor variable?
of the columns that are fetched from a cursor or cursor variable?
A. Using the VARRAY attribute
B. Using the READ FROM CURSOR attribute
C. Using the %ROWTYPE attribute
D. Using the %CURSOR attribute
Answer: C
Question #8 (Topic: Topic 2)
Which statementdescribes what must be done to create an SQL procedure that returns a
result set?
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 #9 (Topic: Topic 2)
Which of the following can be done while debugging a SQL procedure with IBM Data
Studio?
Studio?
A. Change the order of statements being executed.
B. Edit the procedure and continue.
C. Change the value of any variables used.
D. Re-execute the current statement.
Answer: C
Question #10 (Topic: Topic 2)
Given the statement shown below:
[IBM-C2090-545-6.0/IBM-C2090-545-7_2.png]
What happens toNEWPROD if 'http://posample.org/product.xsd' is dropped?
[IBM-C2090-545-6.0/IBM-C2090-545-7_2.png]
What happens toNEWPROD if 'http://posample.org/product.xsd' is dropped?
A. NEWPROD will validate against a new schema.
B. NEWPROD will raise an exception.
C. NEWPROD is marked as inoperative.
D. NEWPROD is dropped.
Answer: C
