Multiple choice technology databases

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

  1. a) Packages can be nested.

  2. b) You can pass parameters to packages.

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

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

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

Packages are designed to be shared - their contents (specification and body) can be used by many applications and users simultaneously (option D). Information hiding is achieved by declaring constructs in the package body only, making them private and inaccessible outside the package (option E). Packages cannot be nested (option A). Parameters are passed to procedures/functions within packages, not to packages themselves (option B). Packages are loaded once per session and cached, not reloaded each invocation (option C).

Keep practicing — related questions