Interview Question and Answer Bank

Daily Tips- Tip #88 - How will you find 64-Bit Operating Systems and Processes ?

2012-01-08T22:11:00.000-08:00

You can identify 64-bit operating systems and processes with the Environment.Is64BitOperatingSystem and Environment.Is64BitProcess properties.

You can specify a 32-bit or 64-bit view of the registry with the Microsoft.Win32.RegistryView enumeration when you open base keys.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How will you access a control in master page?

2011-12-22T22:32:00.000-08:00

textbox1.Text = Master.txtuser.text

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Razor Syntax ?

2011-12-21T21:36:00.000-08:00

Razor enables you to start with static HTML (or any textual content) and then make it dynamic by adding server code to it. One of the core design goals behind Razor is to make this coding process fluid, and to enable you to quickly integrate server code into your HTML markup with a minimum of keystrokes.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Entity Framework?

2011-12-12T22:46:00.000-08:00

The ADO.NET Entity Framework enables developers to create data access applications by programming against a conceptual application
model instead of programming directly against a relational storage schema.
The Entity Framework enables developers to work with data in the form of domain-specific objects and properties, such as customers
and customer addresses, without having to concern themselves with the underlying database tables and columns where this data is
stored. With the Entity Framework, developers can work at a higher level of abstraction when they deal with data, and can create
and maintain data-oriented applications with less code than in traditional applications.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is NuGet?

2011-12-06T08:54:00.000-08:00

NuGet is a Visual Studio extension that makes it easy to add, remove, and update libraries and tools in Visual Studio projects that
use the .NET Framework. When you add a library or tool, NuGet copies files to your solution and automatically makes whatever
changes are needed in your project, such as adding references and changing your app.config or web.config file. When you remove a
library, NuGet removes files and reverses whatever changes it made in your project so that no clutter is left.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the various formulas for ETC?

2011-11-02T23:53:00.000-07:00

• ETC = EAC-AC: Use formula when no keywords (i.e. typical, atypical or flawed) are given.
• ETC = BAC-EV: Assumption: use formula if current variances are thought to be atypical in the future.
• ETC = (BAC-EV) / CPI: Assumption: use formula if current variances are thought to be typical in the future.
• ETC = New estimate when it is thought that the original estimate was flawed.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the formula to calculate the Present Value?

2011-10-29T09:49:00.001-07:00

PV= FV / (1+i)ⁿ
Where PV is Present Value, FV is Future Value, i is interest, n is number of years

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the 3 broad categories of Contract?

2011-10-27T22:43:00.001-07:00

1. Fixed Price
2. Time and Material
3. Cost Reimbursable

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the various Communication Methods?

2011-10-27T22:42:00.001-07:00

1. Interactive
2. Push
3. Pull

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How much time do Project manager spend on communicating?

2011-10-27T22:41:00.001-07:00

90%

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What does Herzberg's Theory says?

2011-10-23T09:56:00.001-07:00

Hygiene factors (Working conditions, Salary, Personal life) are not sufficient to motivate but Motivating Agents

(Responsibility, Self-actualization)

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the 3 needs of people according to David McClelland's Theory of Needs (or Acquired Needs Theory)?

2011-10-23T09:51:00.001-07:00

1. Need for Achievement
2. Need for Affiliation
3. Need for Power

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Maslow's Hierarchy of needs ?

2011-10-23T09:50:00.000-07:00

From the lowest to highest in his pyramid is,Physiological, Safety, social, Esteem, Self-actualization.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is McGregor's Theory of X and Y?

2011-10-23T09:46:00.000-07:00

Theory X - People are incapable, avoid responsibility, and avoid work whenever possible

Theory Y - People are willing to work without supervision and want to achieve

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the different conflict resolution techniques?

2011-10-23T09:41:00.001-07:00

Confronting
Compromising
Withdrawal
Smoothing
Collaborating
Forcing

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the average percentage of time spent by a project manager in meetings?

2011-10-23T09:40:00.000-07:00

50%

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the approximate Percentage of non-verbal communication?

2011-10-23T09:38:00.000-07:00

55%

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the different stages of Team Formation?

2011-10-22T20:56:00.001-07:00

Forming
Stroming
Norming
Performing
Adjourning

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is RACI?

2011-10-22T20:55:00.001-07:00

It is an advanced form of Responsibility Assingment Matrix

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of RACI?

2011-10-22T20:54:00.001-07:00

Responsible Accountable Consult Inform

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the various Quality Theories ?

2011-10-20T10:16:00.000-07:00

1. 80/20 Principle, defined quality as "fitness for use",developed by Joseph Juran

2. Plan-Do=Check-Act cycle, W.Edwards Deming

3. "Zero defects", defined as "conformance to requirements", Philip Crosby

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the different Methods of accuracy Estimates ?

2011-10-20T10:10:00.000-07:00

1. Rough Order of Estimate:
Accuracy range = +-50
Done at Initiating Process

2. Budgeted Estimate:
Accuracy range = -10 to +25
Planning Process

3. Definitive Estimate:
Accuracy range = +- 10

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the project selection Methods ?

2011-10-14T22:21:00.001-07:00

There are 2 project selection methods:
1. Mathematical models(calculation methods)
2. Benefit Measurement methods(decision models)

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Control Account ?

2011-10-14T22:14:00.000-07:00

Cost estimation done at higher level in the WBS is called Control account.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites

What is Parametric Estimating ?

2011-10-13T00:03:00.000-07:00

Parametric estimating is the process of using historical data to compare against your project to determine a correlation and thereby a cost estimate for your current project.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites

What is NDoc ?

2011-10-11T03:52:00.000-07:00

The NDoc tool will automatically generate documentation for your code using reflection to examine the assembly and using the XML generated from your C# XML comments. XML comments are only available for C#, but there is a Visual Studio .NET Power Toy called VBCommenter which will do something similar for Visual Basic .NET.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Regulator ?

2011-10-11T03:51:00.000-07:00

It is a full-featured tool that makes it easy to build and test regular expressions.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is CodeSmith?

2011-10-11T03:47:00.001-07:00

CodeSmith is a template-based code-generation tool that uses a syntax similar to ASP.NET to generate any type of code or text. Unlike many other code-generation tools, CodeSmith does not require you to subscribe to a particular application design or architecture.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the Economic Models for Project selection ?

2011-10-08T22:50:00.000-07:00

1. Present Value
2. Net Present Value
3. Internal Rate of Return Dynamic Programming
4. Benefit Cost Ratio
5. Payback period

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the Costrained Optimization methods?

2011-10-08T22:41:00.000-07:00

1. Linear Programming
2. Integer Programming
3. Dynamic Programming
4. Multi-objective programmig

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the benifit measurement models?

2011-10-08T22:37:00.000-07:00

1. Murder Board(a panel of people who try to shoot down a new project idea)
2. Peer review
3. scornig models
4. Economic models

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the formula for Present Value in project management ?

2011-10-06T23:12:00.001-07:00

PV = Future Value / (1 + I)^n where I is the interest rate and n is the number of periods.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the formula for Future Value in project management ?

2011-10-06T23:11:00.000-07:00

FV = Current Value x (1 + I)^n where I is the interest rate and n is the number of periods.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the formula for ROI in project Management ?

2011-10-06T23:10:00.000-07:00

ROI = (Benefit – Cost)/Cost

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the 8/80 rule for WBS ?

2011-10-03T19:46:00.000-07:00

No task should be less than 8 hours or more than 80 hours.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the 2 types of Project Selection methods?

2011-10-03T19:44:00.001-07:00

1. Mathematical models(calculation methods or Constrained Optimization)
2. Benefit Measurement methods(decision models)

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the sub management plans in Project Management ?

2011-10-03T19:43:00.000-07:00

Scope management plan
Requirement management plan
Schedule management plan
Cost management plan
Quality management plan
Process improvement plan
Human resource plan
Communication management plan
Risk management plan
Procurement management plan

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How many baselines are there in Project management and what are they ?

2011-10-03T08:04:00.001-07:00

There are 3 baselines, they are
Schedule baseline
Cost performance baseline and
Scope baseline

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How many process groups are there PMP , what are they?

2011-10-03T08:03:00.000-07:00

Initiation
Planning
Execution
Control
Closure

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How many processes are there in Project Management?

2011-10-03T08:02:00.001-07:00

There are a total of 42 processes.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the 9 knowledge areas in Project Management?

2011-10-03T08:00:00.002-07:00

The type of organizations in decreasing order of Project Manager's authority are -
Project Integration Management
Project Scope Management
Project Cost Management
Project Time Management
Project Risk Management
Project Quality Management
Project HR Management
Project Communication Management
Project Procurement Management

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the Types of organization ?

2011-10-03T08:00:00.000-07:00

The type of organizations in decreasing order of Project Manager's authority are -
1. Projectized
2. Strong Matrix
3. Weak Matrix
4. Functional

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is a Profiler ?

2011-09-27T22:24:00.001-07:00

It is a tool which does dynamic program analysis. Its main purpose is to aid program optimization. It measures, for example, the usage of memory, duration of function calls.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is NCover ?

2011-09-26T22:30:00.001-07:00

It is a code coverage tool . It provides both command line and GUI support. It has a reporting feature also, which gives output details about the code coverage.
It has been designed to integrate with build process. So we can use it for code coverage.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Moles?

2011-09-26T22:29:00.001-07:00

It supports unit testing by providing isolation by way of detours and stubs.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Pex?

2011-09-26T22:28:00.000-07:00

It is a tool which automatically generates test suites with high code coverage. Microsoft Pex is a Visual Studio add-in for testing .NET Framework applications.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are Pex and Moles ?

2011-09-26T22:27:00.001-07:00

They are the VS 2010 Power tools which help Isolation and white box Unit Testing for .net

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Redirecting to another page in Silverlight

2011-09-26T21:47:00.001-07:00

this.NavigationService.Navigate(new Uri("/Products", UriKind.Relative));

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Tell some examples for Library List Templates in Sharepoint ?

2011-04-10T21:47:00.000-07:00

1. Document Library
2. Form Library
3. Wiki Page Library
4. Picture Library
5. Report Library

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Tell some examples for Custom List Templates in Sharepoint ?

2011-04-10T21:45:00.000-07:00

1. KPI List Template (MOSS only)
2. Languages and Translators (MOSS only)

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Tell some examples for Tracking List Templates in Sharepoint ?

2011-04-10T21:43:00.000-07:00

1. Links
2. Calendar
3. Tasks
4. Issue Tracking

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Tell some examples for Communication List Templates in Sharepoint ?

2011-04-10T21:40:00.000-07:00

1. Announcements
2. Contacts
3. Discussion Board

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the purpose of Libraries List Templates in SharePoint ?

2011-04-10T21:36:00.000-07:00

It provides file storage and Management .

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the purpose of Custom List Templates in SharePoint ?

2011-04-10T21:35:00.000-07:00

It has advanced options like KPI tracking and language translation.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the purpose of Tracking List Templates in SharePoint ?

2011-04-10T21:32:00.000-07:00

It helps site users manage schedules and activities.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the purpose of Communications List Templates in SharePoint ?

2011-04-10T21:30:00.000-07:00

Its for connecting site users by providing platform for sharing contact information, ideas and announcements

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the various types of SharePoint List Templates ?

2011-04-10T21:22:00.000-07:00

There are 4 categories, they are :
1. Communications
2. Tracking
3. Custom
4. Libraries

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is a Document Library in SharePoint ?

2011-04-10T21:18:00.000-07:00

It is a specialized type of list in which every memeber is a file and it can also have additional columns, or metadata associated with that file.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of CLS ?

2011-04-10T11:04:00.000-07:00

Common Language System

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of CTS ?

2011-04-10T11:01:00.000-07:00

Common Type System

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of MSIL ?

2011-04-10T10:59:00.001-07:00

MicroSoft Intermediate Language

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of ADO ?

2011-04-10T10:55:00.001-07:00

ActiveX Data Object

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of OLE DB ?

2011-04-10T10:54:00.001-07:00

Object Linking and Embedding DataBase

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of OLE ?

2011-04-10T10:53:00.000-07:00

Object Linking and Embedding

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of ODBC ?

2011-04-10T10:51:00.000-07:00

Open DataBase Connectivity

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of NLB ?

2011-04-10T10:48:00.001-07:00

Network Load Balance

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of UDA ?

2011-04-10T10:46:00.001-07:00

Universal Data Access

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of MTS ?

2011-04-10T10:45:00.000-07:00

Microsoft Transaction Server

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of DNA ?

2011-04-10T10:41:00.001-07:00

Distributed iNternet application Architecture

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of GUID ?

2011-04-10T10:39:00.001-07:00

Global Unique Identifier

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of IDL ?

2011-04-10T10:37:00.001-07:00

Interface Definition Language

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of COM?

2011-04-10T10:36:00.001-07:00

Component Object Model

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of PNRP ?

2011-04-10T10:32:00.000-07:00

Peer Name Resolution Protocol

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of DSML ?

2011-04-10T10:29:00.000-07:00

Directory Service Markup Language

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the methods provided by the dataset for XML?

2011-04-08T20:44:00.001-07:00

The important methods of a DataSet class for XML are :
1. GetXml Method
2. GetXmlSchema Method
3. InferXmlSchema Method
4. WriteXml Method
5. WriteXmlSchema Method
6. ReadXml Method
7. ReadXmlSchema Method

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Which is the best place to store connectionstring ?

2011-04-08T20:39:00.000-07:00

App.config - Windows Project
Web.config - Web project

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How can we force the connection object to close?

2011-04-08T18:25:00.000-07:00

There are 2 ways you can do this:
1. using the ExecuteReader method with "CommandBehavior.CloseConnection" parameter
2. Putting the Connection object with Using statement

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the two fundamental objects in ADO.NET ?

2011-04-08T18:20:00.000-07:00

1. DataReader ( connected mode )
2. DataSet ( disconnected mode )

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Best Practices for an Interview - Part 1

2011-04-04T05:25:00.000-07:00

The following are the best practices you can follow for an interview:
1. Be neatly dressed (Tucked in, with Tie, Shoes, Beared shaved)
2. Go well before the time
3. Carry additional copies of the documents mentioned by recruiter along with resume
4. Start with a Good Morning (or time based) and end with a Thank you
5. Give a good positive handshake
6. Be well prepared Technically
7. Sharpen your communication skills before interview
8. Have a model interview with your friend or colleague or at home
9. Gather information about the company and have good idea about them

www.codecollege.NET | www.interviewsguru.com | www.chitraguptan.com

What are the testing options provided by Microsoft ?

2011-04-01T03:45:00.000-07:00

1. Unit Testing integrated into VSTS
2. WebTest
3. Load Test
4. Generic Test
5. Manual Test
6. Ordered Test

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Tell some popular CRM Tools

2011-03-31T09:39:00.001-07:00

1. SAP
2. Seibel
3. Salesforce
4. MS CRM Dynamics

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

For Good Adsense

2011-03-25T07:34:00.000-07:00

"This post confirms my
ownership of the site and that this site adheres to Google AdSense
programme policies and Terms and Conditions. ca-pub-3429429002290284 ."

What is the expansion of CRM ?

2011-03-24T02:04:00.000-07:00

customer relationship management.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of DBCC ?

2011-03-23T08:43:00.001-07:00

Database Console Commands.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of CTE ?

2011-03-23T08:35:00.001-07:00

Common Table Expression.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is a MERGE Statement ?

2011-03-22T19:25:00.000-07:00

It is a statement which gives a way to perform multiple DML operations.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

2011-03-21T19:34:00.001-07:00

Interviews

What is Filtered Index ?

2011-03-21T19:09:00.000-07:00

A Filtered Index is an optimized form of non clustered index. A Filtered Index allows us to create a filter to index a subset of rows within a table.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are Sparse columns ?

2011-03-21T19:03:00.001-07:00

They are ordinary columns optimized for storage of null values, thereby reducing storage physical space.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Where are Usernames and Passwords stored in SQL Server ?

2011-03-20T21:37:00.000-07:00

In System Catalog Views sys.server_principals and sys.sql_logins.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How will you change the server level settings in SQL Server ?

2011-03-20T21:31:00.000-07:00

Using sp_configure

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the types of Cursors in SQL Server ?

2011-03-20T21:14:00.000-07:00

1. Static
2. Keyset-driven
3. Dynamic
4. Fast-Forward only

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How will you get the last error no in SQL Server ?

2011-03-20T08:27:00.001-07:00

@@ERROR.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

How will you get GUID in SQL Server ?

2011-03-20T08:15:00.001-07:00

NewID().

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #85 - SQL Performance Tuning

2011-03-20T07:37:00.000-07:00

sp_depends is the stored procedure is used to know which table use a rule or default.

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #84 - SQL Performance Tuning

2011-03-20T07:34:00.000-07:00

sp_unbindrule is the stored procedure which is used to unbind rule from table.

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #83 - SQL Performance Tuning

2011-03-20T07:32:00.000-07:00

sp_bindrule is the stored procedure which is used to bind rule to table.

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #82 - SQL Performance Tuning

2011-03-20T07:30:00.000-07:00

sp_helptext is the stored procedure which gives details about rules and defaults.

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #81 - SQL Performance Tuning

2011-03-20T07:29:00.000-07:00

sp_helpdb is the stored procedure which gives details about database.

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Daily Tips- Tip #80 - SQL Performance Tuning

2011-03-20T07:26:00.000-07:00

sp_help is the stored procedure which gives table details.

www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

Interview Question and Answer Bank

Daily Tips- Tip #88 - How will you find 64-Bit Operating Systems and Processes ?

You can identify 64-bit operating systems and processes with the Environment.Is64BitOperatingSystem and Environment.Is64BitProcess properties.You can specify a 32-bit or 64-bit view of the registry with the Microsoft.Win32.RegistryView enumeration when you open base keys.

How will you access a control in master page?

textbox1.Text = Master.txtuser.text

What is Razor Syntax ?

What is Entity Framework?

What is NuGet?

What are the various formulas for ETC?

What is the formula to calculate the Present Value?

PV= FV / (1+i)ⁿ Where PV is Present Value, FV is Future Value, i is interest, n is number of years

What are the 3 broad categories of Contract?

1. Fixed Price2. Time and Material3. Cost Reimbursable

What are the various Communication Methods?

1. Interactive2. Push3. Pull

How much time do Project manager spend on communicating?

90%

What does Herzberg's Theory says?

Hygiene factors (Working conditions, Salary, Personal life) are not sufficient to motivate but Motivating Agents(Responsibility, Self-actualization)

What are the 3 needs of people according to David McClelland's Theory of Needs (or Acquired Needs Theory)?

1. Need for Achievement2. Need for Affiliation3. Need for Power

What is Maslow's Hierarchy of needs ?

From the lowest to highest in his pyramid is,Physiological, Safety, social, Esteem, Self-actualization.

What is McGregor's Theory of X and Y?

Theory X - People are incapable, avoid responsibility, and avoid work whenever possibleTheory Y - People are willing to work without supervision and want to achieve

What are the different conflict resolution techniques?

ConfrontingCompromisingWithdrawalSmoothingCollaboratingForcing

What is the average percentage of time spent by a project manager in meetings?

50%

What is the approximate Percentage of non-verbal communication?

55%

What are the different stages of Team Formation?

FormingStromingNormingPerformingAdjourning

What is RACI?

It is an advanced form of Responsibility Assingment Matrix

What is the expansion of RACI?

Responsible Accountable Consult Inform

What are the various Quality Theories ?

1. 80/20 Principle, defined quality as "fitness for use",developed by Joseph Juran2. Plan-Do=Check-Act cycle, W.Edwards Deming3. "Zero defects", defined as "conformance to requirements", Philip Crosby

What are the different Methods of accuracy Estimates ?

1. Rough Order of Estimate: Accuracy range = +-50 Done at Initiating Process2. Budgeted Estimate: Accuracy range = -10 to +25 Planning Process3. Definitive Estimate: Accuracy range = +- 10

What are the project selection Methods ?

There are 2 project selection methods:1. Mathematical models(calculation methods)2. Benefit Measurement methods(decision models)

What is Control Account ?

Cost estimation done at higher level in the WBS is called Control account.

What is Parametric Estimating ?

Parametric estimating is the process of using historical data to compare against your project to determine a correlation and thereby a cost estimate for your current project.

What is NDoc ?

What is Regulator ?

It is a full-featured tool that makes it easy to build and test regular expressions.

What is CodeSmith?

CodeSmith is a template-based code-generation tool that uses a syntax similar to ASP.NET to generate any type of code or text. Unlike many other code-generation tools, CodeSmith does not require you to subscribe to a particular application design or architecture.

What are the Economic Models for Project selection ?

1. Present Value2. Net Present Value3. Internal Rate of Return Dynamic Programming4. Benefit Cost Ratio5. Payback period

What are the Costrained Optimization methods?

1. Linear Programming2. Integer Programming3. Dynamic Programming4. Multi-objective programmig

What are the benifit measurement models?

1. Murder Board(a panel of people who try to shoot down a new project idea)2. Peer review3. scornig models4. Economic models

What is the formula for Present Value in project management ?

PV = Future Value / (1 + I)^n where I is the interest rate and n is the number of periods.

What is the formula for Future Value in project management ?

FV = Current Value x (1 + I)^n where I is the interest rate and n is the number of periods.

What is the formula for ROI in project Management ?

ROI = (Benefit – Cost)/Cost

What is the 8/80 rule for WBS ?

No task should be less than 8 hours or more than 80 hours.

What are the 2 types of Project Selection methods?

1. Mathematical models(calculation methods or Constrained Optimization) 2. Benefit Measurement methods(decision models)

What are the sub management plans in Project Management ?

Scope management plan Requirement management plan Schedule management plan Cost management plan Quality management plan Process improvement plan Human resource plan Communication management plan Risk management plan Procurement management plan

How many baselines are there in Project management and what are they ?

There are 3 baselines, they areSchedule baseline Cost performance baseline and Scope baseline

How many process groups are there PMP , what are they?

Initiation Planning Execution Control Closure

How many processes are there in Project Management?

There are a total of 42 processes.

What are the 9 knowledge areas in Project Management?

What are the Types of organization ?

The type of organizations in decreasing order of Project Manager's authority are - 1. Projectized 2. Strong Matrix 3. Weak Matrix 4. Functional

What is a Profiler ?

You can identify 64-bit operating systems and processes with the Environment.Is64BitOperatingSystem and Environment.Is64BitProcess properties.

You can specify a 32-bit or 64-bit view of the registry with the Microsoft.Win32.RegistryView enumeration when you open base keys.

PV= FV / (1+i)ⁿ
Where PV is Present Value, FV is Future Value, i is interest, n is number of years

1. Fixed Price
2. Time and Material
3. Cost Reimbursable

1. Interactive
2. Push
3. Pull

Hygiene factors (Working conditions, Salary, Personal life) are not sufficient to motivate but Motivating Agents

(Responsibility, Self-actualization)

1. Need for Achievement
2. Need for Affiliation
3. Need for Power

Theory X - People are incapable, avoid responsibility, and avoid work whenever possible

Theory Y - People are willing to work without supervision and want to achieve

Confronting
Compromising
Withdrawal
Smoothing
Collaborating
Forcing

Forming
Stroming
Norming
Performing
Adjourning

1. 80/20 Principle, defined quality as "fitness for use",developed by Joseph Juran

2. Plan-Do=Check-Act cycle, W.Edwards Deming

3. "Zero defects", defined as "conformance to requirements", Philip Crosby

1. Rough Order of Estimate:
Accuracy range = +-50
Done at Initiating Process

2. Budgeted Estimate:
Accuracy range = -10 to +25
Planning Process

3. Definitive Estimate:
Accuracy range = +- 10

There are 2 project selection methods:
1. Mathematical models(calculation methods)
2. Benefit Measurement methods(decision models)

1. Present Value
2. Net Present Value
3. Internal Rate of Return Dynamic Programming
4. Benefit Cost Ratio
5. Payback period

1. Linear Programming
2. Integer Programming
3. Dynamic Programming
4. Multi-objective programmig

1. Murder Board(a panel of people who try to shoot down a new project idea)
2. Peer review
3. scornig models
4. Economic models

1. Mathematical models(calculation methods or Constrained Optimization)
2. Benefit Measurement methods(decision models)

Scope management plan
Requirement management plan
Schedule management plan
Cost management plan
Quality management plan
Process improvement plan
Human resource plan
Communication management plan
Risk management plan
Procurement management plan

There are 3 baselines, they are
Schedule baseline
Cost performance baseline and
Scope baseline

Initiation
Planning
Execution
Control
Closure

The type of organizations in decreasing order of Project Manager's authority are -
1. Projectized
2. Strong Matrix
3. Weak Matrix
4. Functional

It is a code coverage tool . It provides both command line and GUI support. It has a reporting feature also, which gives output details about the code coverage.
It has been designed to integrate with build process. So we can use it for code coverage.

1. Document Library
2. Form Library
3. Wiki Page Library
4. Picture Library
5. Report Library

1. KPI List Template (MOSS only)
2. Languages and Translators (MOSS only)

1. Links
2. Calendar
3. Tasks
4. Issue Tracking

1. Announcements
2. Contacts
3. Discussion Board

There are 4 categories, they are :
1. Communications
2. Tracking
3. Custom
4. Libraries