SONY PLSQL Interview Questions

SONY PLSQL Interview Questions

1. Introduce about your self.
2. Tell me about your project.
3. For what purpose you are used pro*c in your project.
4. What is a package, advantages and disadvantages of packages?
5. What is a procedure and function.
6. Display the duplicate records in table.
7. What is meant by overloading.
8. What is meant by one time procedure.
9. What is meant by function purity levels.
10. What is meant by for update clause.
11. What is meant by dynamic sql.
12. What are the types of exceptions in pl/sql.
13. What is meant by raise_application_error.
14. What is meant by utl_File.
15. What are the exceptions are there in utl_file.
16. What is the structure of varchar.
17. What is the structure of sqlca.
18. What is meant by whenever statement.
19. How to embeded the pl/sql block in proc.
20. How can you declare the cursor in proc.
21. What is meant by ps command in unix.
22. How to search the pattern.
23. How to search a file in particular directory.
24. What is meant by normalization.
25. How many types of triggers can be created on a table .
26. Explain your project
27. File uploading and generation in pro*c in detail with code.
28. Host array.
29. Indicator variable.
30. How do you compile pro*c program.
31. What are the files create when you compile pro*c program
32. Unit testing plan
33. Difference between procedure, function and package
34. Advantages of package
35. Disadvantages of package
36. Methods in pro*c in detail with code
37. Sqlca in detail
38. Can we write ddl statements in procedure
39. What is table mutating? When do you get it?
40. What is the use of cursor? What are different types of cursors?
41. What is ref cursor? Have used it
42. Correlated subquery? With example?
43. How do you declare cursor in pro*c
44. Bulk binding.
45. In a procedure I have written dml statement with in the loop and issued commit with in the loop. What will happen?
46. Have you talked to your client
47. Have you prepared any documents