Birlasoft PLSQL Interview Questions

Birlasoft PL/SQL Interview Questions

1. What is the use of package
2. What is module overloading?
3. What are composite data types.
4. What is the use of record. Why we use record.
5. What is the difference b/w pl/sql record and pl/sql table.
6. What is collection?
7. Difference b/w nested tables and varrays.
8. What is isolation table?
9. What are dead locks.
10. What are shared locks and implicit locks.
11. How many types of cursors we use.
12. What is the ref cursor and how to send unlimited data to front end.
13. Syntax of sql *loader.
14. How to get the data from database to unix environment
15. How to control module over loading.