Set - 5

Question 76 :

What are the modes of parameters that can be passed to a procedure ?

Answer :

IN,OUT,IN-OUT parameters.

Question 77 :

Where the Pre_defined_exceptions are stored ?

Answer :

In the standard package.
Procedures, Functions & Packages ;

Question 78 :

Write the order of precedence for validation of a column in a table ?
I. done using Database triggers.
ii. done using Integarity Constraints.

Answer :

I & ii.

Question 79 :

Give the structure of the function ?

Answer :

FUNCTION name (argument list .....) Return datatype is
local variable declarations
executable statements
execution handlers

Question 80 :

Explain how procedures and functions are called in a PL/SQL block ?

Answer :

Function is called as part of an expression.
sal := calculate_sal ('a822');
procedure is called as a PL/SQL statement
calculate_bonus ('A822');
What are advantages fo Stored Procedures?
Extensibility,Modularity, Reusability, Maintainability and one time compilation.