|Objective Question reg autonomous transaction [message #169321]
||Wed, 26 April 2006 04:55
Registered: April 2006
User MILTON issues the following code block in his SQL*Plus session:|
CREATE OR REPLACE PROCEDURE upd_tran
( PVAL1 IN VARCHAR2) IS
SELECT COL_1 INTO MY_VAL2
FROM TAB_2 WHERE COL_2 = PVAL1;
UPDATE TAB_1 SET COL_1 = PVAL1
WHERE COL_2 = PVAL2;
Later, another procedure called my_tran( ) is defined by user GOETHE,
which calls upd_tran( ) as part of an application. Which of the following
statements is true about this application?
A. Any transaction in progress in my_tran( ) when upd_tran( ) is
called will be committed when upd_tran( ) completes.
B. Any uncommitted changes made to table TAB_2 by my_tran( ) will
not be seen by upd_tran( ).
C. Procedure upd_tran( ) has no problem updating TAB_1 if my_tran(
) has already done so without issuing a commit
before the call to upd_tran( ).
D. User GOETHE needs to have update privileges on TAB_1 to execute procedure upd_tran( ).