PL/SQL Interview Questions

[coolinterview]

PL/SQL INTERVIEW QUESTIONS   Download Free Interview Questions eBook of 500 Questions (If you do not have a Yahoo! account, you can get it by simply sending a blank email to CoolIntervi...@yahoogroups.com and confirm the verification email received. Once your email is confirmed, we will instantly send the download link to you.) PL/SQL Interview Questions Describe the difference between a procedure, function and anonymous pl/sql block. http://www.coolinterview.com/interview/16946/   Which of the following is not a feature of a cursor FOR loop? http://www.coolinterview.com/interview/16965/   Describe the use of %ROWTYPE and %TYPE in PL/SQL http://www.coolinterview.com/interview/28141/   What is a mutating table error and how can you get around it? http://www.coolinterview.com/interview/18129/   What are the types of triggers? http://www.coolinterview.com/interview/16958/   What is a mutating table error and how can you get around it? http://www.coolinterview.com/interview/16947/   What are SQLCODE and SQLERRM and why are they important for PL/SQL developers? http://www.coolinterview.com/interview/16954/   How can you generate debugging output from PL/SQL? http://www.coolinterview.com/interview/16957/   What packages (if any) has Oracle provided for use by developers? http://www.coolinterview.com/interview/16949/   Describe the use of PL/SQL tables http://www.coolinterview.com/interview/28145/   Describe the use of %ROWTYPE and %TYPE in PL/SQL http://www.coolinterview.com/interview/16944/   Which of the following statements is true about implicit cursors? http://www.coolinterview.com/interview/16966/   When is a declare statement needed ? http://www.coolinterview.com/interview/16952/   Can we assign value to IN parameter inside a pl sql procedure? http://www.coolinterview.com/interview/29232/   Can i use select statement on 2 tables which don't have PK and FK relationship. QUR):- like select * from t1,t1; http://www.coolinterview.com/interview/34143/   What are advantages of trigger in PL/SQL http://www.coolinterview.com/interview/34182/   Describe the difference between a procedure, function and anonymous pl/sql block. http://www.coolinterview.com/interview/18128/   Which set of statements will successfully invoke this function within SQL*Plus? http://www.coolinterview.com/interview/16962/