1Z0-149: Oracle Database Program with PL/SQLDemo

By Oracle · Question Mode

QuestionQ9

PL/SQL Language Fundamentals

Which three statements about anonymous blocks and subprograms are true?

Choose three
  • A Named subprograms cannot be called from other packages.
  • B PROCEDURE subprograms can accept parameters.
  • C A FUNCTION subprogram must return one or more values.
  • D Anonymous blocks cannot use packaged variables.
  • E Named subprograms are stored in the database server.
  • F Anonymous blocks must always start with the Declare keyword.
Explanation

PL/SQL procedures can take parameters. A PL/SQL function must return a value. Named subprograms, including standalone procedures/functions and package subprograms, are stored in the database server.

Community Discussion

No comments yet. Be the first to start the discussion!