Which of the following can be done while debugging a SQL procedure with IBM Data Studio?
A. Edit the procedure and continue.
B. Change the value of any variables used.
C. Re-execute the current statement.
D. Change the order of statements being executed.
正解:B
質問 2:
Which of the following CURSOR declare statement is incorrect?
A. DECLARE c1 INSENSITIVE CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM tab1
B. DECLARE c1 SENSITIVE CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM tab1
C. DECLARE c1 ASENSITIVE CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM tab1
D. DECLARE c1 CURSOR WITHOUT RETURN FOR SELECT * FROM tab1
正解:B
質問 3:
Given the following SQL:
Which statement is incorrect?
A. The cursor declaration requires the WITH RETURN TO CALLER clause in order to return a result set.
B. The cursor declaration requires the WITH RETURN clause in order to return a result set.
C. The cursor declaration requires the WITH RETURN TO CLIENT clause in order to return a result set.
D. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result set.
正解:D
質問 4:
Which two statements are true about SQL procedures? (Choose 2)
A. SQL procedures reside outside of the database for easy portability.
B. SQL procedures may return multiple result sets to the caller or to a client application.
C. SQL procedures cannot be called from triggers.
D. SQL procedures support recursion.
E. SQL procedures support the PRINT statement.
正解:B,D
質問 5:
A trigger was created using the CREATE TRIGGER statement shown below.
Which statement is true about the INCRS_COMM trigger?
A. This trigger will be executed after a row is inserted into the STAFF table.
B. The trigger will be executed if the STAFF table is populated by a load operation.
C. The trigger will be executed before a row is inserted into the STAFF table.
D. This trigger will increase the COMM value of a newly inserted row by 10 percent.
正解:A
質問 6:
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. STATIC DISPATCH
B. NO EXTERNAL ACTION
C. NOT FENCED
D. NOT DETERMINISTIC
正解:D
質問 7:
Which statement will let you use the result set from the nested procedure CALLEE?
A. INSERT RESULT SET FROM callee INTO CURSOR c1;
B. ASSOCIATE RESULT SET LOCATOR( loc1) WITH PROCEDURE callee;
C. BIND RESULT SET WITH PARAMETERS FOR PROCEDURE callee;
D. SELECT * FROM callee;
正解:B
質問 8:
Assuming EMP_ROW and NEW_HIRE have the same user-defined row data type, what is the best way to assign the elements of NEW_HIRE to EMP_ROW?
A. emp_row.all = new_hire.all;
B. SET emp_row = new_hire;
C. emp_row.rowid = new_hire.rowid;
D. SET emp_row.* = new_hire.*;
正解:B
質問 9:
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. READS SQL DATA
B. LANGUAGE SQL
C. MODIFIES SQL DATA
D. CONTAINS SQL
正解:C