IBM 000-545 問題集

質問 1：
In a SQL Procedure, rows_fetched is an integer variable and curEmp is a cursor variable of SELECT statement on a table. After opening the cursor curemp, which of the statement will determine the number of rows fetched?
A. SET rows_fetched = ROWCOUNT(curemp)
B. SET rows_fetched = curEmp%ROWCOUNT
C. SET rows_fetched = CURSOR_ROWCOUNT(curemp)
D. SET rows_fetched = curEmp%CURSOR_ROWCOUNT
正解：C

質問 2：
Given the statement shown below:

What happens to NEWPROD 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.
正解：C

質問 3：
What values are generated each time an SQL statement is executed?
A. EXCEPTION and SQLCODE
B. SQLSTATE and SQLCODE
C. SQLSTATE and EXCEPTION
D. SQLERRN and SQLMSG
正解：B

質問 4：
If table TAB1 were created as follows: CREATE TABLE tab1 (col1 INT NOT NULL); Which statement illustrates the proper way to define an anchor variable that references column COL1 in table TAB1?
A. DECLARE var1 ANCHOR DATA TYPE TO tab1.col1%TYPE
B. DECLARE var1 ANCHOR DATA TYPE TO tab1.col1
C. DECLARE var1 REFERENCES tab1.col1
D. DECLARE var1 tab1.col1%TYPE
正解：B

質問 5：
Which SQL procedure declaration is coded correctly?
A. CREATE PROCEDURE myproc(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
B. CREATE PROCEDURE myproc(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
C. CREATE PROCEDURE myproc(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
D. CREATE PROCEDURE myproc(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
正解：C

質問 6：
If this statement was used to create an SQL procedure named P_EXIT:

What will the return status be?
A. NULL
B. 10
C. 99
D. 20
正解：C

質問 7：
Which action is supported by Data Studio in the SQL procedure lifecycle?
A. Use auto complete SQL statements.
B. Create user-define types in the SQL procedure.
C. Debug the SQL procedure.
D. Create global temporary tables to use in the SQL procedure.
正解：C