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?
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 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 ?
Microsoft Written test Questions There were 3 questions. 10 marks each. 1. Write a program to output all elements of a binary tree while doing a Breadth First traversal through it. 2.Write a method to combine two two sorted linked list into one in sorted form with out using temporary Node. void sort(Node* list1,Node* list2) 3.There are set of coins of {50,25,10,5,1} paise in a box.Write a program to find the number of ways a 1 rupee can be created by grouping the paise.
