Oracle Database 11g: Program with PL/SQL — Question 11

Which three statements are true about anonymous blocks and subprograms? (Choose three.)

Answer options

• 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.

Correct answer: B, C, F

Explanation

The correct answers are B, C, and F because only subprograms are persistent database objects (B), while both anonymous blocks and subprograms can be parameterized (C). Additionally, both can return values that persist in SQL*Plus variables after execution (F). Options A, D, and E are incorrect as they misrepresent the capabilities of anonymous blocks and subprograms.