Vayana PLSQL Interview Questions

Vayana PL/SQL Interview Questions

1. What is method using export the data from database to excel file?
2. We are using UTL_FILES TO export the data from database to excel file
3. What is Migration?
4. What type of migration you are using
5. What is database link, what command used, permissions
6. What is source control you are using in your current project?
7. Why it is called a stored procedure
8. What are the features in oracle 10g
9. Do you know about inline view? (TOP-N ANALYSIS)
10. What is autonomous transaction?
11. What is exception?
12. What are predefined exceptions?
13. Can we use commit in trigger
14. What is mutating trigger
15. Difference between procedure and function