RelationalDBDesign RelationalDBDesign


Creating Packages   «Prev  Next»

Oracle Package Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. What are the two main components of a package?
Please select the best answer.
  A. Procedure and body
  B. Specification and body
  C. Body and declaration
  D. Private and public

2. Which items can be contained in the package specification?
Please select all the correct answers.
  A. A private function name
  B. A public procedure name
  C. Parameters of a function
  D. Cursor declaration

3. Which of these are an advantage of using a package compared with using stand-alone procedures and functions?
Please select all the correct answers.
  A. Ability to group related procedures and functions together
  B. Simplicity of coding structure
  C. Capability to hide functionality
  D. Ability to define IN and OUT parameters

4. Which of these would be most appropriate use for a private procedure?
Please select the best answer.
  A. A procedure shared among multiple applications during the design phase
  B. A procedure containing calls to other private procedures
  C. A procedure accessible only inside the package body
  D. A procedure with calls to another package