PL SQL Oracle Interview Questions [237 Questions]

  1. Pipe Function and Mutating Trigger1) Why we use pl/sql array rather than cursor?
    2) In which condition we use function overloading?
    3) What is pipe function?
    4) What is the mutating trigger? What should be the condition?
  2. Procedure ParametersWhat is call by value and call by reference in parameters (IN, OUT, INOUT)?
  3. Explicit cursor and Select into statementwhat is the difference between an explicit cursor and select into statement?
  4. Indexed Select StatementHow can we find the select statement is indexed or not?
  5. TCL Statements in TriggerWhy are we not supposed to include TCL statements in a trigger?
  6. You must first Login or Register to view all 237 questions from this category.


    Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.