Oracle
1Z0-144 · Question #11
Which three statements are true about anonymous blocks and subprograms? (Choose three.)
The correct answer is A. Only subprograms can be parameterized. B. Only subprograms are persistent database objects. E. Only subprograms can return values that persist after the execution of the subprogram. See the full explanation below for the reasoning.
Question
Which three statements are true about anonymous blocks and subprograms? (Choose three.)
Options
- AOnly subprograms can be parameterized.
- BOnly subprograms are persistent database objects.
- CBoth anonymous blocks and subprograms can be parameterized.
- DBoth anonymous blocks and subprograms are persistent database objects
- EOnly subprograms can return values that persist after the execution of the subprogram.
- FBoth anonymous blocks and subprograms can return values that persist In SQL*Plus variables
How the community answered
(45 responses)- A76% (34)
- C7% (3)
- D4% (2)
- F13% (6)
Community Discussion
No community discussion yet for this question.