DEVFYI - Developer Resource - FYI

ORACLE Interview Questions and Answers

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  51  52  53  54  55  56  57  58  59  60  61  62  63  64  65  66  67  68  69  70  71  72  73  74  75  76  77  78  79  80  81  82  83  84  85  86  87  88  89  90  91  92  93  94  95  96  97  98  99   100  101  102  103  104  105  106 

(Continued from previous part...)

GENERAL INTERVIEW QUESTIONS (1)

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 whereas 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.


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

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


12.Why Create or Replace and not Drop and recreate procedures ?

So that Grants are not dropped.


13.Can you pass parameters in packages ? How ?

Yes. You can pass parameters to procedures or functions in a package.


14.What are the parts of a database trigger ?

The parts of a trigger are:
A triggering event or statement
A trigger restriction
A trigger action


15.What are the various types of database triggers ?

There are 12 types of triggers, they are combination of :
Insert, Delete and Update Triggers.
Before and After Triggers.
Row and Statement Triggers.
(3*2*2=12)

(Continued on next part...)

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  51  52  53  54  55  56  57  58  59  60  61  62  63  64  65  66  67  68  69  70  71  72  73  74  75  76  77  78  79  80  81  82  83  84  85  86  87  88  89  90  91  92  93  94  95  96  97  98  99   100  101  102  103  104  105  106 

ORACLE Interview Questions and Answers