Technical Interview Question

SQL/PLSQL Questions 
===================

1) What is the use of 'Group By' & 'Having' clause & in your project where you used.
2) What is the use of cursor & types of cursor.
3) What are analytical functions in PLSQL.
4) What are bind variables in PLSQL.
5) What are different types of Triggers.
6) What is the difference between Function & Procedure.


Unix Questions
=============

1) How can you look the content of the file without opening it.
2) What is the difference between touch & cat command.
3) Difference between move & copy command.
4) How to delete a folder with multiple files.
5) If you want to move a set of files from one server to another server. How would you achieve it.


Proc Programs & Shell Scripting
==========================

1) have you complied proc programs.
2) How you have done retofiting for any proc programs.
3) Once you open a proc how it look like & what you will check first in proc program.