Placement Papers - Estuate

One year Experience.

Technical Interview:
1) Tell me about yourself.
2) My role and responsibilities in my project.
3) What is a join and different types of join?
4) What is the view and write syntax of that?
5) What is an Index and what are the different types of Index?
6) What is sequence and if the sequence has start and limit so once it reached limit what will happen. How it return back?
7) Gave one query to write.
8) Wrote one query and asked to find out the error in that query.
9) What is package and explain about it.
10) What is an exception?
11) What is cursors and different types of cursors?
12) What are cursor attributes?
13) How will you store DRIS information in your application?
14) Why don't you run the script instead of sending to the Pase team?
15) Write a query to display the names of employees who have joined the month of December 2014.
16) Write a query to display the first name as characters and the last name as numbers.
17) Write a query to display the name of employees who do not belong to the particular department.
18) Difference between delete, drop, truncate?