Which three statements are true about anonymous blocks and subprograms? (Choose three.)
A. Only subprograms can be parameterized.
B. Only subprograms are persistent database objects.
C. Both anonymous blocks and subprograms can be parameterized.
D. Both anonymous blocks and subprograms are persistent database objects
E. Only subprograms can return values that persist after the execution of the subprogram.
F. Both anonymous blocks and subprograms can return values that persist In SQL*Plus variables after their execution.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Answer: B,C,F
ABE correct.
it’s ABF.
try in sql plus:
1) variable v_test number;
2) begin
select 1 into :v_test from dual;
end;
/
at this point the block is executed.
3) print v_test will print 1.
ABE correct answer in my opinion also.
Reference:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/subprograms.htm#LNPLS00801
“A PL/SQL subprogram is a named PL/SQL block that can be invoked with a set of parameters. ”
http://www.orafaq.com/wiki/Anonymous_block
“An anonymous block is an unnamed sequence of actions. Since they are unnamed, anonymous blocks cannot be referenced by other program units.
In contrast to anonymous blocks, stored/ named code blocks include Packages, Procedures, and Functions.”
ABE correct answer in my thought also.
Reference:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/subprograms.htm#LNPLS00801
“A PL/SQL subprogram is a named PL/SQL block that can be invoked with a set of parameters. A subprogram can be either a procedure or a function. Typically, you use a procedure to perform an action and a function to compute and return a value.”
http://www.orafaq.com/wiki/Anonymous_block
“An anonymous block is an unnamed sequence of actions. Since they are unnamed, anonymous blocks cannot be referenced by other program units.
In contrast to anonymous blocks, stored/ named code blocks include Packages, Procedures, and Functions.”
i am confuse this answer ,so please reply me suggestion ….
ABE correct answer.