Keane

• Technical

.NET
* Write steps of retrieving data using ado.net
* Call a stored procedure from ado.net and pass parameter to it
* Different type of validation controls in asp.net
* Difference between server.Execute and response.redirect
* What is Response.Flush method
* How Response.flush works in server.Execute
* What is the need of clinet side and server side validation
* Tell About Global.asax
* What is application variable and when it is initialized
* Tell About Web.config
* Can we write one page in c# and other in vb in one application
* When web.config is called
* How many web.config a application can have
* How do you set language in web.cofig


Database
* How do you rate yourrself in oracle and sql server
* What is E*R diagram
* Draw E*R diagram for many to many relationship
* Design databaseraw er diagram for a certain scenario(many author many books)
* Diff between primary key and unique key
* What is Normalization
* Difference between sub query and nested query
* Indexes in oracle
* Querry to retrieve record for a many to many relationship
* Querry to get max and second max in oracle in one querry
* Write a simple Store procedure and pass parameter to it