Principal Interview Questions

Use SQL stored procedures and add variables as parameters to SQlCommand - no SQL string build up

1) GitHub 2) TFS

1) Smoke Testing 2) Unit 3) Integration 4) Scripted (planned testing) 5) System testing. 6) Sanity testing. 7) Interface testing. 8) Regression testing

1) They use Jenkins 2) Hudson 3) TeamCity 4) TFS

1) Use a WEB API for the CRUD actions - insert url into DB and use identity key converted to ToBase64 as the tinyUrl 2) Create a recursive method called IsPalindrome (string word = "") that returns a bool. Because you are defaulting the Null word to an empty string, you do not have to test for NULL, just word.Trim().IsNullOrEmpty() and return false; Return true when length of word is 1. Convert the word to Char{} and determine if the first and last characters are the same, if not - return false if the first and last are the same remove (firsta nd last chars) - if no chars left - return true; If Chars left, convert Char[] back to string and call method again. 3) Use Linq\Lambda to filter Merchant and stores List merchant = new List(); var results = merchant.AsEnumerable().Where(mer => mer.MerchantID == 100 && mer.stores.Any(str => str.StoreType == StoreType.Chinese)).ToList(); using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebApplication1 { public class Merchant { public Merchant() { // default properties or override ctor that takes properties } public int MerchantID { get; set; } public string MerchantName { get; set; } public string MerchantAddress { get; set; } public StoreType MerchantType { get; set; } List stores = new List(); } public class Store { public Store() { } public int StoreID { get; set; } public string StoreAddress { get; set; } public StoreType StoreType { get; set; } public string StoreCity { get; set; } } public enum StoreType { Chinese, Burgers, Tacos } }

Answered by giving and example of a complex that I did

The team wanted to know how I approach the problem, what I look at and drill down. Is the bug in the code, the data, the pre-processing, etc? A quite fun exercise. I solved it, but did not excel at it.