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 thedatabase is quiesced.
C. Scratchpads can be used to allocate dynamic memory required for multiple function invocations.
D. Transactions can be terminated within external functions.
The CREATE PROCEDURE statement shown below was executed against a database called MYDB.
CREATE PROCEDURE myschema.proc1(INp1 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 PROCEDURE myschema.proc1(IN p1 CHAR(4), OUT p2 INTEGER) BEGIN SET p2 = 123; END
B. CREATE PROCEDURE myschema.proc1(IN p1 INTEGER, OUT p2 CHAR(4), OUT p3 CHAR(4)) BEGIN SET p2 = 'abc'; END
C. CREATE PROCEDURE myschema.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 PROCEDURE myschema.proc1(IN p1 NUMBER, OUT p2 NUMBER, OUT p3 NUMBER) BEGIN SET p2 = 'abc'; END
Given the variable declaration shown below: DECLARE v_mydate DATE; Which statement will assign a value to the variable V_MYDATE?
A. VALUES (08262010) INTO v_mydate;
B. VALUES CURRENT TIMESTAMP INTO v_mydate;
C. SELECT CURRENTTIMESTAMP INTO v_mydate FROM SYSIBM.SYSDUMMY1;
D. SELECT CURRENT DATE INTO v_mydate FROM SYSIBM.SYSDUMMY1;
Assuming C1 and C2 are cursor type variables, which of the following operations cannot be performed?
A. IF (c1 = c2)THEN ?END;
B. SET c2 = c1;
C. SET c1 = CURSOR FOR SELECT * FROM t;
D. SET c1 = CURSOR FOR VALUES ('a', 'b', 'c');
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.
Which command can be used to convert literals in SQL statements to parameter markers to avoid compilation of similar SQL statements?
A. UPDATE DB CFG USING STMT_CONC ON
B. UPDATE DB CFG USING LIT_PARM ON
C. UPDATE DB CFG USING CURSOR_SHARING FORCED
D. UPDATE DB CFG USING CURSOR_SHARING ON
Given the statement shown below:
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.
Which statement will let you use the result set from the nested procedure CALLEE?
A. ASSOCIATE RESULT SET LOCATOR( loc1) WITH PROCEDURE callee;
B. BIND RESULT SET WITH PARAMETERS FOR PROCEDUREcallee;
C. INSERT RESULT SET FROM callee INTO CURSOR c1;
D. SELECT * FROM callee;
In the code segment shown below:
Which statement accurately describes the result?
A. For activities whose description has not changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
B. For activities whose description has changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES tableboth have ACTIVITY as a primary key.
C. For activities whose description has changed, update the description in the ACTIVITY table. For new activities, insert into the ACTIVITIES table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
D. The statement will fail since MERGE is not a supported operator.
Which option is used when declaring a global temporary table that will keep its data across transaction boundaries?
A. ON ROLLBACK DELETE ROWS
B. ON ROLLBACK PRESERVE ROWS
C. ON COMMIT PRESERVE ROWS
D. ON COMMIT DELETE ROWS
