.NET, C# ,SQL Server Interview Questions

Posted Date: 22-Jun-2012	Category: Technical Interviews
Author: Raman S V	Member Level: Bronze	Points: 10

I attended interviews on .NET. I faced some 4 tecnical interviews. Some, I cleared and some I did not. Thought it would be useful if I post the questions.Here, I have compiled a list of all the questions in 4 interview questions. I think I have covered most of them.

Below questions I faced in 4 interviews. I have compiled them and written here.

Questions :

.NET and OOPS :

What are different models of programming ?

What is structured and object-oriented programming?

What is abstraction and interface? Differences between them. (faced this in 3 interviews)

what are the uses of abstract classes and iinterface. In which situation , you will use abstract class and when interface

What is inheritance and can you inherit from 2 classes.

Can you call a parent class method from child class object?

what is a constructor and its uses?

what is a sealed class?

what is a generic class (got this in almost every interview)

why is generics used?

what are data structures?

Differences between sortedlist and hashtable.

what is a dictionary?

what happens if there are duplicate keys in a dictionary?

what are extension methods and lambda expressions?

what is an assembly?

what are private and shared assemblies?

what is gac?

how a assembly is registered in gac?

what is a stong key?

what is a com component and how is it used in .NET framework as in how does the .net framework works with it?

what is serialisation and deserialisation, its uses and different types of serialisation?

what are appdomain and apppool

what is connection pooling

describe ADO.NET , how does it function?

differences between datasets and datareaders, give situations in which each one will be advantageous to be used?

differences between xml and html

can we have custom tags in html and is it necessary to close tags in html

how to populate a tree view control from an xml

different types of parsers for xml and code samples for it.

difference between dataset clone() and copy()

what is a delegate, why is it used and its advantages?

what are events, relation b/w events and delegates

what are threads, why is it used

what are optional parameters and give the code for that

In one interview, he gave me a situation where an application has some 20 classes implementing an interface. Later at some point of time, a class needs one extra method to be added (new functionality). So, what will be your approach? Will you add the method signature to the interface and implement it in all the classes?

what are design patterens?

what is a singleton and factory pattern?

MS SQL Sever :

what is an index?, types of indexes (clustered and non-clustered) and describe each

what are constraints in sql

how to remove duplicate records in a table

how to get the second highest value in a column from a table

what is a stored procedure, trigger and a function

Regards,
Raman S V

Post Comment:

Notify me by email when others post comments to this article.

Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.

No HTML formatting and links to other web sites are allowed.

This is a strictly moderated site. Absolutely no spam allowed.

Name:	Sign In to fill automatically.
Email:	(Will not be published, but required to validate comment)
	Type the numbers and letters shown on the left.

Online Members

.NET, C# ,SQL Server Interview Questions

Post Comment:

Email subscription