2. What is difference between process and thread and give examples?
3. What is variable scoping?
4. How many lines of code you have written in your current application that you are working on? What best practices you follow while developing softwares?
5. Why you want to apply for SDET position in Microsoft and asked what testing techniques you apply while development?
CRM Microsoft Interview Questions
1.Who are the newcomers to the CRM landscape?
2.How is CRM changing and what does the business owner need to be aware of?
3.How much should I plan to spend on a good solution?
4.What are your expectations for CRM in the next five years?
5.What exactly should I be expecting CRM to do for me?
6.Do you have a few key best practices someone considering CRM can use?
7.What are the most common mistakes you see companies make with CRM?
8.What are my best resources for finding out more about CRM?
9.What advantages might CRM have for specific verticals?
10.Does CRM fall more to sales or marketing in most organizations?
Wikipedia Microsoft Interview questions Collection
Surprised to see below are interview questions of Microsoft collected by Wikipedia
*Design a cellphone for a blind person.
* Design a music system for a car. What are the features? Draw a picture.
* Design a GPS navigation unit for a hiker
* Design a communication device for Canadian park rangers.
* Design a remote control for an automatic window-blind system.
* Design TV Remote Control with Two Buttons.
* Design a coffee maker that will be used by astronauts.
* Design an alarm clock.
* Design an alarm clock for a blind person.
* Design a search function
* Design a website for a library
* What method would you use to look up a word in a dictionary?
* What are examples of poorly designed software?
* Design an instant messaging system.
* I am your grandmother. Describe what MATLAB is to me.
* How would you explain what a database is to a 5-year-old?
* How would you explain computer networking to a kindergarten kid?
* What is your favorite software, and how would you improve it?
* Write code for an electronic messaging board. What happens when a user logs on?
* Develop an algorithm for selecting objects in Visio.
* Tell me about a time when you made a decision and later found out that it was incorrect. What did you do to resolve the issue?
* Suppose you are one week away from the product shipping date and discover a bug in your software. What do you do?
* You have a linked list and don't know how long it is; how do you find the middle of it?
* How would you test a keyboard?
* How would you test a pen?
* Write code for finding a duplicate in an array.
* Write code that returns the length of a string without using any built-in functions.
* Reverse a Singly Linked List with and without using Recursion.
* Determine if a Binary Search Tree is well formed.
* Reverse every word in a String (abc def becomes cba fed).
* What method would you use to look up a word in a dictionary?
* Write a function that returns the angle between the hour and the minute hands of a clock, given input of the time.
* Write a function that takes a string consisting of numeral characters and returns all possible alpha character strings of same length as input that correspond to the keypad of a typical telephone.
* Imagine you have a closet full of shirts. It’s very hard to find a shirt. So what can you do to organize your shirts for easy retrieval?
* How would you test an elevator?
* How would you test a vending machine?
* How would you test a program that takes in two points and outputs the distance between the two points?
* Test the Windows scroll bar.
* Switch every pair of words in a string ("ab cd ef gh" becomes "cd ab gh ef")
* Write the function for strstr function (finding a substring inside a string)
* Reverse the order of words in a string ("ab cd ef gh" becomes "gh ef cd ab")
* Write the function for string comparison. How would you test it?
* Write a function to zero all duplicate values in an integer array. How would you test it?
* Write a function that compares two strings and returns a third string containing only the letters that appear in both.
Fresher Microsoft Interview Questions and answers Written Test: 1. A program was given and we were asked to debug the code so that it works as desired. The program's aim was "finding the meeting point of two linked lists". It was quite simple and some of errors were like in allocating memory, some logical errors. But its doable. 2. Given a Circuit (with resistors), we need to calculate the total resistance. Input will be like AB-5ohm, BC-6ohm, BC-10ohm, BC-20 ohm, CD-5 ohm. BC has been repeated twice implying they are in series. "Write a program by implementing efficient data structure for storing and calculating the total resistance". I used stack using linked list and implemented which works for almost all combinations of circuits (but didnt work for some :D). 3. "Write test cases for reversing words of string ". For eg. "This is nice" is input string and output is "nice is This". We need to write test cases for this program,(not the program for it). Writing some 5 to 10 will do. Start from some of the very simple cases like for eg. "Check whether the program in accepting input". 4. You have been asked to write features of an "Universal Remote Controller". Eg. "It will support TV,System, DTH etc".
The interviews in MS will be a loop process where a person has to attend interviews in a loop(every interviewer will interview us once). We need to satisfy all the four to get into MS. Round 1: 1. What were your challenging projects? I named one and I was asked to write test cases for that. Interviewer was not satisfied until I gave around 10 test cases. 2.Deletion of a node in linked list.. seems pretty simple , he was expecting a code with good coding standards. From there discussion went upto locks and mutexes in OS. 3.Print a Random word from a file. Input is "path to a file", constraints- No extra memory like hashing etc. All the words in the file should have equal probability. 4.Rectangles overlapping questions, write test cases.(I had seen this already). This is a popular MS question. Round 2:(only one question) 1.Write c++ working code for Given a large number with many digits, propose a method or data structure to efficiently store them. Addition, subtraction, mult, division should be supported by your design. Round 3:
Given a matrix, we need to transform it in such a way that if an element is zero, we need to zero out the contents of corresponding row and column(of that element). Only minimal extra space allowed, test cases was also asked. I gave some solutions,but he didnt get satisfied as the I used more space than what he asked. eg. if the matrix is
1 1 1
1 1 1
1 1 0
the output matrix is
1 1 0
1 1 0
0 0 0.
Microsoft Networks and Security Interview Questions
1. How do you use RSA for both authentication and secrecy?
2. What is ARP and how does it work?
3. What's the difference between a switch and a router?
4. Name some routing protocols? (RIP,OSPF etc..)
5. How do you do authentication with message digest(MD5)? (Usually MD is used for finding tampering of data)
6. How do you implement a packet filter that distinguishes following cases and selects first case and rejects second case.
i) A host inside the corporate n/w makes a ftp request to outside host and the outside host sends reply.
ii) A host outside the network sends a ftp request to host inside. for the packet filter in both cases the source and destination fields will look the same.
7. How does traceroute work? Now how does traceroute make sure that the packet follows the same path that a previous (with ttl - 1) probe packet went in?
8. Explain Kerberos Protocol ?
9. What are digital signatures and smart cards?
10. Difference between discretionary access control and mandatory access control?
Microsoft Hr and Technical Interview
1)How would you explain how to use Microsoft Excel to your grandma?
2)Why is it that when you turn on the hot water in any hotel, for example, the hot water comes pouring out almost instantaneously?
3)Why do you want to work at Microsoft?
4)Suppose you go home, enter your house/apartment, hit the light switch, and nothing happens – no light floods the room. What exactly, in order, are the steps you would take in determining what the problem was?
Microsoft Technical Interview Written Test Paper
1)How are M&Ms made?
2)If you had a clock with lots of moving mechanical parts, you took it apart piece by piece without keeping track of the method of how it was disassembled, then you put it back together and discovered that 3 important parts were not included; how would you go about reassembling
the clock?
3)If you had to learn a new computer language, how would you go about doing it?
4)You have been assigned to design Bill Gates bathroom. Naturally, cost is not a consideration. You may not speak to Bill.
5)What was the hardest question asked of you so far today?
6)If MS told you we were willing to invest $5 million in a start up of your choice, what business would you start? Why?
7)If you could gather all of the computer manufacturers in the world together into one room and then tell them one thing that they would be compelled to do, what would it be?
8)Explain a scenario for testing a salt shaker.
9)If you are going to receive an award in 5 years, what is it for and who is the audience?
Microsoft SDET Interview Questions(Software Development Engineer in Test)
Why do you want to work for Microsoft?
How would you deal with changes being made a week or so before the ship date?
How would you deal with a bug that no one wants to fix? Both the SDE and his lead have said they won't fix it.
Write a function that counts the number of primes in the range [1-N]. Write the test cases for this function.
Given a MAKEFILE, design the data structure that a parser would create and then write code that iterates over that data structure executing commands if needed.
Write a function that inserts an integer into a linked list in ascending order. Write the test cases for this function.
Test the save dialog in Notepad.
Write the InStr function. Write the test cases for this function.
Write a function that will return the number of days in a month (no using System.DateTime).
You have 3 jars. Each jar has a label on it: white, black, or white&black. You have 3 sets of marbles: white, black, and white&black. One set is stored in one jar. The labels on the jars are guaranteed to be incorrect (i.e. white will not contain white). Which jar would you choose from to give you the best chances of identifying the which set of marbles in is in which jar.
Microsoft Software Development Engineer Interview Questions(sde)
You're given an array containing both positive and negative integers and required to find the sub-array with the largest sum (O(N) a la KBL). Write a routine in C for the above.
Given an array of size N in which every number is between 1 and N, determine if there are any duplicates in it. You are allowed to destroy the array if you like. [ I ended up giving about 4 or 5 different solutions for this, each supposedly better than the others ].
Write a routine to draw a circle (x ** 2 + y ** 2 = r ** 2) without making use of any floating point computations at all.
Given only putchar (no sprintf, itoa, etc.) write a routine putlong that prints out an unsigned long in decimal.
Give a one-line C expression to test whether a number is a power of 2. No loops allowed.
Given an array of characters which form a sentence of words, give an efficient algorithm to reverse the order of the words (not characters) in it.
Give a good method to count the number of ones in a "n" (e.g. 32) bit number.
What are the different ways to implement a condition where the value of x can be either a 0 or a 1?
What types of projects (academic or otherwise) have inspired you in the past?
What are some self-directed missions that may have influenced your career direction?
Did you have a moment of epiphany when you KNEW what you wanted to be when you grew up?
How does Microsoft fit into your vision?
What are some things that excite and motivate you?
What are some examples of poorly/well-designed software? What makes the software this way and how would you change it?
What is your favorite Microsoft product? Why?
What is your least favorite Microsoft product? Why?
Explain a database to a young child.
Explain the Internet to your grandparents
What is your favorite web site? Why? Now improve it.
Steve Jobs calls and asks you to improve the iPod. Go.
What’s an example of great product design?
Why do mirrors reverse right and left instead of up and down?
If a bear walks one mile south, turns left and walks one mile to the east and then turns left again and walks one mile north and arrives at its original position, what is the color of the bear.
How would go about finding out where to find a book in a library. (You do not know how exactly the books are organized beforehand).
A band is going in the street with a constant speed. Someone in the last row has a dog. The dog runs ahead, reaches the front row of the band and gets back to it's owner. The dog's speed was constant all the way and while it was running the band passed 50 feet. Find the length of the dog's path,if the distance between the front and the rear row of the band is 50 feet.
The government wants cars to keep track of whether or not they are speeding. The part to determine this is already able to determine the speed of the vehicle, how would you design the rest of the system.
How many times a day do the hands on a clock overlap themselves?
You have 8 balls. One of them is defective and weighs less than others. You have a balance to measure balls against each other. In 2 weighings, how do you find the defective one?
There are 3 baskets. one of them have apples, one has oranges only and the other has mixture of apples and oranges. The labels on their baskets always lie. (i.e. if the label says oranges, you are sure that it doesn't have oranges only,it could be a mixture) The task is to pick one basket and pick only one fruit from it and then correctly label all the three baskets.
Why is a manhole cover round?
How many cars are there in the USA?
You've got someone working for you for seven days and a gold bar to pay them. The gold bar is segmented into seven connected pieces. You must give them a piece of gold at the end of every day. If you are only allowed to make two breaks in the gold bar, how do you pay your worker?
One train leaves Los Angeles at 15mph heading for New York. Another train leaves from New York at 20mph heading for Los Angeles on the same track. If a bird, flying at 25mph, leaves from Los Angeles at the same time as the train and flies back and forth between the two trains until they collide, how far will the bird have traveled?
You have two jars, 50 red marbles and 50 blue marbles. A jar will be picked at random, and then a marble will be picked from the jar. Placing all of the marbles in the jars, how can you maximize the chances of a red marble being picked? What are the exact odds of getting a red marble using your scheme?
Imagine you are standing in front of a mirror, facing it. Raise your left hand. Raise your right hand. Look at your reflection. When you raise your left hand your reflection raises what appears to be his right hand. But when you tilt your head up, your reflection does too, and does not appear to tilt his/her head down. Why is it that the mirror appears to reverse left and right, but not up and down?
You have 5 jars of pills. Each pill weighs 10 gram, except for contaminated pills contained in one jar, where each pill weighs 9 gm. Given a scale, how could you tell which jar had the contaminated pills in just one measurement?
If you had an infinite supply of water and a 5 quart and 3 quart pail, how would you measure exactly 4 quarts?
You have a bucket of jelly beans. Some are red, some are blue, and some green. With your eyes closed, pick out 2 of a like color. How many do you have to grab to be sure you have 2 of the same?
Which way should the key turn in a car door to unlock it?
If you could remove any of the 50 states, which state would it be and why?
There are four ants at four corners of a square of unit distance. At the same instant all of them start running with unit speed towards the person on their clockwise direction and will always run towards that target. How long does it take for them to meet and where?
Design a music system for a car. What are the features? Draw a picture.
Design a GPS navigation unit for a hiker.
Design a communication device for Canadian park rangers.
Design a remote control for an automatic window-blind system.
Design a coffee maker that will be used by astronauts.
Design an alarm clock.
Design an alarm clock for a blind person.
Design a search function.
What are examples of poorly designed software?
Design an instant messaging system.
I am your grandmother. Describe what MATLAB is to me.
How would you explain what a database is to a 5-year-old?
Develop an algorithm for selecting objects in Visio.
Tell me about a time when you made a decision and later found out that it was incorrect. What did you do to resolve the issue?
Suppose you are one week away from the product shipping date and discover a bug in your software. What do you do?
How would you test a keyboard?
How would you test a pen?
Imagine you have a closet full of shirts. It’s very hard to find a shirt. So what can you do to organize your shirts for easy retrieval?
How would you test an elevator?
How would you test a vending machine?
How would you test a program that takes in two points and outputs the distance between the two points?
Test the Windows scroll bar.
Given a rectangular (cuboid for the puritans) cake with a rectangular piece removed (any size or orientation), how would you cut the remainder of the cake into two equal halves with one straight cut of a knife?
Microsoft DOTNET Interview Questions • HR (Screening)
1. Tell about yourself
2. Tell about your work experience
3. Tell about projects
4. Tell about your current project and your role in it
5. What is your current salary p.a.
• Technical
.NET
6. How do you manage session in ASP and ASP.NET
7. How do you handle session management in ASP.NET and how do you implement them. How do you handle in case of SQLServer mode.
8. What are different authentication types. How do you retreive user id in case of windows authentication
9. For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this.
10. What is custom control. What is the difference between custom control and user control
11. What is the syntax for datagrid and specifying columns
12. How do you add a javascript function for a link button in a datagrid.
13. Does C# supports multi-dimensional arrays
14. How to transpose rows into columns and columns into rows in a multi-dimensional array
15. What are object oriented concepts
16. How do you create multiple inheritance in C#
17. ADO and ADO.NET differences
18. Features and disadvantages of dataset
19. What is the difference between and ActiveX dll and control
20. How do you perform validations
21. What is reflection and disadvantages of reflection
22. What is boxing and how it is done internally
23. Types of authentications in IIS
24. What are the security issues if we send a query from the application
25. Difference between ByVal and ByRef
26. Disadvantages of COM components
27. How do we invoke queries from the application
28. What is the provider and namespaces being used to access oracle database
29. How do you load XML document and perform validation of the document
30. How do you access elements in XML document
31. What is ODP.NET
32 Types of session management in ASP.NET
33. Difference between datareader and dataset
34. What are the steps in connecting to database
35. How do you register a .NET assembly
36. Usage of web.config
37. About remoting and web services. Difference between them
38. Caching techniques in .NET
39. About CLS and CTS
40. Is overloading possible in web services
41. Difference between .NET and previous version
42. Types of chaching. How to implement caching
43. Features in ASP.NET
44. How do you do validations. Whether client-side or server-side validations are better
45. How do you implement multiple inheritance in .NET
46. Difference between multi-level and multiple inheritance
47. Difference between dataset and datareader
48. What are runtime hosts
49. What is an application domain
50. What is viewstate
51. About CLR, reflection and assemblies
52. Difference between .NET components and COM components
53. What does assemblyinfo.cs consists
54. Types of objects in ASP
Database
55. What are the blocks in stored procedure
56. How do you handle exceptions. Give the syntax for it
57. What is normalization and types of normalization
58. When would you denormalize
59. Difference between a query and strored procedure
60. What is clustered and non-clustered indexes
61. Types of joins
62. How do you get all records from 2 tables. Which join do you use
63. Types of optimization
64. Difference between inline query and stored procedure
Project related
65. Tell about your current project
66. Tell about your role
67. What is the toughest situation you faced in the development
68. How often you communicate with the client
69. For what purposes, you communicate with the client
70. What is the process followed
71. Explain complete process followed for the development
72. What is the life cycle model used for the development
73. How do communicate with team members
74. How do you say you are having excellent team management skills
75. If your client gives a change and asks for early delivery. How will you manage.
76. How will gather requirements and where do you record. Is it in word / Excel or do you have any tool for that
77. What is the stage when code is delivered to the client and he is testing it.
78. What are the different phases of SDLC
79. How do you handle change requests
80. How do you perform impact analysis
81. How do you write unit test cases.
82. About current project architecture
Microsoft Interview Sqlserver Questions
1) what are the new features in SqlServer 2008 ?
2) what is the purpose of MERGE in SqlServer 2008?
why do we need ?
3) How many tables can we create in single database ?
Can we create 1 lakh tables in a single database ?
4) How many columns can we create in a single table ?
Can we insert data which having datatype varchar(8000) for each column ?
5) Where can we get total rowcount ?
6) Insert a query by using single quote .
Suppose Employee is a table, Ename is column.
How you will insert Jagan's Interview in Ename column
7) Brief description of Delete & Truncate
8) What is the use of identity ?
for suppose total 10 rows are in a table
Identity is (1,1) and i deleted all rows by using Delete statement
if i inserted 11th row in a table. What will be the identity value
if i truncated all rows and if i inserted 11th row in a table.
What will be the identity value (give me brief explanation)
9) Can we drop Clustered index without dropping a primary key.
Can we created Clustered index in another column. what Clustered index will do
10) I want to delete a record and i want to insert that record in another table.
Write a query in a single statement.
Ans) need answer
11) what is Unit testing and integrated testing ?
if i'm modifying a column datatype varchar(100) to varchar(50) in database.
Now the application is in production ? Are you will do Unit testing or Integrating testing.
Is it will effect to application ? did we need to check the validation ?
12) Have you worked on DTS package ?
13) Have you worked on SSIS ?
Thinkers - microsoft Interview questions * How are M&Ms made? * If you had a clock with lots of moving mechanical parts, you took it apart piece by piece without keeping track of the method of how it was disassembled, then you put it back together and discovered that 3 important parts were not included; how would you go about reassembling the clock? * If you had to learn a new computer language, how would you go about doing it? * You have been assigned to design Bill Gates bathroom. Naturally, cost is not a consideration. You may not speak to Bill. * What was the hardest question asked of you so far today? * If MS told you we were willing to invest $5 million in a start up of your choice, what business would you start? Why? * If you could gather all of the computer manufacturers in the world together into one room and then tell them one thing that they would be compelled to do, what would it be? * Explain a scenario for testing a salt shaker. * If you are going to receive an award in 5 years, what is it for and who is the audience? * How would you explain how to use Microsoft Excel to your grandma? * Why is it that when you turn on the hot water in any hotel, for example, the hot water comes pouring out almost instantaneously? * Why do you want to work at Microsoft? * Suppose you go home, enter your house/apartment, hit the light switch, and nothing happens - no light floods the room. What exactly, in order, are the steps you would take in determining what the problem was? * Interviewer hands you a black pen and says nothing but "This pen is red."
