IBM DB2 9.7 SQL Procedure Developer - C2090-545무료 덤프문제 풀어보기

A. CREATE OR REPLACE selesModule UPDATE salesFunc

B. UPDATE salesModule MODULE FOR

C. ALTER MODULE salesModule

D. REPLACE MODULE salesModule

A. [?16-305-3745? ?16-305-3746[?16-305-3745? ?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??05-416-4565? ?16-305-3746']

A. The row will be found with a different ROW CHANGE TOKEN and Transaction 2 will overwrite the values set in transaction 1.

B. The row will be found with the same ROW CHANGE TOKEN. Transaction 2 will now insert its values replacing those of transaction 1.

C. The row will not be found because the value of the ROW CHANGE TOKEN has changed in regard to the UPDATE of transaction 1. Transaction 2 will complete with an insert of a new row.

D. The row will not be found because the value of the ROW CHANGE TOKEN has changed in regard to the UPDATE of transaction 1. Transaction 2 has to retry in order to retrieve the current data.

A. 0

B. 2

C. 3

D. 1

A. CREATE PROCEDURE update_count2 (IN tab_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

B. CREATE PROCEDURE update_count4 (IN tab_name VARCHAR(128), IN col_name1
VARCHAR(128), IN col_name2 VARCHAR(128), IN
new_count INTEGER, 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

C. CREATE PROCEDURE update_count5 (IN new_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

D. CREATE PROCEDURE update_count1 (IN new_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

A. 0

B. 7

C. 10

D. 1