Placement Papers - Microsoft

Microsoft Corporation
Technical Interview Qestions Based on Microsoft (.NET, Database, HR, Software Development)
Posted by :
Monalisa
(12)
Job Interview Placement Paper At Microsoft

Microsoft HR (Screening)
- Tell about yourself
- Tell about your work experience
- Tell about projects
- Tell about your current project and your role in it
- What is your current salary p.a.

.NET
  - Difference between asp and asp.net
  - How do you do exception management
  - If you are using components in your application, how can you handle exceptions  raised in a component
  - Can we throw exception from catch block
  - How do you relate an aspx page with its code behind page
  - What are the types of assemblies and where can u store them and how
  - What is difference between value and reference types
  - Is array reference type / value type
  - Is string reference type / value type
  - What is web.config. How many web.config files can be allowed to use in an  application
  - What is differnce between machine.config and web.config
  - What is shared and private assembly
  - What are asynchronous callbacks
  - How to write unmanaged code and how to identify whether the code is managed  / unmanaged.
  - How to authenticate users using web.config
  - What is strong name and which tool is used for this
  - What is gacutil.exe. Where do we store assemblies
  - Should sn.exe be used before gacutil.exe
  - What does assemblyinfo.cs file consists of
  - What is boxing and unboxing
  - Types of authentications in ASP.NET
  - difference between Trace and Debug
  - Difference between Dataset and DataReader
  - What is custom tag in web.config
  - How do you define authentication in web.Config
  - What is sequence of code in retrieving data from database
  - About DTS package
  - What provider ADO.net use by default
  - Where does web.config info stored? Will this be stored in the registry?
  - How do you register the dotnet component or assembly?
  - Difference between asp and asp.net
  - Whis is stateless asp or asp.net?
  - Authentication mechanism in dotnet
  - State management in asp.net
  - Types of values mode can hold session state in web.config
  - About WebService
  - What are Http handler
  - What is view state and how this can be done and was this there in asp?
  - Types of optimization and name a few and how do u do?
  - About DataAdapters
  - Features of a dataset
  - How do you do role based security
  - Difference between Response.Expires and Expires.Absolute
  - Types of object in asp
  - About duration in caching technique
  - Types of configuration files and ther differences
  - Difference between ADO and ADO.net
  - About Postback
  - If you are calling three SPs from a window application how do u check for the  performance of the SPS

Database
  - What is normalization
  - What is an index and types of indexes. How many number of indexes can be used  per table
  - What is a constraint. Types of constraints
  - What are code pages
  - What is referential integrity
  - What is a trigger
  - What are different types of joins
  - What is a self join
  - Authentication mechanisms in Sql Server
  - What are user defined stored procedures.
  - What is INSTEAD OF trigger
  - Difference between SQL server 7.0 and 2000
  - How to optimize a query that retrieves data by joining 4 tables
  - Usage of DTS
  - How to disable an index using select query
  - Is non-clustered index faster than clustered index
  - Types of optimization in querries
  - Difference between ISQL and OSQL
  - How you log an exception directly into sql server what is used for this
  - About Replication in Database
  - What is the default optimization done in oracle and sql server
  - How can i make a coulmn as unique
  - How many no of tables can be joined in same sql server
  - How many coulmns can exist per table
  - About Sql Profiler usage

HR & Project
  - About yourself
  - About work experience
  - How long you are working on .NET
  - Are you willing to relocate
  - When will you join
  - Why do u what to change from current organization
  - Why do you want to join Accenture
  - What are your weaknesses / areas of improvement
  - What is your current project and your responsibilities
  - Have you done database design / development
  - What is D in ACID

Technical .NET
  - How do you manage session in ASP and ASP.NET
  - How do you handle session management in ASP.NET and how do you implement  them. How do you handle in case of SQLServer mode.
  - What are different authentication types. How do you retreive user id in case of  windows authentication
  - 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.
  - What is custom control. What is the difference between custom control and user  control
  - What is the syntax for datagrid and specifying columns
  - How do you add a javascript function for a link button in a datagrid.
  - Does C# supports multi-dimensional arrays
  - How to transpose rows into columns and columns into rows in a multidimensional  array
  - What are object oriented concepts
  - How do you create multiple inheritance in C#
  - ADO and ADO.NET differences
  - Features and disadvantages of dataset
  - What is the difference between and ActiveX dll and control
  - How do you perform validations
  - What is reflection and disadvantages of reflection
  - What is boxing and how it is done internally
  - Types of authentications in IIS
  - What are the security issues if we send a query from the application
  - Difference between ByVal and ByRef
  - Disadvantages of COM components
  - How do we invoke queries from the application
  - What is the provider and namespaces being used to access oracle database
  - How do you load XML document and perform validation of the document
  - How do you access elements in XML document
  - What is ODP.NET
  - Types of session management in ASP.NET
  - Difference between datareader and dataset
  - What are the steps in connecting to database
  - How do you register a .NET assembly
  - Usage of web.config
  - About remoting and web services. Difference between them
  - Caching techniques in .NET
  - About CLS and CTS
  - Is overloading possible in web services
  - Difference between .NET and previous version
  - Types of chaching. How to implement caching
  - Features in ASP.NET
  - How do you do validations. Whether client-side or server-side validations are  better
  - How do you implement multiple inheritance in .NET
  - Difference between multi-level and multiple inheritance
  - Difference between dataset and datareader
  - What are runtime hosts
  - What is an application domain
  - What is viewstate
  - About CLR, reflection and assemblies
  - Difference between .NET components and COM components
  - What does assemblyinfo.cs consists
- Types of objects in ASP

More on Database
  - What are the blocks in stored procedure
  - How do you handle exceptions. Give the syntax for it
  - What is normalization and types of normalization
  - When would you denormalize
  - Difference between a query and strored procedure
  - What is clustered and non-clustered indexes
  - Types of joins
  - How do you get all records from 2 tables. Which join do you use
  - Types of optimization
  - Difference between inline query and stored procedure

Project Related
  - Tell about your current project
  - Tell about your role
  - What is the toughest situation you faced in the development
  - How often you communicate with the client
  - For what purposes, you communicate with the client
  - What is the process followed
  - Explain complete process followed for the development
  - What is the life cycle model used for the development
  - How do communicate with team members
  - How do you say you are having excellent team management skills
  - If your client gives a change and asks for early delivery. How will you manage.
  - How will gather requirements and where do you record. Is it in word / Excel or  do you have any tool for that
  - What is the stage when code is delivered to the client and he is testing it.
  - What are the different phases of SDLC
  - How do you handle change requests
  - How do you perform impact analysis
  - How do you write unit test cases.
  - About current project architecture