Principal engineer interview questions shared by candidates
How can you improve the performance of a SQL statement\database
1) Indexes 2) Any field in the Where clause is game to be indexed 3) Limit number of rows\columns returned 4) Limit page scans 5) Use Temp table to loop data instead of Cursors 6) No user functions in the Where clause (if you need them - put on left hand side of equals)
You will be asked to code on paper 3 scenarios 1) Generate a TinyUrl application 2) Generate a method to determine if a word is Palindrome (i.e. Abba or Eye) 3) Generate two class models for two related classes (in memory not DB) , one will hold a Merchant (or some other user's) details and the other class will hole the Stores owned by the merchant. How would you store the data in a session (Application if Web or Cache if desktop) How would you find the Merchants of a particular Name How would you find the stores belonging to a particular Merchant How would you find the stores belonging to a particular Merchant and those stores are in a particular city 4) Given an array of ints, write a C# method to total all the values that are even numbers.