SQL/.NET INTERVIEW – Be Ready for an In-person Interview

11 Apr

.NET/SQL interview

Tips for .NET/SQL In Person Interview

  • If you are going for an in person interview then make sure you dress up properly.
  •  Carry some copies of your resume.
  • It is always good to know who is taking your interview .You can always check their profile on LinkedIn.
  • Make sure you visit company’s website and try to gather as much information as you can about the company.
  • Be on time..
  •  Learn more about your potential role, team, and manager and ask questions based on interviewer’s position.
  • Most of the time interviewer is looking to see how you think. They may or may not expect right answers all the time. I strongly recommend you going through these questions and test yourself before you go for the ultimate battle.

1) For the following array:

char[] chars = new char[]{‘H’,’E’,’L’,’L’,’O’};

Reassign the values assigned to the elements of the array in reverse order without using additional memory through generics or additional arrays. You can use temporary variable.

A: Here is one way to do it:

char[] chars = new char[]{‘H’,’E’,’L’,’L’,’O’};
int length = chars.Length;
for (int count = 0; count < (length/2)+1; count++)
{
char temporary;
temporary = chars[count];
chars[count] = chars[length – count-1];
chars[length – count-1] = temporary;}

2) What steps can you take to improve performance of a stored procedure that you know is running slow?

Hint: Think in terms of execution plan, indexing, table scan and seek.

3) What is the difference between MVC and MVP?

4) What is Boxing?

Hint: what happens when you convert an integer to object?
int i = 123;
// The following line boxes i.
object o = i;

5) Are you familiar with Agile methodology?

6) What is the difference between deep copy and shallow copy?
Hint: In shallow copy, the returned object has a reference to the same object. In deep copy, an Object is copied.

7) What is caching? What are different ways of caching in ASP.NET?

8) What are mock-ups?

9 )What is Globalization and Localization?

A: Read here: http://msdn.microsoft.com/en-us/library/c6zyy3s9.aspx

Please feel free to answer these questions in the comment section below. GOOD LUCK.

If you like my post please click “LIKE” button below.

Read about SQL Technical Interview Questions here: Crack the SQL Interview

Anyone on Twitter? Follow @MCADDeveloper @Consultpri
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: