# IT:PM:HR/Interviews/Developers #



<callout type="Navigation" class="small">

* [[../|(UP)]]
{{indexmenu>.#2|nsort tsort}}


</callout>


<panel title="Summary">



</panel>


## Resources ##

* Read: [http://refer.ly/blog/most-revealing-interview-question/](http://refer.ly/blog/most-revealing-interview-question/)
* Matrix: [http://www.starling-software.com/employment/programmer-competency-matrix.html](http://www.starling-software.com/employment/programmer-competency-matrix.html)

## Process ##

General flow questions:


#### What do you know about this company? ####

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


#### Current Place ####

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

#### Current Team ####

Talk to us about your current team. 


#### Why are you interested in joining this company? ####



#### Junior ####

* 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?
    * 



#### Int ####

* 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:



#### Senior ####
* 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.



### Problem solving ####

* 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.