CSS PLSQL Interview Questions

CSS PL/SQL Interview Questions

1. Tell me about your self
2. What is index?
3. How does index form internally?
4. What are pseudo columns?
5. What are exceptions? How to handle expections in PL/SQL?
6. Explain about exception propagation?
7. What is autonomous transaction?
8. What is trigger? Have you ever used it?
9. Define view
10. Can we update a view?(what are the conditions)?
11. if I have created view from two tables by taking all the columns in the table now is it possible to update that view?
12. then I have to compulsory update that view how to do that?
13. What is instead of triggers?
14. what is syntax of case?
15. Difference between procedure and functions?
16. What is a package and what are its advantages?
17.  What are the Sqlca structure elements?
18. select duplicate records from a emp table?
19. Select Nth maximum salary from emp table?                                        
20. Why PL/SQL
21. Why package?
22. Why Triggers while you are having Constraints
23. Types of Triggers and Mutating Triggers
24. Examples for statement level and row level triggers
25. Bulk-fetch and bulk binding
26. What are the options that you use while pre-compiling a Pro*C program and why?
27. All about cursors
28. What is the need of Error Handling in PL/SQL and how will you do it
29. Write queries for deletion of duplicate records and nth max salary
30. Search and Replace in UNIX
31. Find syntax
32. Grep syntax
33. Copy all the fields from the result of ls –l command into different host variables and insert them into a database object
34. Describe materialized view
35. I/O redirection
36. Why Locks and different types of locks
37. Autonomous transaction
38. Referential Constraint