Oracle interview questions | |
1.
| What are the various types of Exceptions ? User defined and Predefined Exceptions. |
2.
| Can we define exceptions twice in same block ? No. |
3.
|
What is the difference between a procedure and a function ?
Functions return a single variable by value where as procedures do not return any variable by value. Rather they return multiple variables by passing variables by reference through their OUT parameter. |
4.
| Can you have two functions with the same name in a PL/SQL block ? Yes. |
5.
| Can you have two stored functions with the same name ? Yes. |
6.
| Can you call a stored function in the constraint of a table ? No. |
7.
| What are the various types of parameter modes in a procedure ? IN, OUT AND INOUT. |
8.
| What is Over Loading and what are its restrictions ? OverLoading means an object performing different functions depending upon the no. of parameters or the data type of the parameters passed to it. |
9.
| Can functions be overloaded ? Yes. |
10.
| Can 2 functions have same name & input parameters but differ only by return datatype |
No. |
0 comments