Quantcast
Saturday 27 april 2013 6 27 /04 /Apr /2013 10:37

Introduction

 

When you are attending programming interviews you will always see a specific pattern in which the interviewer asks questions. It’s always good to know about this pattern so that you can perform well during interviews. I term this pattern as “What”, “Why “and “How” pattern .

 

“What” :- Do you really know the topic.
 

99% times a logical interviewer starts with “What” first. He tries to get a sense that do you at least have an idea of the topic. For instance let’s say the topic is “Delegate”. So the first question he would spin is “What is a delegate ?”.

 


In “What” kind of questions the interviewer is expecting sweet and to the point one liners which communicates that yes you know the topic. For example:-

 

Interviewer :- What is a delegate ?

Jobseeker :- Delegate is a pointer to a function.

 

“How”:- Are you hands on?

Once the interviewer is confident with the “What” part he can then ask questions of type “How” and “Why”. The “how” part tells the interviewer, Are your really hands-on the topic?.  Below is a simple example for the same:-

Interviewer: - How do you do forms authentication in ASP.NET?
JobSeeker :-  For forms authentication we need to do the following things :- 

Step 1:- Set the mode=”Forms” in web.config file.

Step 2:- In the code behind of the login page we need to call
“FormsAuthentication.RedirectFromLoginPage” function.

 
In the “How” part the interviewer is expecting you to provide overall important steps of you will execute that task.
 
“Why”:- Do you really know the depth of the topic?

The “Why” part of questions are tough ones. In this the interviewer tries to probe how much do you know the topic.  In this section he will probe in to real time scenarios and will try to probe do you know the topic in-depth.

For example:-

Interviewer: - Why is MVVM pattern for WPF and SL?
Candidate: - Because WPF and SL have rich bindings.

A simple example of questions around delegate

What is a delegate?
Delegate is a pointer to a function.

How do you code a delegate?
We first declare the delegate by using the “Delegate” keyword and point method to that delegate and then invoke the method by calling the “Invoke” method.

Why do you need a delegate?
Delegate is needed to provide callbacks. For instance you have a UI from which a long running routine is called. If your UI wants updates from that long running routine, then the UI can provide a delegate to the routine and the routine can send message via that delegate back to UI.

 
whw-copy-1.jpg


Some references for preparing .NET interviews:-

 

 

By Shivprasad koirala - Posted in: C# interview questions
Enter comment - View the 0 comments
Thursday 11 april 2013 4 11 /04 /Apr /2013 10:58

Many times we would like to store hierarchal data in database. For example you can see in the image we can have manager, supervisors who work below managers, workers who work under supervisor and so on. This kind of data can be stored by using “hierarchyid” datatype in SQL Server.  It’s also called “Hid” data type. By using this data type we no more need those recursive logic to get the parent  and also we do not need to get involved with complex self reference parent child kind of database design.

 

 

EMP.png

 

 

Also have a look at the below SQL Server interview question videos

 

Increase SQL Server performance using SQL Server profiler: -

 

 

 

SQL Server interview question video: - What are page split’s in SQL Server ?

 

For more SQL Server interview questions and answers visit www.questpond.com

By Shivprasad koirala
Enter comment - View the 0 comments
Saturday 9 march 2013 6 09 /03 /Mar /2013 09:24




In this video we will try to understand 1 to many relationship between customer and hobbies. 


Regards,

 

Click here to view more  C# and .NET interview question and answers 
By Shivprasad koirala
Enter comment - View the 0 comments
Saturday 9 march 2013 6 09 /03 /Mar /2013 09:21




In this video we will try to improve database design by applying database normalization rules. We will try to convert the DB design by applying 3rd normal forms.


Regards,

 

Click here to view more  C# and .NET interview question and answers 
By Shivprasad koirala
Enter comment - View the 0 comments
Saturday 9 march 2013 6 09 /03 /Mar /2013 09:17




In this video we will try to understand how we implement validations using regex ( Regular expressions).

 

Regards,

 

Click here to view more  C# and .NET interview question and answers

 

By Shivprasad koirala
Enter comment - View the 0 comments

Important .NET and C# interview questions and answers

.Net interview questions: - Explain why it is not preferred to use finalize for clean up?

.Net interview questions: - Show the five levels in CMMI?

.NET interview questions and answers: – Which is the best place to store connection string in .NET projects?

C# interview questions and answers: – Explain the use of Icomparable in c#?

C# interview questions: - How can we check which rows have changed since dataset was loaded?

C# interview questions and answers: - Can you write a simple c# code to display Fibonacci series?

.NET interview questions and answers: - What is difference betweenIcomparable VS Icomparer ?

C# and .NET interview question: -What is short circuiting in C#?

C# and .NET interview question: - What are symmetric and asymmetric algorithms?

Important c# and .NET interview question on object pooling and Gridview events?

.NETinterview questions and answers: – Will the finally run in this code?

How to prepare for c# and .NETinterviews?

C# and .NET Interview questions: - What is Thread.Join () in threading?

.NET Interview questions and answers: -What is serialization and deserialization in .NET?

C# and .NET interview question: - What is hashing?

c# and .NET interview question:- what connects dataset and data source ?

.Net interview questions and answers: - What is the difference between “Web.config” and “Machine.Config”?

.NET interview questions and answers: - What is TPL?

.NET Interview questions and answers: -What are different access modifiers?

.NET and c# Interview Question and answers: – If we want to update interface with new methods, what is the best practice?

 MVC ( Model view controller) interview questions and answers      

ASP.NET Application and Page Life Cycle 

12 Important FAQ’s on VSTS Testing (Unit testing, load testing, automated testing, database testing and code coverage) 

 6 important use of Partial/Mock testing

6 important uses of Delegates and Events

7 Simple Steps to Run Your First Azure Blob Program

8 Steps to Create Workflows using SharePoint Designer

Azure FAQ Part 1

C# Code Reviews using StyleCop – Detailed Article

Four real world uses of Partial classes and Partial methods

SharePoint Quick Start FAQ Part 1

SharePoint Quick Start FAQ Part 6 – Workflows, Workflows and Workflows

SharePoint Workflow Basics

 

 

 

 

. NET and C# interview questions videos

Algorithm Interview Questions

Algorithm interview questions and answers: – Can you write code for bubble sort algorithm?

Algorithm interview questions and answers: – What is inserted sort algorithm?

ASP.NET Interview Questions & Answers Article







 

SQL Server Interview Questions & Answers Article

 

SQL Server Interview Questions & Answers Article

SQL Server interview questions and answers: - What is HID data type in SQL Server ?

 

.NET INTERVIEW QUESTIONS & ANSWERS ARTICLE

 

.NET interview questions and answers: - How to reverse a string in .NET ( DotNet)?

.NET interview questions and answers: - What is the use of Click Once?

.NET interview questions and answers: - Will the below codes create new instances?

C# and .NET interview questions with answers – What is Nuget?

Dependency injection (DI) VS Inversion of Control (IOC)

.NET interview questions with answers: - What is the difference between Reflection and Dynamic?


WPF INTERVIEW QUESTIONS & ANSWERS ARTICLE

 

6 important WPF and Silverlight Multi-threading interview questions with answers


Create your blog for free on over-blog.com - Contact - Terms of Service - Earn Royalties - Report abuse - Most commented articles