Sunday, February 07, 2010

TCS Technical .Net Interview Questions

TCS Technical FAQs ( .NET , Database , General )


.NET Interview Questions

1. Define .NET architecture

2. Where does ADO.NET and XML web services come in the architecture

3. What is MSIL code

4. Types of JIT and what is econoJIT

5. What is CTS, CLS and CLR

6. Uses of CLR

7. Difference between ASP and ASP.NET

8. What are webservices, its attributes. Where they are available

9. What is UDDI and how to register a web service

10. Without UDDI, is it possible to access a remote web service

11. How a web service is exposed to outside world

12. What is boxing and unboxing

13. What is WSDL and disco file

14. What is web.config and machine.config

15. What is difference between ASP and ASP.NET

16. What is dataset and uses of dataset

17. What does ADO.NET consists of?

18. What are various authentication mechanisms in ASP.NET

19. What do you mean by passport authentication and windows authentication

20. What is an assembly and what does manifest consists

21. What is strong name and what is the purpose of strong name

22. What are various types of assemblies

23. Difference between VB.NET and C#. Which is faster

24. Types of caching

25. How WSDL is stored

26. What is the key feature of ADO.NET compared to ADO

27. How does dataset acts in a disconnected fashion

28. Does the following statement executes successfully:

29.Response.Write(“value of i = ” + i);

30. What is ODP.NET

31. What are the providers available with VS.NET

32. What is a process

33. What is binding in web service

34. How a proxy is generated for a web service

35. About delegates

36. What are static assemblies and dynamic assemlies. Differences between them


Database Interview Questions

37. What are the types of triggers

38. Types of locks in database

39. Types of indexes. What is the default key created when a primary key is created in a table

40. What is clustered, nonclustured and unique index. How many indexes can be created on a table

41. Can we create nonclustured index on a clustered index

42. Types of backups

43. What is INSTEAD OF trigger

44. What is difference between triggers and stored procedures. And advantages of SP over triggers

45. What is DTS and purpose of DTS

46. Write a query to get 2nd maximum salary in an employee table

47. Types of joins.

48. What is currency type in database

49. What are nested triggers

50. What is a heap related to database


General Interview Questions

• HR Interview Questions

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



1 comment:

Unknown said...

hi
pls give answers too if its possible