PL/SQL related interview questions

1. difference between procedure and function
2. why packages are used
3. You are the tech lead and you need to suggest some code changes to a team member , how will u do it. Will you do it yourself or assign it to them
4. How do u do a code release
5. how will you suggest design changes to database architect if you think your design is better
6. rate yourself 1 to 5 in shell scripting skills
7. asks about education , overall experience
8. give an example of challenge faced in development project
9. error handling in oracle pl/sql
10. how will u tune a slow performing query
    
11. have u used pragma's and where in what scenario
12. how to run a sql query in lets say 10 instances running on the same machine (using shell scripting). How to check if the instance is up from command line.