Question 11 :
What is the difference between a procedure and a function ?
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 ?
Yes.
Question 13 :
Can you have two stored functions with the same name ?
Yes.
Question 14 :
Can you call a stored function in the constraint of a table ?
No.
Question 15 :
What are the various types of parameter modes in a procedure ?
IN, OUT AND INOUT.