Set - 10

Question 11 :

What is the difference between a procedure and a function ?

Answer :

Functions return a single variable by value whereas procedures do not return any variable by value. Rather they return multiple variables by passing variables by reference through their OUT parameter.


Question 12 :

Can you have two functions with the same name in a PL/SQL block ?

Answer :

Yes.


Question 13 :

Can you have two stored functions with the same name ?

Answer :

Yes.


Question 14 :

Can you call a stored function in the constraint of a table ?

Answer :

No.


Question 15 :

What are the various types of parameter modes in a procedure ?

Answer :

IN, OUT AND INOUT.