|
|
| |
|
|
| |
ORACLE INTERVIEW
QUESTIONS |
|
| |
- What are the various
types of Exceptions ?
Answer: User defined and
Predefined Exceptions.
- Can we define exceptions
twice in same block ?
Answer: No.
- 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.
- Can you have two
functions with the same name in a PL/SQL
block ?
Answer: Yes.
- Can you have two stored
functions with the same name ?
Answer: Yes.
- Can you call a stored
function in the constraint of a table ?
Answer: No.
- What are the various
types of parameter modes in a procedure ?
Answer: IN, OUT AND INOUT.
- 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.
- Can functions be
overloaded ?
Answer: Yes.
- Can 2 functions have same
name & input parameters but differ only by return datatype
Answer: No.
PREVIOUS
NEXT |
|
| |
|
|
|
|