Oracle, DBA, Developer Candidates

0. Describe the difference between a procedure, function and anonymous pl/sql block

1. What is a mutating table error and how can you get around it?

2. Describe the use of %ROWTYPE and %TYPE in PL/SQL

3. What packages (if any) has Oracle provided for use by developers?

4. Describe the use of PL/SQL tables

5. When is a declare statement needed ?

6. 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?

7. What are SQLCODE and SQLERRM and why are they important for PL/SQL developers?

8. How can you find within a PL/SQL block, if a cursor is open?

9. How can you generate debugging output from PL/SQL?

10. What are the types of triggers?