.Net Face to Face interview questions for 3+ Years of experience along with the skills C# .Net, OOPS Concept, ASP.Net and SQL Server

Hi Friends,

A friend of mine has shared .Net Face to Face interview questions for   3+ Years of experience along with the skills C# .Net, OOPS Concept, ASP.Net and SQL Server.. 
Please go through the below questions.

1. Can you give brief introduction about yourself?
2. Can you give brief introduction about your education?
3. What is Garbage Collector?
4. Explain about Garbage collector Generations?
5. What are extensions in C#
6. What are generics in C# and why we use Generics?
7. Can I use two data type variables in Generics & Array lists?
8. What are the uses of Generics?
9. What is the difference between abstract classes and interfaces?
10. Can’t we use abstract for multiple inheritance purpose?
11. What is Var keyword in C#?
12. Can you tell whether Var declares value in compile time or run time?
13. What are the Events & Delegates?
14. What are the uses of Events & Delegates?
15. What is multicast Delegate?
16. What are Single -Tier and N-Tier Applications?
17. Explain about ASP.Net Validation Controls?
18. What is Custom validation control in ASP.Net?
19. ASP.Net controls are server side or client side?
20. Can we use ASP.Net Controls as client side?
21. What is session? Where can we store session object?
22. What is the difference between Trace & Debug?
23. What is Auto generate property in ASP.Net?
24. Can we use validations on Auto generate property in ASP.Net?
25. How many ways can we see the trace?
26. What is cross page posting?
27. What are the indexes?
28. Which type of index will Primary key creates by default?
29. Have you listed any design patterns?
30. What are Isolation levels in SQL?
31. What is CTE in SQL?
32. What is the difference between functions & Stored Procedures?
33. Is function pre-compiled?

                                                                                                         Anu..................

.Net Face to Face interview questions for 6+ Years of experience along with the skills C# .Net, OOPS Concept, ASP.Net, SQL Server, Java Script, WCF, WPF and XML

1. Explain about yourself?
2. What is .Net frame work?
3. What is CLR? 
4. What is garbage collector? Explain about garbage collector?
5. What is managed code & unmanaged code?
6. Is CLR will clear the unmanaged code?  How to clean up the unmanaged code?
7. What is the difference between Finalize and dispose?
8. What is exception handling in ASP.Net?
9. What is finally-block? Which type of code we keep in finally block?
10. What is the difference between Web Services & WCF Services?
11. What is WCF?
12. How many types of bindings are there in WCF and explain them?
13. Which types of bindings you used in your application?
14. What is the difference between basic http binding and WShttp binding?
15. What is the importance of JavaScript?
16. How to capture a text box in JavaScript?
17. Can we call services in JavaScript?
18. Can we call server side coding in JavaScript and how?
19. What are the state management techniques in ASP.Net?
20. Explain different types of sessions?
21. When to use sessions? Where session id will store?
22. What are cookies? What is the difference between cookies and sessions?
23. What is the difference between Interface and abstract class?
24. I have one method in both interface and abstract class? I do have to implement the method in child classes, what is the difference between those two? Which will take less compilation time?
25. Do you know XML? Why we need XML?
26. Write one example for XML?

.Net Face to Face interview questions for 6+ Years of experience along with the skills C# .Net, OOPS Concept, J-Query, ASP.Net, SQL Server, Java Script, WCF and MVC

1. Tell me about yourself?
2. Explain your current roles and responsibilities in your project?
3. How do you rate yourself in C# out of 10?
4. What is JSON? Why we use JSON?
5. We have already JavaScript, why we need JSON?
6. Why we need JavaScript?
7. What is the user of AJAX?
8. What is the difference between Web Services & WCF Services?
9. What is the End Point in WCF?
10. What are the different types of bindings in WCF?
11. Write a Program in WCF including all contracts?
12. How do you rate yourself in SQL Server out of 10?
13. What are triggers? What is the importance of triggers in in SQL Server?
14. How many types of triggers are there and explain?
15. Write a query to get is the 2^nd highest salary in Employee table?
16. What is MVC? Explain Model, View and controller?
17. Where we write methods in MVC?
18. Write a program to reverse a string in C#? E.g.: S=Interview”.
19. What is the state management technics in Asp.Net?
20. What is Client side technology & Server side technology in ASP.Net?
21. What is the difference between functions & Stored Procedures?

Interviewer Expects Our Confidence More Than Our Technical Skills

When I was in B.Tech Final year, I attended campus interview for the first time. We assembled in the auditorium and given brief introduction about their company.

First round:  Written test.

Criteria for written test:

v Should have 75% aggregate from 10^th to B.Tech 3^rd Year

v One backlog in B.Tech was allowed.

v No written test for the students who were having more than 75%  from 10^th to B.Tech 3^rd Year

v I am having more than 75% till B.Tech so I did n’t have written test.

Second Round:  Technical Round

v We were divided into panels and each panel consists of about 20 students.

v My turn was after 17 members, I was waiting for my turn since morning 8.AM to 7.PM. I was little tensed as it was my first interview.

v Finally my turn came at 7 PM.

Few Questions (the Questions would be like):

1.     Tell me about yourself?

2.     Tell me about your family members?

3.     Tell me about your education?

4.     What is your Favorite Subject?

After telling my favorite subject they asked nearly 10 to 15 questions in my favorite subject.

5.     What is your another favorite Programming Language?

I answered C++ and Java then he started again asking questions

1.     Write a Simple program in C++?

I was able to write he is ok with the program.

2.     Then he has given one scenario and asked me to write another program which I was unable to. Then he asked again and again to try but I am only able to explain the logic.

6.     He asked few general questions like politics, games, about family background?

7.     About preferred job location?

In middle of my interview there was a power cut, and then he started asking me related to power.

8.     He has asked me about power formula and some questions regarding physics.

Since I was unable to write the program and unable to answer few questions I am was not confident on the interview, but after some time they announced my name and yeah I was selected for the next round. I felt very happy and was waiting for HR round.

I asked few of my Friends who attended for HR round, they told that HR round is very easy and they were asking about general things like movies, hobbies.

I was waiting with Mr. Perfect Movie story, but as it was already 10’ PM for my turn they asked me to come next day. I was completely in tension for whole night.

I taught that HR round would be very easy. I had another experience than my friends.

1.     Explain your Contributions in the presentations which your have given in the college?

2.     What you know about our company?

3.     Explain about the Android Versions which you know?

4.     Which phone are you using?

5.     I answer Nokia and again he asked which software are they using for Nokia?

6.     Have you read the bond before you signed?

Asked few questions related to bond paper.

I was unable to answer few more questions but he asked me to try and try and I have given some answers but he is not satisfied and he told again to try but I am unable to convince him. Finally he told me all the best and I said thank you and left from there .It was kind of a stress interview.

Since I am unable to answer few questions I am not sure of positive results

Finally, the day has come-the BIG day to announce results of the selected students.

I was not sure I would crack that interview as I did n’t answer few questions. After some time they started announcing results and there was a mini heart attack (tension) as I was not sure of the result. They announced my name. I did n’t expect, I felt very surprised and shouted happily.

I answered very confidently if I know, if I don’t know I said I don’t know. It’s the key point to my success.

Finally I understand that the interviewer expects our confidence more than our technical skills.

We should not expect that interview questions should be same for all.

One of My Friend's Journey From NON- IT to IT

I was working as a Data Analyst in Oil and Gas related company.

I completely worked on domain which includes interpretation and analysis of data and also worked as TL.

I worked for 5 years in the same company but I did n’t find improvement financially. So I decided to move to another company.

One my colleague worked in IT Company he referred me in that company as his replacement.

First Round: I had a technical telephonic round totally related to domain knowledge. I was able to answer all the questions and cleared the first round without any difficulty and the HR informed me the same.

Second Round: I had a round of technical telephonic in this round they have verified my managerial skills.  I cleared this round as well.

Third Round: I had a conference call nearly 45 minutes with three people from different locations. This round was purely technical and domain related. Since I am very good in domain I cleared this round as well.

Fourth Round: I got a call from HR for face to face interview.  After I reached the office they have taken my Id and conducted one more telephonic round. This is related to Job Roles, Project related tasks and managerial skills. I cleared this role but I was completely confused understand the job roles, since it’s not all related to my domain knowledge.  But Manager promised that he will move me to any data management work if possible. So I compromised and ready to join.

Final Round:  Final round is the HR round. I had discussion with HR regarding the Salary she offered me good hike as much as she can offer.
* After considerable taught I accepted the offer. After 3 months I joined in IT.

I observed so many differences between IT and Non-IT

Pros in IT:

1.     Very good work cultures

2.     Friendly Environments

3.     Work from home availability

4.     Can get more and more salary and allowances.

5.     Can easily expose to clients and onsite chances.

Cons in IT:

1.     No time limits have to extend our working hours.

2.     Lot of politics inside team.

3.     No Mental Peace, lot of tension.

4.     No hope for improve my domain knowledge.

5.     Missing personal life.

C#.Net Basics: What is class? How to Declare a Class?

• A class is a construct that enables you to create your own custom types by grouping together variables of other types, methods and Events.
• A class is like a blueprint. It defines the data and behavior of a type.
• If the class is not declared as static, client code can use it by creating objects or instances which are assigned to a variable.
• The variable remains in memory until all references to it go out of scope. At that time, the CLR marks it as eligible for garbage collection.
• If the class is declared as static, then only one copy exists in memory and client code can only access it through the class itself, not an instance variable. 
• Unlike  structs Classes support inheritance , a fundamental characteristic of object-oriented programming.
• Classes are declared by using the class keyword,
• The class keyword is preceded by the access level. The name of the class follows the class keyword.
• The remainder of the definition is the class body, where the behavior and data are defined.
• Fields, properties, methods, and events on a class are collectively referred to as class members.

             Access level class Customer

  {

    //Fields, properties, methods and events go here...

  }

 http://msdn.microsoft.com/en-us/library/x9afc042.aspx

C# .Net OOPS Basics: Classes and Objects.

The terms class and object are sometimes used interchangeably, but in fact, classes describe the type of objects, while objects are usable instances of classes. 

So, the act of creating an object is called instantiation. 

Using the blueprint analogy, a class is a blueprint, and an object is a building made from that blueprint.


Class

class SampleClass
{

}

Object of SampleClass  :

SampleClass objSampleClass= new SampleClass();


For more details: http://msdn.microsoft.com/en-IN/library/dd460654.aspx

.Net Frequently asked questions for 4+ Years of experience having the skills C# .Net, OOPS Concept, ASP.Net and WCF

1. What is sequence of code in retrieving data from database?
2. What is about DTS package?
3. What provider ADO.net use by default?
4. Where does web.config info stored? Will this be stored in the registry?
5. How do you register the dot net component or assembly?
6. What is the Difference between asp and asp.net
7. Which is stateless asp or asp.net?
8. How many types of Authentication mechanisms are there in dot net?
9. What is the State management in asp.net?
10. Which Types of values mode can hold session state in web.config?
11. Explain in detailed about Web Service?
12. What is Http handler?
13. What is view state and how this can be done and was this there in asp?
14. How many Types of optimizations are there and name a few and how do you do?
15. Explain about Data Adapters?
16. Explain the Features of a Dataset?
17. How do you do role based security?
18. What is the Difference between Responses.Expires and Expires.Absolute?
19. How many Types of object are there in .Net?
20. Explain about duration in caching technique?
21. Explain about types of configuration files and their differences?
22. What is the Difference between ADO and ADO.net?
23. Explain in detail about Post back?
24. If you are calling three SPs from a window application how do u check for the performance of the SPS

SQL Server Frequently asked questions for .Net Programmers

1.  What is normalization In SQL Server? 
2.  What is an index and types of indexes? How many numbers of indexes can be used per table in SQL Server?
3.  What is a constraint? How many Types of constraints are there in SQL Server?
4. What are code pages in SQL Server?
5. What is referential integrity in SQL Server?
6. What is a trigger? How many types of triggers are there in SQL Servr?
7. What are different types of joins in SQL Server?
8. What is a self join and Give an Example in SQL Server?
9. Explain Authentication mechanisms in Sql Server?
10. What are the user defined stored procedures?
11. What is INSTEAD OF trigger in SQL Server?
12. How to optimize a query that retrieves data by joining 4 tables?
13. What is the Usage of DTS in SQL Server?
14. How to disable an index using select query in SQL Server?
15. Is non-clustered index faster than clustered index? Why?
16. Explain different types of optimization in queries?
17. What is the difference between ISQL and OSQL in SQL Server?
18. How you log an exception directly into Sql server what is used for this?
19. Explain about Replication in Database?
20. What is the default optimization done in oracle and Sql server?
21. How can I make a column as unique in SQL Server?
22. How many no of tables can be joined in same SQL Server?
23. How many columns can exist per table in SQL Server?
24. Explain about Sql Profiler usage in SQL Server?

.Net Frequently asked questions having the skills C# .Net, OOPS Concept, ASP.Net and WCF

1. What is the Difference between asp and Asp.net?
2. How do you do exception management?
3. If you are using components in your application, how can you handle exceptions raised in a component?
4. Can we throw exception from catch block?
5. How do you relate an aspx page with its code behind page?
6. What are the types of assemblies and where can u store them and how?
7. What is difference between value and reference types?
8. Is array reference type / value type?
9. Is string reference type / value type?
10. What is web.config. How many web.config files can be allowed to use in an application?
11. What is difference between machine.config and web.config?
12. What is shared and private assembly?
13. What are asynchronous callbacks?
14. How to write unmanaged code and how to identify whether the code is managed / unmanaged?
15. How to authenticate users using web.config?
16. What is strong name and which tool is used for this?
17. What is gacutil.exe. Where do we store assemblies
18. should sn.exe be used before gacutil.exe?
19. What does assembly info.cs file consist of?
20. What is boxing and unboxing?
21. How many Types of authentications are there in ASP.NET?
22. What is the difference between Trace and Debug?
23. What is the Difference between Dataset and Data Reader?
24. What is custom tag in web.config?
25. How do you define authentication in web.config?

.Net Face to Face interview questions for 4+ Years of experience along with the skills C# .Net, OOPS Concept, J-Query, ASP.Net, SQL Server, Java Script, and WCF

1. Why you have used Jquery in your project?
2. How you have used WCF in your project?
3. What are ref types and value types in C#
4. int a, b, c;  a=10;  b=a;   c=b ; what are ref types and what are value types
5. In a grid view I have to bind 2000 records without losing performance how
6. In what cases we go for?
7. What is Public sealed abstract class?
8. I have requested a aspx page which contains master page ( along with page load event) and user controls(along with page load event) what is the order of Execution of  aspx  page.
9. Have you used logger concept in application? Which logger concept you have used?
10. What are the Different types of Master Databases in SQL Server?
11. What are magic tables can we access data from magic tables or not
12. How many types can we take back up of database?
13. What is the Page Life cycle of ASP.Net?
14. Write example for singleton pattern?
15. Have you used generic collections? 
16. What is Garbage Collection in .net, how it does Garbage collection
17. What are OOPS Concept in C# Explain All?
18. What is the Difference between abstract classes and Interfaces?
19. How many types of access specifies are there in .net Explain?
20. What is the difference between dataset and data reader?
21. What is the difference between customer controls and user controls?
22. How many joins are there in Sql Server?
23. What are triggers in Sql Server, how many types of triggers are there?
24. What is the difference between clustered index and non clustered index?
25. How many clustered indexes Can we create on a table?
26. What is the difference between temporary tables and table valued elements?
27. What is the difference between assembly and namespace?
28. What is assembly? How many types are there?
29. What is the difference between array, array list and generic, which is faster?  Why?
30. What is boxing and un boxing explain with example?
31. Which concept is useful to display 1,00,000 records in grid view ?

.Net Face to Face interview questions for 3+ Years of experience along with the skills C# .Net, OOPS Concept, J-Query, ASP.Net, SQL Server, Java Script, and WCF

1. Explain your Self, why you want to search for new job
2. What is the Difference between Asynchronous and Synchronous calls
3. What is the Disadvantage of Asynchronous calls
4. What is the Main disadvantage of using Jquery
5. What is the difference between javascript and jquery
6. Give me real time example of Interface and Inheritance
7. What is the architecture in your project
8. How data is coming from database ? where will we give connection string?
9. Have you deployed your project either for testing or live?
10. While deploying how wcf service know which is calling
11. What is interface?
12. What is the main difference the user will feel when we go for ajax
13. Where you are keeping error logger.cs
14. Is Validation Controls Server side or client side
15. There are 2000 records in database I want to bring them in grid with without how to do that.
16. What is Cashe?
17. What are delegates, why we go for them?
18. What are generics? what is  the main advantage of Generics
19. How to handle exception handling in .net
20. Difference between function and stored procedure
21. Can we use one stored Procedure In another
22. In one stored procedure one temporary table is there I have called that stored procedure another stored procedure can I use that temporary table in called procedure.

.Net Face to Face interview questions for 4+ Years of experience along with the skills C# .Net, OOPS Concept, J-Query, ASP.Net, SQL Server, Java Script, and WCF

1. What is Difference between Abstract Class and Interface?
2. What is Static Class?
3. What is Sealed Class?
4. I want same method in child class how to implement?
5. How many types of joins are there in SQL?
6. What is Left outer join, right outer join?
7. What are delegates?
8. By which keyword we will use to inherit a method? And which key word we use in child class tell two methods?
9. Can we create instance of abstract class?
10. What are types of Binding Available in WCF?
11. Why we use basic http bindning?
12. How many types of Contracts are there in wcf?
13. Why to go for wcf service?
14. How to hide a method in wcf service from client?
15. What is data Contract?
16. How to handle exceptions in wcf?
17. Why to use fault Contract?
18. Which type of messages can we send through fault contract??
19. Why we use group by clause?
20. What is difference between function and stored procedure?
21. Have you worked on  Linq to Sql? What is linq to sql?
22. How to bind data to Grid View?
23. Which type of functionality you have worked in Grid View?
24. What is need data source?
25. Have you worked grid inside a grid?
26. Explain Security in WCF Services?
27. Do you Know Default Static Classes available in .Net?
28. How many validation Controls are there?
29. All validation controls run in server side or client side?
30. What is View State?
31. How can we handle exceptions in .net?
32. How to handle exceptions in stored procedures?
33. Can we have multiple catch blocks in one try?
34. What is the order of execution of catch block?

.Net Face to Face interview questions for 3+ Years of experience along with the skills C# .Net, OOPS Concept, J-Query, ASP.Net, SQL Server, Java Script, and WCF

1.  
2. Can you explain the Architecture of WCF?
3. How many Types of Services we can develop by using wcf?
4. How many Contracts are there in WCF?
5. Explain Security in  WCF ?
6. Can you tell life cycle events of Asp.net?
7. Can you explain state management techniques in Asp.net?
8. What is polymorphism? Give one real time example.
9. Why to go for WCF services as we have already web services?
10. What is the difference between Web Services and WCF services?
11. Explain current Project? What is your role?
12. What is the Call back function in JQuery?
13. Why to use Jquery?
14. How declare variables in jquery
15. What is cache? have you worked on it?
16. On which oops concept you have worked?
17. Have you worked on Linq?
18. Is there any split function in sqlserver?
19. What is the difference between Abstraction and Interface?

.Net Face to Face interview questions for 4+ Years of experience along with the skills C# .Net, OOPS Concept, J-Query, ASP.Net, SQL Server, Java Script, WCF , Unit Testing and Lamda Expressions.

1. What is the Difference between abstraction and interface?
2. What is overriding?
3. Which keyword have to use in the parent class?
4. If the method is virtual in parent can I use static for the overridden method
5. If I want to Encrypt the connection string how can I do?
6. What is the difference between session and application?
7. Can you explain page life cycle
8. What will happen in page initialization
9. If we don’t want to inherit particular class what we have to do
10. What is the Architecture of WCF Services?
11. What is the difference between repeater and gridview
12. Can we use update in Repeater?
13. There are 100 pages in my application I want to give permission to one user some pages and  to another user other pages how can I do that
14. What is Delegate? What is Multicaste Deligate
15. How to Generate Public assembly Key?
16. What is Satellite Assembly?
17. What is the Use of Satellite Assembly?
18. When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core application are called satellite assemblies.
19. What is difference between Satellite Assembly and Public Assembly
20. What is difference between delegates and events?
21. What are Asynchronous Delegates?
22. Can we implement Properties in Interface?
23.  

.Net Face to Face interview questions for 5+ Years of experience along with the skills C# .Net, OOPS Concept, J-Query, ASP.Net, SQL Server, Java Script, WCF , Unit Testing and Lamda Expressions.

1. What is difference between Read-only and constant?
2. In what case we go for constant and what case we go for read-only?
3. What is the Difference between overriding or overloading?
4. Can we overload a method with same parameters and different return types?
5. How many times we can over load a method?
6. What is the Key word used to override?
7. What is virtual method?
8. Difference between Virtual Method and Override Method when we go for Virtual and When we go for Override method
9. What is interface? Why to use Interfaces
10. What is sealed class? When to use it?
11. Can you give examples for default interfaces?
12. Can you tell default virtual methods
13. Can you tell default Sealed classes
14. What is JSON? what is the Use of JSON
15. Give one example to write JSON?
16. What is JQuery? Why we use JQuery?
17. Can I use JQuery without Ajax?
18. What is Web.Config? by default what will be there in web.config?
19. How many Web.config we can define for one application?
20. What is Mechine.config? In Default what configurations will be there?
21. If I have copied all the settings  of Mechine.config and kept in Web.config and Deleted Mechine.Config will it work

.Net Face to Face interview questions for 5+ Years of experience along with the skills C# .Net, OOPS Concept, J-Query, ASP.Net, SQL Server, Java Script, WCF , Unit Testing and Lamda Expressions.

1. What is Partial Class? How it will be in compile time?
2. I have declared one method in One partial Class can I use it in another partial class?
3. What is Sealed Class?
4. What is difference between virtual class and abstract class?
5. What is the difference between abstract class and interface?
6. In which scenario we go for abstract and which scenario we go for interface?
7. What is Delegate? Why to Use?
8. Have you know about Lamda Expressions?
9. Have you worked on LINQ?
10. What is the Difference between Master Page and User Defined Function?
11. One Textbox is there in content place holder that textbox value I want in Master Page How to capture it?
12. Which Type of Session Management You have used in Your Application explain in
13. Where Session value will store?
14. Where session Id will Store?
15. What is the State management Techniques in Asp.net?
16. When we request will send to IIS what all the process how html Page will return to you?
17. How to Handle Exceptions in Sqlserver?
18. Have you listen @@Identity in Sqlserver?
19. What is the Difference between stored procedure and Function?
20. Which Design pattern you are working?
21. What are the contracts available in wcf?
22. Why we use fault contract?
23. What is the use of MexHttpbinding?
24. How many types of bindings available in WCF?
25. How can we use WCF Services in our application?
26. What is Service contract in WCF?
27. What is the Difference between Delete and Truncate?
28. Can we delete Primary Key Column from a Table?
29. Have you worked in Multiple Inheritance?
30. I have two interfaces I1,I2  and Written abc method in them now I have inherited those two interfaces and I  have implemented abc  method  will it give error or not? If why? How to do that?
31. How will you do testing in your project
32. Have you written any test cases? On what basis you will write text cases
33. How to deploy project? In Production how you will do?
34. Have you know how to create class diagrams?
35. For what you have use TFS and VSS
36. What is the Team Size of Your project
37. As a Senior Software Programmer what are the Responsibilities you have
38. What is @@Identity and SCOPE_IDENTITY()