Set - 10

Question 16 :

What is Over Loading and what are its restrictions ?

Answer :

OverLoading means an object performing different functions depending upon the no. of parameters or the data type of the parameters passed to it.


Question 17 :

Can functions be overloaded ?

Answer :

Yes.


Question 18 :

Can 2 functions have same name & input parameters but differ only by return datatype ?

Answer :

No.


Question 19 :

What are the constructs of a procedure, function or a package ?

Answer :

The constructs of a procedure, function or a package are :
variables and constants
cursors
exceptions


Question 20 :

Why Create or Replace and not Drop and recreate procedures ?

Answer :

So that Grants are not dropped.