TCS

• Technical
.NET
* Define .NET architecture
* Where does ADO.NET and XML web services come in the architecture
* What is MSIL code
* Types of JIT and what is econo*JIT
* What is CTS, CLS and CLR
* Uses of CLR
* Difference between ASP and ASP.NET
* What are webservices, its attributes. Where they are available
* What is UDDI and how to register a web service
* Without UDDI, is it possible to access a remote web service
* How a web service is exposed to outside world
* What is boxing and unboxing
* What is WSDL and disco file
* What is web.config and machine.config
* What is difference between ASP and ASP.NET
* What is dataset and uses of dataset
* What does ADO.NET consists of?
* What are various authentication mechanisms in ASP.NET
* What do you mean by passport authentication and windows authentication
* What is an assembly and what does manifest consists
* What is strong name and what is the purpose of strong name
* What are various types of assemblies
* Difference between VB.NET and C#. Which is faster
* Types of caching
* How WSDL is stored
* What is the key feature of ADO.NET compared to ADO
* How does dataset acts in a disconnected fashion
* Does the following statement executes successfully:
Response.Write(“value of i = ” + i);
* What is ODP.NET
* What are the providers available with VS.NET
* What is a process
* What is binding in web service
* How a proxy is generated for a web service
* About delegates
* What are static assemblies and dynamic assemlies. Differences between them

Database
* What are the types of triggers
* Types of locks in database
* Types of indexes. What is the default key created when a primary key is created in a table
* What is clustered, non*clustured and unique index. How many indexes can be created on a table
* Can we create non*clustured index on a clustered index
* Types of backups
* What is INSTEAD OF trigger
* What is difference between triggers and stored procedures. And advantages of SP over triggers
* What is DTS and purpose of DTS
* Write a query to get 2nd maximum salary in an employee table
* Types of joins.
* What is currency type in database
* What are nested triggers
* What is a heap related to database

General

• HR
* About yourdelf
* About procsses followed
* Notice period
* Appraisal process
* What is SOAP and why it is required
* About effort estimation
* Whether salary negotiable
* Why are looking for a change
* How fo you appraise a person
* Do you think CMM process takes time
* About peer reviews
* How do you communicate with TL / PM / Onsite team