NIIT Interview Questions PL SQL

I clear in NIIT PL/SQL vacancies written exam and now I am going to face its interview but here I am very nervous about interview so can tell me which type question ask in interview ?

[Pathak]

I am providing here some interview questions for PL-SQL

1.What is difference between a procedure & function ?
2. Describe the difference between a procedure, function and anonymous pl/sql block.
3. What is a mutating table error and how can you get around it?
4. What packages (if any) has Oracle provided for use by developers?
5. Describe the use of PL/SQL tables
6. Describe the use of %ROWTYPE and %TYPE in PL/SQL
7. When is a declare statement needed ?
8. What are SQLCODE and SQL ERRM and why are they important for PL/SQL developers?
9. In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the NOTFOUND cursor variable in the exit when statement? Why?
10. How can you find within a PL/SQL block, if a cursor is open?
Expected answer: Use the %ISOPEN cursor status variable.
11. How can you generate debugging output from PL/SQL?
12. What are the types of triggers?