Technical Sample Questions : C |  C++ |  Oracle |  Java | Unix |  Operating Systems |  Data Structure

Oracle Sample Questions ›› Oracle Interview Questions

Technical Sample Questions

Oracle Sample Questions : Oracle Interview Questions

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

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

    Answer: So that Grants are not dropped.

33. Can you pass parameters in packages ? How ?

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

34. What are the parts of a database trigger ?

    Answer: The parts of a trigger are:

    • A triggering event or statement
    • A trigger restriction
    • A trigger action

35. What are the various types of database triggers ?

    Answer: There are 12 types of triggers, they are combination of :

    • Insert, Delete and Update Triggers.
    • Before and After Triggers.
    • Row and Statement Triggers.

36. What is the advantage of a stored procedure over a database trigger ?

    Answer: We have control over the firing of a stored procedure but we have no control over the firing of a trigger.

37. What is the maximum no.of statements that can be specified in a trigger statement ?

    Answer: One.

38. Can views be specified in a trigger statement ?

    Answer: No

39. What are the values of :new and :old in Insert/Delete/Update Triggers ?

    Answer: INSERT : new = new value, old = NULL
    DELETE : new = NULL, old = old value
    UPDATE : new = new value, old = old value
    

40. What are cascading triggers? What is the maximum no of cascading triggers at a time?

    Answer: When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading.Max = 32.