Multiple choice technology databases

Which two statements about packages are true? (Choose two)

  1. Packages can be nested.

  2. You can pass parameters to packages.

  3. A package is loaded into memory each time it is invoked.

  4. The contents of packages can be shared by many applications.

  5. You can achieve information hiding by making package constructs private.
Reveal answer Fill a bubble to check yourself
D,E Correct answer
Explanation

PL/SQL packages cannot be nested, nor can they accept parameters directly (though their subprograms can). They are loaded into memory once, not on every invocation. The true statements are that package contents can be shared and information hiding is achieved by making constructs private.

Keep practicing — related questions