IT:PM:HR/Interviews/Developers

• Read: http://refer.ly/blog/most-revealing-interview-question/
• Matrix: http://www.starling-software.com/employment/programmer-competency-matrix.html

General flow questions:

Largest privately owned IT employer in NZ. Branching out to Australia, Asia.

Talk to us about what's good and bad about it.

Talk to us about your current team.

• Syntax:
  • How would you define a nullable date value (eg: Created/Deleted)?
  • What's the correct type for currencies?
  • How would you join 2 strings?
  • How would you join 10 strings?
  • What's the use of 'using'?
  • What does lock do?
  • What's an abstract class?
  • What's the difference between an abstract class and an interface?
• Concepts:
  • Difference between a value type and reference type?
• Debugging:
• Web:
  • What's the difference between GET/POST. When should I use either one?
• Asp.NET:
  • What's a good thing about ASP.NET versus a risk of using ASP.NET?
    • Define core concepts of WebForm development.
  • Ever used MVC?
    • Define core concepts of MVC development.
• CSS:
  • How do you make a div's text blue?

    • What about it's background?
    • Border?
• Connection strings:

  • Where would it be in the config file.
  • What's a datasource?
  • What's a default catalog?

  * Database

  • Talk about what you know of datareaders, datasets,

    • Would you use a reader to return one value, from one row?

    * WebMethods?

  • WCF?
• LINQ
  • Ever used? Your opinion?
  • Select All Contacts in Wellington.
• XML:
• Source control:
  • TFS? SVN?
  • What's a branch? trunk? releases?

• Gen:
  • Dif between class and struct?

    • Describe the “protected” modifier.
    • Try/Catch for a specific error? Catch all? In all cases?
    • Explain IDisposable and using statement.

    Describe (generics):

    public class Foo<T> { public T Bar {get;set;} }

Describe (nullable):

private int? i;

Describe (linq):

 
  var y = from x in colleciton select new {x:Foo};

* Sql:

• Descrive diff between Primary and Unique Key:
• What function would you use to add a month to date?
• Difference between DELETE <TableName> and TRUNCATE TABLE <tableName>?
• What are the steps for improving a poor query's performance?
• What does @@ROWCOUNT do?
• For what reason would you use a Guid as a primary key? Any issues with it?

Given:

 CREATE TABLE Employee (ID int, ManagerId int, Name varchar(100))

What would the following give:

 SELECT e.NAME AS EMPLOYEE, ISNULL(m.Name, "N/A") AS MANAGER
 FROM Employee e
  LEFT JOIN Employee m on e.ManagerId = m.Id

• Web Dev:
  • Talk about some concerns of webdevelopment. THings to watch out for.

    • Talk about Ajax.
    • JQuery
    • What's the syntax for a Selector of a div with Id “div1”
    • What's the syntax for a selector for all divs with class “alert”
    • Can you hide all divs with class=alert?

    * LINQ:

  • LINQ: Take 3rd page of 10 records of First/Last from all Contacts living in Wellington.
• Unit Tests?
  • Do you know what they are? Why they are important?
• WCF:
  • Ever used?
• Team:

* General:

• given int X =3,Y=4, how can one swap the two without using another variable?

* Unit Tests

• Which framework have you used.

* LINQ: Take 3rd page of 10 records of First/Last from all Contacts living in Wellington. * WCF:

• Go crzy telling us what to watch out for, etc.

* Describe more patterns. * Describe a small solution. Blog, or Wiki.

• Need to create a basicHttp connection between one server and another. It's not working. Start from basics, and describe how you would think your way through finding out why not.