Placement Papers - Keane

Job Interview Placement Paper At Keane on October 2003

Technical Section:

.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 Section:
  - 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