Exercise

Set - 1 Set - 2 Set - 3 Set - 4 Set - 5 Set - 6 Set - 7 Set - 8 Set - 9 Set - 10

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.