Home » Other » Training & Certification » Objective Question reg autonomous transaction
Objective Question reg autonomous transaction [message #169321] Wed, 26 April 2006 04:55
ssrividhya
Messages: 8
Registered: April 2006
Junior Member
User MILTON issues the following code block in his SQL*Plus session:
CREATE OR REPLACE PROCEDURE upd_tran
( PVAL1 IN VARCHAR2) IS
PRAGMA AUTONOMOUS_TRANSACTION;
MY_VAL2 NUMBER(10);
BEGIN
SELECT COL_1 INTO MY_VAL2
FROM TAB_2 WHERE COL_2 = PVAL1;
UPDATE TAB_1 SET COL_1 = PVAL1
WHERE COL_2 = PVAL2;
COMMIT;
END;
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( ).
Previous Topic: Training class recommendation
Next Topic: Dependecy Question
Goto Forum:
  


Current Time: Sun Jul 12 14:12:14 CDT 2020