Honeywell PLSQL Interview Questions

Honeywell PL/SQL Interview Questions

1. DIFFERENCE between subquries and co-related sub quries..
2. How u find which process is running in unix environment?
3. Whether grep() provide no of times of patrren searching?
4. Difference b/w procedure and function?
5. Joins-----types –with explanation
6. Scenario to find quries using outer joins
7. Highest & lowest salary values
8. Find the second maximum salary
9. Datatypes in sql
10. Package advantages
11. Trigeer –types
12. Nvl function
13. Pragma
14. Cursor types
15. How to debug a procedure
16. Difference b/w union and union all?
17. Without producing a link how u send data to front end manually?
18. How to find how many records it fetched?
19. How u get where error is occurred in code?
20. What is data dictionary?
21. Single row,multi row functions/
22. Difference b/n view and materialized view?
23. Psuedo columns
24. Decode ()
25. Sequence, advantages
26. Explain set operations?
27. Inline function()
28. Difference b/n nullif and nvl2
29. Difference b/n dbms and rdbms
30. Diffence b/n count(1),count(*)
31. PROCEDURE overloading
32. date fuctions?
33. Loops in plsql
34. what is table space?
35. difference b/n having and where caluse?
36. Dis advantages of cursor
37. bulk loader
38. bulk collect
39. triggers/instead of trigger
40. creation of  data base link
41. use of hint
42. What is directory?
43. What is external table?