Multiple choice

Which of the following is a schema object that groups logically related PL/SQL types, items and sub-programs?

  1. Trigger <!--?xml:namespace prefix = o /--><o:p></o:p>

  2. Procedure <o:p></o:p>

  3. Function <o:p></o:p>

  4. Package <o:p></o:p>
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A package is a collection of related PL/SQL objects like procedures, functions and triggers created as a single unit. It is used to store related objects in a single file. A package has two parts - Package specification and package body. The specification part contains the declaration of procedure, functions and triggers whereas the body part contains the actual implementation or code of all the subprogram declared in specification part.

Keep practicing — related questions