PLSQL, Oracle interview questions

1. Difference between views and materialized views?
2. Can we update views?
3. What do you know about collections?
4. Difference between procedure and functions?
5. can we create a package body without creating package specification?
6. How do you call a function from a package?
7. difference between NVL and NVL2 function?
8. Can we use user defined functions in select statement?
9. What do you mean by mutating error?
10. How many types of exceptions you know?
11. How do you create an user defined exception?
12. Can you use commit command inside a PLSQL procedure block?
13. Why bulk collect is used?
14. Explain implicit cursors?
15. What do you mean by reference cursor?
16. What do you mean by dynamic SQL?
17. Give practical example of functions?
18. Can you call a procedure from a function?
19. How many types of joins you know, explain left outer join.
20. What do you mean by index in SQL?
21. Explain Foreign key?
22. find nth highest salary from employee table.
23. how can you update multiple values in a table?
24. What do you mean by DB Dictionary?
25. What do you understand by archive in SQL?