Which two statements are true about anonymous blocks and named subprograms?
(Choose two)
A.
Subprograms are by default executed with definer’s rights.
B.
The declare section is optional for both anonymous blocks and subprograms.
C.
Both anonymous blocks and subprograms execute by default with invoker’s rights.
D.
The declare section is mandatory for anonymous blocks and optional for subprograms.
A, B
http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/subprograms.htm
By default, stored procedures and SQL methods execute with the privileges of their owner, not their current user. Such definer’s rights subprograms are bound to the schema in which they reside, allowing you to refer to objects in the same schema without qualifying their names.
A B
a,b
AB
A B
DECLARE is an optional sectional of a PL/SQL block.
http://psoug.org/definition/DECLARE.htm
AB