PL/SQL Parameters   «Prev  Next»

IN, OUT, and IN OUT Parameters - Exercise

Matching Parameter Modes

Objective: Match the parameter mode with the coding scenario
Match items in the left column with the items in the right column. click the Submit button to continue with the course. In the left column below are four parameter modes and their corresponding scenarios in the right column. When you think you have all of the parameter modes and their scenarios matched correctly, click the Submit button and you will see whether or not you have matched the terms correctly.
When you have completed the exercise, click the Submit button to see the correct answers.

Exercise Scoring

You will receive four points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.
Associate elements in one column with elements in the other column.
Parameter Type Purpose and Definition
  1. IN
  2. OUT
  3. IN OUT
  4. No parameter
  1. Your procedure looks at data and then sends a single value to the calling program.
  2. Your procedure processes some information based on the current date, which it gets from the database.
  3. Your procedure updates records based on an incoming value of a record key
  4. Your procedure receives a value, modifies it, and sends it back to the calling program.