Interview Questions

1.what is the diff b/w fun and procedure?
2.what is the pkg and how to hide the func in pkg and how to others not acess that func?
3.how to call pkged fun in outside.
4.what are the steps in sdlc and u r involed in these areas?
5.it is possible to call proc in select stmt if possile how if not possile why?
6.how to call ur proc or fun in front end application?
7.what are the ways to call func?
8.write a simple fun and proc and pkg;
9.what is encapsulation how it related to oracle.
10.how many years u have exp in dev and supporting.
11.what is exception handling where u have to write and which place u have to write when others stmt?
12.write a query to display number to string
ex:3 it displays three like that.
13.u are invloved in direct intractive with client or ur tl are doing this and mostly u are doing interactive with client through
mail communication or call?
14.how to give ur deved pro or fun to front end apllication.
15.what things ur mind when u are creating table but not to affect any performance issue.
16.what is diff b/w joins and subquerys and which is better performance
17.we have a 10 tables we need to write a query which is better option joins or subquerys.



http://www.youtube.com/watch?v=tcjUVbasDAghttp
http://www.youtube.com/watch?v=yUEWenzR-K8