CoolInterview.com - World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies


  • Advertisements PL-SQL Interview Questions
    COOLINTERVIEW.COM ORACLE INTERVIEW QUESTIONS PL-SQL INTERVIEW QUESTIONS QUESTIONS LISTING

    PL-SQL Interview Questions & Answers

    Below we have listed all the PL-SQL Interview Questions and answers. Feel free to comment on any PL-SQL Interview Questions or answer by the comment feature available on the page.

    To buy an eBook containing 9000 Interview Questions, with Answers, Click Here.

    1 2 3 4 5 6 7 8 9 10 11 Next

    Sort By :   Latest First  |  Oldest First  |  By Rating

    Question
    Rating
    View Answer
    State the difference between implicit and explicit cursor's.
    View Answer
    How to avoid using cursors? What to use instead of cursor and in what cases to do so?
    View Answer
    What is trigger,cursor,functions in pl-sql and we need sample programs about it?
    View Answer
    What is difference between stored procedures and application procedures,stored function and application function?
    View Answer
    What is pl/sql?what are the advantages of pl/sql?
    View Answer
    What is Raise_application_error ?
    View Answer
    Explain the usage of WHERE CURRENT OF clause in cursors ?
    View Answer
    How we can create a table in PL/SQL block. insert records into it??? is it possible by some procedure or function?? please give example...
    View Answer
    1)What is the starting "oracle error number"? 2)What is meant by forward declaration in functions?
    View Answer
    Name the tables where characteristics of Package, procedure and functions are stored ?
    View Answer
    How to disable multiple triggers of a table at at a time?
    View Answer
    In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
    View Answer
    How many types of database triggers can be specified on a table ? What are they ?
    View Answer
    Can Commit,Rollback ,Savepoint be used in Database Triggers?If yes than HOW? If no Why?With Reasons
    View Answer
    In pl/sql functions what is use of out parameter even though we have return statement.
    View Answer
    Explain how procedures and functions are called in a PL/SQL block ?
    View Answer
    How to debug the procedure ?
    View Answer
    What will the Output for this Coding? Declare Cursor c1 is select * from emp FORUPDATE; Z c1%rowtype; Begin Open C1; Fetch c1 into Z; Commit; Fetch c1 in to Z; end;
    View Answer
    Explian rowid,rownum?What are the pseduocolumns we have?
    View Answer
    State the advantage and disadvantage of Cursor?
    View Answer

    1 2 3 4 5 6 7 8 9 10 11 Next

    A D V E R T I S E M E N T





    User Options
    Sponsored Links


    Copyright ©2003-2014 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes


    Cache = 0 Seconds