What is the best way to output only time and not Date?

Use DateTime as follows

VB.NET : Response.Write(DateTime.Now.ToString("hh:mm:ss"))

C# : Response.Write(DateTime.Now.ToString("hh:mm:ss"));

Do I have to compile code if I am changing the content of my aspx.cs file?

Yes if you have used Codebehind="my.aspx.cs". Not if you used src="my.aspx.cs" in your page declaration.

How to grab the referring URL?

VB.NET

Response.Write ( Request.UrlReferrer.ToString())

C#

Response.Write ( Request.UrlReferrer.ToString());

My ASP code gives an error "Compiler Error Message: BC30289

Use a script runat="server" block instead of the syntax to define Subs.Make sure you have proper events associated with the code and have start and end of procedure or function wirtten properly.

How can I save images ?

You need a stream to read the response, WebResponse.GetResponseStream (), and a stream to write it to the hard drive. FileStream should do the trick. You'll have to write to the filestream what you read from the response stream.

How can I logout when using FormsAuthentication?

VB.NET

FormsAuthentication.SignOut()

C#

FormsAuthentication.SignOut();

Why do I get a blank page when I use Server.Transfer("page1.htm") to transfer to a different page?

Server.Transfer only works with .aspx pages You can't use Transfer method with HTML pages

How to detect the User's culture?

VB.NET

Dim sLang As String
sLang = Request.UserLanguages(0)
Response.Write(sLang)

C#

string sLang ;
sLang = Request.UserLanguages[0];
Response.Write (sLang);

What is the difference between CurrentCulture property and the CurrentUICulture property?

CurrentCulture property : affects how the .NET Framework handles dates, currencies, sorting and formatting issues

CurrentUICulture property : determines which satellite assembly is used when loading resources

Can I read the hard disk serial # of the client computer using ASP.NET?

No. Such information is not passed to the server with a http request.

What is xxx(src As Object, e As EventArgs)?

xxx is an event handler src is the object that fires the event e is an event argument object that contains more information about the event An event handler is used when one object wants to be notified when an event happens in another object

What is the difference between Absolute vs Relative URLs?

Absolute /Fully Qualified URLs:

1. Contain all information necessary for the browser(or other client program) to locate the resource named in the URL

• This includes protocol moniker used( i.e http://, ftp://..etc..), Server's Domain name or IP address and the file path
• Absolute URL looks as http://localhost/syncfusion/page1.aspx
  

Relative URLs:

1. Only provide information necessary to locate a resource relative to the current document(document relative) or current server or domain(root relative)

• Document relative URL - page1.aspx
• Root Relative URL - /syncfusion/Admin/pagelog.aspx

What is the difference between URL and URI?

A URL is the address of some resource on the Web, which means that normally you type the address into a browser and you get something back. There are other type of resources than Web pages, but that's the easiest conceptually. The browser goes out somewhere on the Internet and accesses something.

A URI is just a unique string that uniquely identifies something, commonly a namespace. Sometimes they look like a URL that you could type into the address bar of your Web browser, but it doesn't have to point to any physical resource on the Web. It is just a unique set of characters, that, in fact, don't even have to be unique. URI is the more generic term, and a URL is a particular type of URI in that a URL has to uniquely identify some resource on the Web.

How to convert milliseconds into time?

VB.NET

dim ts as TimeSpan = TimeSpan.FromMilliseconds(10000)

Response.Write (ts.ToString () )

C#

TimeSpan ts = TimeSpan.FromMilliseconds(10000);

Response.Write (ts.ToString () );

How to include multiple vb/cs files in the source?

You can do this using assembly directives.

or

However, note that each source file will be compiled individually into its own assembly, so they cannot have dependencies on each other.

How to convert a string to Proper Case?

Use the namespace System.Globalization

VB.NET

Dim myString As String = "syncFusion deVeloPer sUppOrt"

' Creates a TextInfo based on the "en-US" culture.

Dim TI As TextInfo = New CultureInfo("en-US", False).TextInfo

Response.Write(TI.ToTitleCase(myString))

C#

string myString = "syncFusion deVeloPer sUppOrt";

// Creates a TextInfo based on the "en-US" culture.

TextInfo TI = new CultureInfo("en-US",false).TextInfo;

Response.Write (TI.ToTitleCase( myString ));

How can I ensure that application-level variables are not updated by more than one user simultaneously?

Use the HttpApplicationState's Lock and UnLock methods.

For more details refer : MSDN: Application State

Why do I get the error message "System.InvalidOperationException: It is invalid

You can't use MsgBox or MessageBox.Show in ASP.NET WebForm. You maybe use:

VB.NET

Response.Write()

C#

Response.Write() ;

How to validate that a string is a valid date?

VB.NET

Dim blnValid As Boolean = False

Try

DateTime.Parse(MyString)

blnValid = True

Catch

blnValid = False

End Try

C#

bool blnValid=false;

try

{
DateTime.Parse(MyString);

blnValid=true;
}

catch

{
blnValid=false;
}

@ Import Directive will cause an error ?

Namespaces and Class names are case Sensitive. Namespaces imported using the @ Import Directive will cause an error if the correct case is not used.

How to convert string to a DateTime and compare it with another DateTime?

VB.NET

Dim blntimeIsOk As Boolean = DateTime.Parse("15:00") < DateTime.Parse("08:00") Response.Write(blntimeIsOk)

C#

bool blntimeIsOk = (DateTime.Parse("15:00") < DateTime.Parse("08:00"));

Response.Write (blntimeIsOk);

How to get the url of page dynamically?

Use Request.Url property

How to convert user input in dMy format to Mdy?

VB.NET

Dim dt As DateTime = DateTime.ParseExact("0299", New String() {"My", "M/y"}, Nothing, System.Globalization.DateTimeStyles.None)

C#

DateTime dt = DateTime.ParseExact("0299", new string[] {"My","M/y"}, null,System.Globalization.DateTimeStyles.None);

File Download dialogbox

Clients do not report information back about where the user selects to save the content, so there isn't an easy way to do this. Instead, you would need to ask the user before using the content-disposition for a file path, and then you could specify the filename parameter for the content-disposition header. Still, the user is free to change that path when actually downloading.

Hide or show Controls in server side code

In any appropriate event write

VB.NET

TextBox1.Visible =not TextBox1.Visible

C#

TextBox1.Visible =!TextBox1.Visible ;

Check secure or non secure connection

The Request Object defines a Property called IsSecureConnection, that will indicate whether http:// or https:// has been used.

Write code in many languages in one ASP.NET project

You cannot write the code-behind files in different languages in the same project, but you can write the aspx pages and ascx controls in different languages.

Difference between Response.Redirect and Server.Transfer

Response.Redirect

1. Tranfers the page control to the other page, in other words it sends the request to the other page.
2. Causes the client to navigate to the page you are redirecting to. In http terms it sends a 302 response to the client, and the client goes where it's told.

Server.Transfer

1. Only transfers the execution to another page and during this you will see the URL of the old page since only execution is transfered to new page and not control.
2. Occurs entirely on the server, no action is needed by the client

Get hostname or IP address of the server

You can use either of these:

1. HttpContext.Current.Server.MachineName
2. HttpContext.Current.Request.ServerVariables["LOCAL_ADDR"]

The first one should return the name of the machine, the second returns the local ip address. Note that name of the machine could be different than host, since your site could be using host headers

Meaning of validateRequest

The value of validateRequest is set to 'true' by default, which means that the framework will automatically deny submission of the '<' and '>' characters.

Parse Tags

The is used for databinding where as is used to output the result of an expression. The expression inside will be executed only when you call the page's or control's DataBind method. The expression inside will be executed and displayed as and when it appears in the page.

Permissions ASP.NET applications

By default ASP.NET Web applications run as ASP.NET user. This user has limited permissions equivalent to the User Group.

Relative path for a file

Suppose you have following file hierarchy:

default.aspx

Admin/login.aspx

Misc/testpage.aspx

And you are on the login.aspx and want your user to navigate to the default.aspx (or testpage.aspx) file. Then you can use

Response.Redirect ("../default.aspx")
Response.Redirect ("../Misc/testpage.aspx")

Upload a file

Question : How can I specify the "upload a file" input textbox in a form to be read only so that the user can click on the browse button and pick a file but they cannot type anything into the textbox next to the browse button?

Answer :

Use

Change the Page Title dynamically

Question : How to change the Page Title dynamically?

Answer :

VB.NET

'Declare

Protected WithEvents Title1 As System.Web.UI.HtmlControls.HtmlGenericControl

'In Page_Load

Title1.InnerText ="Page 1"

C#

//Declare

protected System.Web.UI.HtmlControls.HtmlGenericControl Title1 ;

//In Page_Load

Object must implement IConvertible

Question : Why do I get the error message "Object must implement IConvertible". How can I resolve it?

Answer :
The common cause for this error is specifying a control as a SqlParameter's Value instead of the control's text value. For example, if you write code as below you'll get the above error:

VB.NET

Dim nameParameter As SqlParameter = command.Parameters.Add("@name", SqlDbType.NVarChar, 50)

nameParameter.Value = txtName

C#

SqlParameter nameParameter = command.Parameters.Add("@name", SqlDbType.NVarChar, 50);

nameParameter.Value = txtName ;

To resolve it, specify the control's Text property instead of the control itself.

VB.NET

nameParameter.Value = txtName.Text

C#

nameParameter.Value =txtName.Text;

LocalHost Error

Question : Why is default.aspx page not opened if i specify http://localhost. I am able to view this page if i hardcode it as http://localhost/default.aspx?

Answer :If some other default page comes higher in the list, adjust the default.aspx to be the number one entry inside the IIS configuration. If you have multiple websites inside IIS, make sure the configuration is applied on the right website (or on all websites by applying the configuration on the server-level using the properties dialog, configure WWW service).

Migrate Visual InterDev control to ASP.NET

Question : Is it possible to migrate Visual InterDev Design-Time Controls to ASP.NET?

Answer :In VS.NET you can go to Tools > Options > Source Control > General and check the checkbox for Get everything when a solution opens. This retrieves the latest version of all solution items when you open the solution.

Open application with Source Safe

Question : How to automatically get the latest version of all the asp.net solution items from Source Safe when opening the solution?

Answer :In VS.NET you can go to Tools > Options > Source Control > General and check the checkbox for Get everything when a solution opens. This retrieves the latest version of all solution items when you open the solution.

Convert the datetime into a string

Question : How to convert the datetime into a string for use in the SQL ' statement?

Answer :

Select a culture:


DateTime in Selected Culture





VB.NET

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

'Put user code to initialize the page here

If Not Page.IsPostBack Then

Dim cInfo As CultureInfo

For Each cInfo In CultureInfo.GetCultures(CultureTypes.SpecificCultures)

ddlCulture.Items.Add(cInfo.Name)

Next

End If

End Sub


Private Sub ddlCulture_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlCulture.SelectedIndexChanged

' Get a CultureInfo object based on culture selection in dropdownlist

Dim cInfo As CultureInfo = New CultureInfo(ddlCulture.SelectedItem.Text)

' Get a CultureInfo object based on Invariant culture

Dim cInfoNeutral As CultureInfo = New CultureInfo("")

' Display the datetime based on the formatting of the selected culture

TextBox1.Text = Convert.ToString(Now, cInfo.DateTimeFormat)

' Create a DateTime variable to hold the Invariant time

Dim dt As DateTime

dt = Convert.ToDateTime(TextBox1.Text, cInfo.DateTimeFormat)

'Convert the datetime into a string for use in the SQL statement

Label1.Text = "... WHERE ([Date] < '" & _

Convert.ToString(dt, cInfoNeutral.DateTimeFormat) & "')"

End Sub

C#

private void Page_Load(object sender, System.EventArgs e)

{

// Put user code to initialize the page here

if (!Page.IsPostBack )

{

foreach(CultureInfo cInfo in CultureInfo.GetCultures(CultureTypes.SpecificCultures))

{

ddlCulture.Items.Add(cInfo.Name);

}

}

}



private void ddlCulture_SelectedIndexChanged(object sender, System.EventArgs e)

{

// Get a CultureInfo object based on culture selection in dropdownlist

CultureInfo cInfo = new CultureInfo(ddlCulture.SelectedItem.Text);

// Get a CultureInfo object based on Invariant culture

CultureInfo cInfoNeutral = new CultureInfo("");

// Display the datetime based on the formatting of the selected culture

TextBox1.Text = Convert.ToString(DateTime.Now , cInfo.DateTimeFormat);

// Create a DateTime variable to hold the Invariant time

DateTime dt ;

dt = Convert.ToDateTime(TextBox1.Text, cInfo.DateTimeFormat);

//Convert the datetime into a string for use in the SQL statement

Label1.Text = "... WHERE ([Date] < '" + Convert.ToString(dt, cInfoNeutral.DateTimeFormat) + "')";

}

Unable to start debugging on the web server

Question : Why do I get error message "Unable to start debugging on the web server. The server does not support debugging of ASP.NET or ATL Server applications. ..."?

Answer :You would get this error if the application mappings for ASP.NET file name extensions (such as .aspx) are not configured correctly in Microsoft Internet Information Services (IIS). To resolve this go to C:\Windows Directory\Microsoft.Net\Framework\Version and type aspnet_regiis -i to configure the required application mappings correctly

Error in download MyPage.aspx

Question : Why do I get error message "Internet Explorer cannot download MyPage.aspx from MyWebSite.com ..."?

Answer :This happens for example, whe you try to export data to excel from a datagrid.
The problem occurs if the server is using Secure Sockets Layer (SSL) and has added one or both of the following HTTP headers to the response message:

Pragma: no-cache

Cache-control: no-cache,max-age=0,must-revalidate

For more details refer PRB: Internet Explorer Is Unable to Open Office Documents from an SSL Web Site

Configure ASP.NET

Question : How to Configure Different Versions of an ASP.NET Application Running on the Same Web Server?

Answer :
Find the ASP.NET Version Used for the Application
View the script map for an ASP.NET application to determine the version of ASP.NET that the application uses. To view the script map for an ASP.NET application, follow these steps:

1. Click Start, point to Programs, and then click Control Panel.
2. Double-click Administrative Tools, and then double-click Internet Information Services (IIS).
3. Expand local computer, expand Web Site, and then expand Default Web Site.
4. Locate the folder that contains the ASP.NET application.
5. Right-click the folder that contains the ASP.NET application, and then click Properties.
6. Click the Directory tab, and then click Configuration. The Application Configuration dialog box opens.
7. Click the Mappings tab, and then select an ASP.NET application extension, such as .asmx or .aspx. The Executable Path column of the dialog box lists the path to the ASP.NET ISAPI version that the application uses. By default, the ASP.NET ISAPI is installed in %WindowsDirectory%\Microsoft.NET\Framework\%versionNumber%. The version number in the path indicates the version number of the ASP.NET ISAPI that the application uses. The ASP.NET ISAPI version determines the version of the runtime that the application uses.

Use Aspnet_regiis.exe to Update the Script Map

To make it easier to reconfigure the script map for an ASP.NET application, each installation of the .NET Framework is associated with a version of the ASP.NET IIS Registration tool (Aspnet_regiis.exe). You can use this tool to remap an ASP.NET application to the ASP.NET ISAPI version associated with the tool.

Note Because Aspnet_regiis.exe is linked to a specific version of the .NET Framework, you must use the appropriate version of Aspnet_regiis.exe to reconfigure the script map for an ASP.NET application. Aspnet_regiis.exe only reconfigures the script map of an ASP.NET application to the ASP.NET ISAPI version associated with the tool

Configure ASP.NET 1.0 for the Application

When ASP.NET 1.1 is configured on the root Web site, follow these steps to configure ASP.NET 1.0 for an application:

1. Click Start, and then click Run. In the Open text box, type cmd, and then click OK.
2. At the command prompt, locate the following directory path: %WindowsDirectory%\Microsoft.NET\Framework\v1.0.3705\
3. Type the following command to configure the ASP.NET 1.0 application in IIS:
   
   aspnet_regiis -s w3svc/1/root/ApplicationName

To remove ASP.NET 1.0 from this application, repeat steps 1and 2, and then type the following command:

aspnet_regiis -k w3svc/1/root/ApplicationName

Configure ASP.NET 1.1 for the Application

When ASP.NET 1.0 is configured on the root Web site, follow these steps to configure ASP.NET 1.1 to run an application:

1. Click Start, and then click Run. In the Open text box, type cmd, and then click OK.
2. At the command prompt, locate the following directory path: %WindowsDirectory%\Microsoft.NET\Framework\v1.1.4322
3. If ASP.NET 1.1 is not already registered, type the following command to register it: aspnet_regiis -ir Note The -ir option registers ASP.NET 1.1 without updating the scripts in IIS.
4. Type the following to configure the ASP.NET 1.1 application in IIS:
   
   aspnet_regiis -s w3svc/1/root/ApplicationName

To remove ASP.NET 1.1 from this application, repeat steps 1 and 2, and then type the following command:

aspnet_regiis -k w3svc/1/root/ApplicationName

Configure the ASP.NET Version

Question : How to Configure the ASP.NET Version to use for Each Application(developed using 1.0 or 1.1)?

Answer :To configure WebApp1 to use ASP.NET 1.0, follow these steps:

1. Click Start, and then click Run.
2. In the Open text box, type cmd, and then click OK.
3. At the command prompt, locate the following directory: WindowsDirectory\Microsoft.NET\Framework\v1.0.3705\
4. At the command prompt, type one of the following commands:

• To Install ASP.NET 1.0 recursively aspnet_regiis -s W3SVC/1/ROOT/WebApp1
• To Install ASP.NET 1.0 non-recursively aspnet_regiis -sn W3SVC/1/ROOT/WebApp1

To configure WebApp2 to use ASP.NET 1.1, follow these steps:

1. Click Start, and then click Run.
2. In the Open text box, type cmd, and then click OK.
3. At the command prompt, locate the following directory: WindowsDirectory\Microsoft.NET\Framework\v1.1.4322\
   At the command prompt, type one of the following commands:

• To Install ASP.NET 1.1 recursively aspnet_regiis -s W3SVC/1/ROOT/WebApp2
• To Install ASP.NET 1.1 non-recursively aspnet_regiis -sn W3SVC/1/ROOT/WebApp2

Client side validations

Question : After installing .NET Framework SP1 the client side validations, or rather validator controls are not working?

Answer :The problem seems to be in the javascript file WebValidationUi.js in aspnet_client folder.The changes in that file prevent a page to be submitted. That could be the reason your javascript validations are not working. As a workaround, just copy the old WebValidateionUi.js over the new one.

Script libruary error

Question : Why do I get the "Unable to find script libruary 'WebUIValidation.js'" error ?

Answer : When you install the .Net framework on your web server, it installs some script files (including the above) under the root folder (usually "C:\inetput\wwwroot" if you do a default installation) . You can then find the above file at "C:\Inetpub\wwwroot\aspnet_client\system_web\1_1_4322", for example. The above problem could happen if you reconfigured your web root directory to be a different one after you installed ASP.Net in your web server. If that is the case, then run 'aspnet_regiis -c' (utility is under %windir%\Microsoft.NET\Framework\v1.1.4322, for example) or copy over manually the above script files into a similar sub-directory below your current web root directory. Also, if you look at the error message in detail, you will notice where the file is supposed to be.

Create a new ASP.NET application

Question : In Visual Studio .NET, how do I create a new ASP.NET application which does not have a physical path under wwwroot?

Answer :You must first create an IIS application using the IIS MMC. Then in Visual Studio .NET, create a new ASP.NET application and give it the same name you used for the IIS application

Server Application Unavailable

Question : Why do I get the error message "Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request."?

Answer :By default, ASP.NET runs its worker process (Aspnet_wp.exe) with a weak account (the local machine account, which is named ASPNET) to provide a more secure environment. On a domain controller or on a backup domain controller, all user accounts are domain accounts and are not local machine accounts. Therefore, Aspnet_wp.exe fails to start because it cannot find a local account named "localmachinename\ASPNET". To provide a valid user account on the domain controller, you must specify an explicit account in the section of the Machine.config file, or you must use the SYSTEM account. For more details : FIX: ASP.NET Does Not Work with the Default ASPNET Account on a Domain Controller

Create a new ASP.NET application

Question : In Visual Studio .NET, how do I create a new ASP.NET application for an existing ASP.NET project?

Answer :First create an IIS application using the IIS MMC. Then in Visual Studio .NET, use the "New Project In Existing Folder" project template (at the end of the template list). It will first ask you for the project name (use the same one you created for the IIS application). Click OK button. Then enter in physical folder location.

Check IIS Installation

Question : How should I check whether IIS is installed or not?

Answer :To verify if IIS is installed, go to your 'Add or Remove Programs' utility in the Control panel and click on the 'Add/Remove Windows Components' in the side menu.
On XP Pro and below, you should see an item called "Internet Information Services (IIS)". If this is checked, IIS should be installed. On Win2K3, you'll see "Application Server". If this is checked, select it and then click 'Details'. Another form should open which will contain "Internet Information Services (IIS)". If it is checked, IIS should be installed.

Visual Studio 6.0 installed

Question : Can I have VS.NET and the Visual Studio 6.0 installed on the same machine?

Answer :Yes! VS.Net works with the .Net framework, while VS6.0 works with MFC or the Windows API directly, for the most part. They can be installed and run on the same machine without any considerations.

Execution of Framework

Question : What are the Best practices for side-by-side execution of Framework 1.0 and 1.1?

Answer :In ASP.NET, applications are said to be running side by side when they are installed on the same computer, but use different versions of the .NET Framework. The following article at www.asp.net details the practices that are recommended ASP.NET Side-by-Side Execution of .NET Framework 1.0 and 1.1

View in Windows Server 2003

Question : I have recently move my Web application from Windows 2k to Windows Server 2003. All works fine in Windows 2K but i am not able to view pages using Windows Server 2003?

Answer :You have to enable the ASP.NET in the Web Server Extensions listFrom Start -> Settings -> Control Panel -> Administrative Tools -> double click IIS Manager. Go to the Web Service Extensions tab, click Active Server Pages, then press the "Allow" button on the left.

HTTP 500 error

Question : Why do I get "HTTP 500" error (or "(DLL) initialization routine failed") in my browser?

Answer :This is because if you have the /3GB boot switch enabled, the ASP.NET worker process (Aspnet_wp.exe) does not start. To create and set the "ASPNETENABLE3GB" environment variable as mentioned in the above article, right click MyComputer ->Properties->Advanced > Environment Variables > System variables > New. Add the variable name in the top text box and the value in the lower textbox.

Repair ASP.Net IIS

Q: How To Repair ASP.Net IIS Mapping After You Remove and Reinstall IIS?

Answer : To reassociate aspx file extensions with ASP.Net runtime, you'll have to run the utlity aspnet_regiis.exe -i

Server control tags

Q : Why are Server control tags shown in the browser instead of the controls it represents?

Answer : This is because the server control tags were not converted into their respecting HTML element tags by ASP.Net. This happens when ASP.Net is not properly registered with IIS.
.Net framework provides an Administration utility that manages the installation and uninstallation of multiple versions of ASP.NET on a single machine. You can find the file in C:\WINNT\Microsoft.NET\Framework\v**\aspnet_regiis.exe
use the command: aspnet_regiis.exe -u ---> to uninstall current asp.net version. use the command: aspnet_regiis.exe -i ---> to install current asp.net version.

FAQ-OOPS

Frequently Asked Questions - Object oriented Concepts

· How do you write a program which produces its own source code as its output?
· How can I find the day of the week given the date?
· Why doesn't C have nested functions?
· What is the most efficient way to count the number of bits which are set in a value?
· How can I convert integers to binary or hexadecimal?
· How can I call a function, given its name as a string?
· How do I access command-line arguments?
· How can I return multiple values from a function?
· How can I invoke another program from within a C program?
· How can I access memory located at a certain address?
· How can I allocate arrays or structures bigger than 64K?
· How can I find out how much memory is available?
· How can I read a directory in a C program?
· How can I increase the allowable number of simultaneously open files?
· What's wrong with the call "fopen("c:\newdir\file.dat", "r")"?
· What is the output of printf("%d")
· What will happen if I say delete this
· Difference between "C structure" and "C++ structure".
· Diffrence between a "assignment operator" and a "copy constructor"
· Explain the need for "Virtual Destructor".
· Can we have "Virtual Constructors"?
· What are the different types of polymorphism?
· What are Virtual Functions? How to implement virtual functions in "C"
· What are the different types of Storage classes?
· What is Namespace?
· What are the types of STL containers?.
· Difference between "vector" and "array"?
· How to write a program such that it will delete itself after exectution?
· Can we generate a C++ source code from the binary file?
· What are inline functions?
· Talk sometiming about profiling?
· How many lines of code you have written for a single program?
· What is "strstream" ?
· How to write Multithreaded applications using C++?
· Explain "passing by value", "passing by pointer" and "passing by reference"
· Write any small program that will compile in "C" but not in "C++"
· Have you heard of "mutable" keyword?
· What is a "RTTI"?
· Is there something that I can do in C and not in C++?
· Why preincrement operator is faster than postincrement?
· What is the difference between "calloc" and "malloc"?
· What will happen if I allocate memory using "new" and free it using "free" or allocate sin "calloc" and free it using "delete"?
· What is Memory Alignment?
· Explain working of printf.
· Difference between "printf" and "sprintf".
· What is "map" in STL?
· When shall I use Multiple Inheritance?
· What are the techniques you use for debugging?
· How to reduce a final size of executable?
· Give 2 examples of a code optimization.
· What is inheritance?
· Difference between Composition and Aggregation.
· Difference: Sequence Diagrams, Collaboration Diagrams.
· Difference: 'uses', 'extends', 'includes'
· What shall I go for Package Diagram?
· What is Polymorphism?
· Is class an Object? Is object a class?
· Comment: C++ "includes" behavior and java "imports"
· What do you mean by "Realization"?
· What is a Presistent, Transient Object?
· What is the use of Operator Overloading?
· Does UML guarantee project success?
· Difference: Activity Diagram and Sequence Diagram.
· What is association?
· How to resolve many to many relationship?
· How do you represent static members and abstract classes in Class Diagram?
· What does static variable mean?
· What is a pointer?
· What is a structure?
· What are the differences between structures and arrays?
· In header files whether functions are declared or defined?
· What are macros? what are its advantages and disadvantages?
· Difference between pass by reference and pass by value?
· What is static identifier?
· Where are the auto variables stored?
· Where does global, static, local, register variables, free memory and C Program instructions get stored?
· Difference between arrays and linked list?
· What are enumerations?
· Describe about storage allocation and scope of global, extern, static, local and register variables?
· What are register variables? What are the advantage of using register variables?
· What is the use of typedef?
· Can we specify variable field width in a scanf() format string? If possible how?
· Out of fgets() and gets() which function is safe to use and why?
· Difference between strdup and strcpy?
· What is recursion?
· Differentiate between a for loop and a while loop? What are it uses?
· What are the different storage classes in C?
· Write down the equivalent pointer expression for referring the same element a[i][j][k][l]?
· What is difference between Structure and Unions?
· What the advantages of using Unions?
· What are the advantages of using pointers in a program?
· What is the difference between Strings and Arrays?
· In a header file whether functions are declared or defined?
· What is a far pointer? where we use it?
· How will you declare an array of three function pointers where each function receives two ints and returns a float?
· what is a NULL Pointer? Whether it is same as an uninitialized pointer?
· What is a NULL Macro? What is the difference between a NULL Pointer and a NULL Macro?
· What does the error 'Null Pointer Assignment' mean and what causes this error?
· What is near, far and huge pointers? How many bytes are occupied by them?
· How would you obtain segment and offset addresses from a far address of a memory location?
· Are the expressions arr and &arr same for an array of integers?
· Does mentioning the array name gives the base address in all the contexts?
· Explain one method to process an entire string as one unit?
· What is the similarity between a Structure, Union and enumeration?
· Can a Structure contain a Pointer to itself?
· How can we check whether the contents of two structure variables are same or not?
· How are Structure passing and returning implemented by the complier?
· How can we read/write Structures from/to data files?
· What is the difference between an enumeration and a set of pre-processor # defines?
· what do the 'c' and 'v' in argc and argv stand for?
· Are the variables argc and argv are local to main?
· What is the maximum combined length of command line arguments including the space between adjacent arguments?
· If we want that any wildcard characters in the command line arguments should be appropriately expanded, are we required to make any special provision? If yes, which?
· Does there exist any way to make the command line arguments available to other functions without passing them as arguments to the function?
· What are bit fields? What is the use of bit fields in a Structure declaration?
· To which numbering system can the binary number 1101100100111100 be easily converted to?
· Which bit wise operator is suitable for checking whether a particular bit is on or off?
· Which bit wise operator is suitable for turning off a particular bit in a number?
· Which bit wise operator is suitable for checking whether a particular bit is on or off?
· which one is equivalent to multiplying by 2:Left shifting a number by 1 or Left shifting an unsigned int or char by 1?
· Write a program to compare two strings without using the strcmp() function.
· Write a program to concatenate two strings.
· Write a program to interchange 2 variables without using the third one.
· Write programs for String Reversal & Palindrome check
· Write a program to find the Factorial of a number
· Write a program to generate the Fibinocci Series
· Write a program which employs Recursion
· Write a program which uses Command Line Arguments
· Write a program which uses functions like strcmp(), strcpy()? etc
· What are the advantages of using typedef in a program?
· How would you dynamically allocate a one-dimensional and two-dimensional array of integers?
· How can you increase the size of a dynamically allocated array?
· How can you increase the size of a statically allocated array?
· When reallocating memory if any other pointers point into the same piece of memory do you have to readjust these other pointers or do they get readjusted automatically?
· Which function should be used to free the memory allocated by calloc()?
· How much maximum can you allocate in a single call to malloc()?
· Can you dynamically allocate arrays in expanded memory?
· What is object file? How can you access object file?
· Which header file should you include if you are to develop a function which can accept variable number of arguments?
· Can you write a function similar to printf()?
· How can a called function determine the number of arguments that have been passed to it?
· Can there be at least some solution to determine the number of arguments passed to a variable argument list function?
· How do you declare the following:
· An array of three pointers to chars
· An array of three char pointers
· A pointer to array of three chars
· A pointer to function which receives an int pointer and returns a float pointer
· A pointer to a function which receives nothing and returns nothing
· What do the functions atoi(), itoa() and gcvt() do?
· Does there exist any other function which can be used to convert an integer or a float to a string?
· How would you use qsort() function to sort an array of structures?
· How would you use qsort() function to sort the name stored in an array of pointers to string?
· How would you use bsearch() function to search a name stored in array of pointers to string?
· How would you use the functions sin(), pow(), sqrt()?
· How would you use the functions memcpy(), memset(), memmove()?
· How would you use the functions fseek(), freed(), fwrite() and ftell()?
· How would you obtain the current time and difference between two times?
· How would you use the functions randomize() and random()?
· How would you implement a substr() function that extracts a sub string from a given string?
· What is the difference between the functions rand(), random(), srand() and randomize()?
· What is the difference between the functions memmove() and memcpy()?
· How do you print a string on the printer?
· Can you use the function fprintf() to display the output on the screen?
· What is an object?
· What is the difference between an object and a class?
· What is the difference between class and structure?
· What is public, protected, private?
· What are virtual functions?
· What is friend function?
· What is a scope resolution operator?
· What do you mean by inheritance?
· What is abstraction?
· What is polymorphism? Explain with an example.
· What is encapsulation?
· What do you mean by binding of data and functions?
· What is function overloading and operator overloading?
· What is virtual class and friend class?
· What do you mean by inline function?
· What do you mean by public, private, protected and friendly?
· When is an object created and what is its lifetime?
· What do you mean by multiple inheritance and multilevel inheritance? Differentiate between them.
· Difference between realloc() and free?
· What is a template?
· What are the main differences between procedure oriented languages and object oriented languages?
· What are generic functions and generic classes?
· Why do we use virtual functions?
· What do you mean by pure virtual functions?
· What are virtual classes?
· Does c++ support multilevel and multiple inheritance?
· What are the advantages of inheritance?
· When is a memory allocated to a class?
· What is the difference between declaration and definition?
· What is virtual constructors/destructors?
· In c++ there is only virtual destructors, no constructors. Why?
· What is late bound function call and early bound function call? Differentiate.
· How is exception handling carried out in c++?
· When will a constructor executed?
· What is Dynamic Polymorphism?
· Write a macro for swapping integers.

DOT NET Interview Questions and Answers

DOT NET Interview Questions and Answers

Grid View

View How to use Scrollable functionality in datagrid.
View How to use multiple datakey names in gridview?
View How to use checkbox in gridview?

ASP.NET 2.0

View How to open pop-up window in asp.net ?
View How to use caching in asp.net ?
View How to redirect login page after session time out?
View How to fill dropdown list in ASP.NET ?
View How to write XML file in ASP.NET ?
View How to send an email with attachment in ASP.NET ?
View How to save and retrive image from sql server in ASP.NET ?
View How to upload file in ASP.NET ?
View Common frequently asked question in Interview on ASP.NET

DOT NET

View Frequently Asked Questions 1
View Frequently Asked Questions 2

Demo Credit card number

Software development life cycle

HTTP Status Codes

Website blocking software

Parental control software

Click Here to free download

Responsible Surfing is a multi-functional computer safety and parental control software developed to ensure a safe computer environment for children, families and individuals and keep users safe from harm.

The program was developed under the supervision of a group of clinical psychologists who have extensive experience working with various net addiction (game addiction, chat addiction, sex addiction, gambling addiction), sexual predators in prison settings, victims of sexual predators (both online and offline predators) as well as experience in counselling couples who have been through online adultery.

The software was developed as a tool for parents to control internet and computer use; to limit access to potentially harmful material, such as pornography, violence and other offensive and/or illegal material, limit time spent online and monitor computer use. The program also offers the possibility of limiting the time spent online or other aspects of computer usage that have been linked to problems, such as watching films, playing computer games, chatting, gambling and so on. It has also been developed to protect personal information when chatting and sending e-mails, so predators can not reach your children or yourself.

Our extensive knowledge of clinical psychology and research of net addiction and the various dangers of the internet we have made Responsible Surfing unique. It should benefit both parents who want to protect their children and those who have already developed an addiction or compulsive internet habits. The responsiblesurfing.com website also offers an extensive information and support section with quality information about the program and the different problems it addresses. This section offers articles, safe surfing contracts and Training materials for the parental control software itself.

Click Here to free download

The below given credit card number are use for demo only.

Card Type Number

Master Card (16 Digits) 5105105105105100

Master Card (16 Digits) 5555555555554444

Visa (13 Digits) 4222222222222

Visa (16 Digits) 4111111111111111

Visa (16 Digits) 4012888888881881

American Express (15 Digits) 378282246310005

American Express (15 Digits) 371449635398431

Amex Corporate (15 Digits) 378734493671000

Dinners Club (14 Digits) 38520000023237

Dinners Club (14 Digits) 30569309025904

Discover (16 Digits) 6011111111111117

Discover (16 Digits) 6011000990139424

JCB (16 Digits) 3530111333300000

JCB (16 Digits) 3566002020360505

SQL Interview Questions with Answers

What is RDBMS?

Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained across and among the data and tables. In a relational database, relationships between data items are expressed by means of tables. Interdependencies among these tables are expressed by data values rather than by pointers. This allows a high degree of data independence. An RDBMS has the capability to recombine the data items from different files, providing powerful tools for data usage.

What is normalization?

Database normalization is a data design and organization process applied to data structures based on rules that help build relational databases. In relational database design, the process of organizing data to minimize redundancy. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.

What are different normalization forms?

1NF: Eliminate Repeating Groups

Make a separate table for each set of related attributes, and give each table a primary key. Each field contains at most one value from its attribute domain.

2NF: Eliminate Redundant Data

If an attribute depends on only part of a multi-valued key, remove it to a separate table.

3NF: Eliminate Columns Not Dependent On Key

If attributes do not contribute to a description of the key, remove them to a separate table. All attributes must be directly dependent on the primary key

BCNF: Boyce-Codd Normal Form

If there are non-trivial dependencies between candidate key attributes, separate them out into distinct tables.

4NF: Isolate Independent Multiple Relationships

No table may contain two or more 1:n or n:m relationships that are not directly related.

5NF: Isolate Semantically Related Multiple Relationships

There may be practical constrains on information that justify separating logically related many-to-many relationships.

ONF: Optimal Normal Form

A model limited to only simple (elemental) facts, as expressed in Object Role Model notation.

DKNF: Domain-Key Normal Form

A model free from all modification anomalies.

Remember, these normalization guidelines are cumulative. For a database to be in 3NF, it must first fulfill all the criteria of a 2NF and 1NF database.

What is Stored Procedure?

A stored procedure is a named group of SQL statements that have been previously created and stored in the server database. Stored procedures accept input parameters so that a single procedure can be used over the network by several clients using different input data. And when the procedure is modified, all clients automatically get the new version. Stored procedures reduce network traffic and improve performance. Stored procedures can be used to help ensure the integrity of the database.
e.g. sp_helpdb, sp_renamedb, sp_depends etc.

What is Trigger?

A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are stored in and managed by the DBMS.Triggers are used to maintain the referential integrity of data by changing the data in a systematic fashion. A trigger cannot be called or executed; the DBMS automatically fires the trigger as a result of a data modification to the associated table.

Triggers can be viewed as similar to stored procedures in that both consist of procedural logic that is stored at the database level. Stored procedures, however, are not event-drive and are not attached to a specific table as triggers are. Stored procedures are explicitly executed by invoking a CALL to the procedure while triggers are implicitly executed. In addition, triggers can also execute stored procedures.

Nested Trigger: A trigger can also contain INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause another data modification, thereby firing another trigger. A trigger that contains data modification logic within itself is called a nested trigger.

What is View?

A simple view can be thought of as a subset of a table. It can be used for retrieving data, as well as updating or deleting rows. Rows updated or deleted in the view are updated or deleted in the table the view was created with. It should also be noted that as data in the original table changes, so does data in the view, as views are the way to look at part of the original table. The results of using a view are not permanently stored in the database. The data accessed through a view is actually constructed using standard T-SQL select command and can come from one to many different base tables or even other views.

What is Index?

An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to create an index on one or more columns of a table, and each index is given a name. The users cannot see the indexes, they are just used to speed up queries. Effective indexes are one of the best ways to improve performance in a database application. A table scan happens when there is no index available to help a query. In a table scan SQL Server examines every row in the table to satisfy the query results. Table scans are sometimes unavoidable, but on large tables, scans have a terrific impact on performance.

Clustered indexes define the physical sorting of a database table’s rows in the storage media. For this reason, each database table may have only one clustered index.

Non-clustered indexes are created outside of the database table and contain a sorted list of references
to the table itself.

What is the difference between clustered and a non-clustered index?

A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

What are the different index configurations a table can have?

A table can have one of the following index configurations:

No indexes
A clustered index
A clustered index and many nonclustered indexes
A nonclustered index
Many nonclustered indexes

What is cursors?

Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time.

In order to work with a cursor we need to perform some steps in the following order:

Declare cursor
Open cursor
Fetch row from the cursor
Process fetched row
Close cursor
Deallocate cursor

What is the use of DBCC commands?

DBCC stands for database consistency checker. We use these commands to check the consistency of the databases, i.e., maintenance, validation task and status checks.

E.g. DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.
DBCC CHECKALLOC - To check that all pages in a db are correctly allocated.
DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

What is a Linked Server?

Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With a linked server, you can create very clean, easy to follow, SQL statements that allow remote data to be retrieved, joined and combined with local data. Storped Procedure sp_addlinkedserver, sp_addlinkedsrvlogin will be used add new Linked Server.

What is Collation?

Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying casesensitivity, accent marks, kana character types and character width.

What are different type of Collation Sensitivity?

Case sensitivity
A and a, B and b, etc.
Accent sensitivity
a and á, o and ó, etc.
Kana Sensitivity
When Japanese kana characters Hiragana and Katakana are treated differently, it is called Kana
sensitive.
Width sensitivity
When a single-byte character (half-width) and the same character when represented as a double-byte
character (full-width) are treated differently then it is width sensitive.

What's the difference between a primary key and a unique key?

Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn't allow NULLs, but unique key allows one NULL only.

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships.
One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships.
Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.

What is a NOLOCK?

Using the NOLOCK query optimiser hint is generally considered good practice in order to improve concurrency on a busy system. When the NOLOCK hint is included in a SELECT statement, no locks are taken when data is read. The result is a Dirty Read, which means that another process could be updating the data at the exact time you are reading it. There are no guarantees that your query will retrieve the most recent data. The advantage to performance is that your reading of data will not block updates from taking place, and updates will not block your reading of data. SELECT statements take Shared (Read) locks. This means that multiple SELECT statements are allowed simultaneous access, but other processes are blocked from modifying the data. The updates will queue until all the reads have completed, and reads requested after the update will wait for the updates to complete. The result to your system is delay(blocking).

What is difference between DELETE & TRUNCATE commands?

Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command.

TRUNCATE

TRUNCATE is faster and uses fewer system and transaction log resources than DELETE.
TRUNCATE removes the data by deallocating the data pages used to store the table’s data, and only the page deallocations are recorded in the transaction log.
TRUNCATE removes all rows from a table, but the table structure and its columns, constraints, indexes
and so on remain. The counter used by an identity for new rows is reset to the seed for the column.
You cannot use TRUNCATE TABLE on a table referenced by a FOREIGN KEY constraint.
Because TRUNCATE TABLE is not logged, it cannot activate a trigger.
TRUNCATE can not be Rolled back.
TRUNCATE is DDL Command.
TRUNCATE Resets identity of the table.

DELETE

DELETE removes rows one at a time and records an entry in the transaction log for each deleted row. If you want to retain the identity counter, use DELETE instead. If you want to remove table definition and its data, use the DROP TABLE statement.
DELETE Can be used with or without a WHERE clause
DELETE Activates Triggers.
DELETE Can be Rolled back.
DELETE is DML Command.
DELETE does not reset identity of the table.

Difference between Function and Stored Procedure?

UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where as Stored procedures cannot be.

UDFs that return tables can be treated as another rowset. This can be used in JOINs with other tables.

Inline UDF's can be though of as views that take parameters and can be used in JOINs and other Rowset operations.

When is the use of UPDATE_STATISTICS command?

This command is basically used when a large processing of data has occurred. If a large amount of deletions any modification or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.

What types of Joins are possible with Sql Server?

Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table.

Types of joins: INNER JOINs, OUTER JOINs, CROSS JOINs. OUTER JOINs are further classified as LEFT
OUTER JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS.

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

Specifies a search condition for a group or an aggregate. HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query. WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.

What is sub-query? Explain properties of sub-query.

Sub-queries are often referred to as sub-selects, as they allow a SELECT statement to be executed arbitrarily within the body of another SQL statement. A sub-query is executed by enclosing it in a set of parentheses. Sub-queries are generally used to return a single row as an atomic value, though they may be used to compare values against multiple rows with the IN keyword.

A subquery is a SELECT statement that is nested within another T-SQL statement. A subquery SELECT statement if executed independently of the T-SQL statement, in which it is nested, will return a result set. Meaning a subquery SELECT statement can standalone and is not depended on the statement in which it is nested. A subquery SELECT statement can return any number of values, and can be found in, the column list of a SELECT statement, a FROM, GROUP BY, HAVING, and/or ORDER BY clauses of a T-SQL statement. A Subquery can also be used as a parameter to a function call. Basically a subquery can be used anywhere an expression can be used.

Properties of Sub-Query

A subquery must be enclosed in the parenthesis.
A subquery must be put in the right hand of the comparison operator, and
A subquery cannot contain a ORDER-BY clause.
A query can contain more than one sub-queries.

What are types of sub-queries?

Single-row subquery, where the subquery returns only one row.
Multiple-row subquery, where the subquery returns multiple rows,.and
Multiple column subquery, where the subquery returns multiple columns.

What is SQL Profiler?

SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save data about each event to a file or SQL Server table to analyze later. For example, you can monitor a production environment to see which stored procedures are hampering performance by executing too slowly.
Use SQL Profiler to monitor only the events in which you are interested. If traces are becoming too large, you can filter them based on the information you want, so that only a subset of the event data is collected. Monitoring too many events adds overhead to the server and the monitoring process and can cause the trace file or trace table to grow very large, especially when the monitoring process takes place over a long period of time.

What is User Defined Functions?

User-Defined Functions allow to define its own T-SQL functions that can accept 0 or more parameters and return a single scalar data value or a table data type.

What kind of User-Defined Functions can be created?

There are three types of User-Defined functions in SQL Server 2000 and they are Scalar, Inline Table- Valued and Multi-statement Table-valued.

Scalar User-Defined Function

A Scalar user-defined function returns one of the scalar data types. Text, ntext, image and timestamp data types are not supported. These are the type of user-defined functions that most developers are used to in other programming languages. You pass in 0 to many parameters and you get a return value.

Inline Table-Value User-Defined Function

An Inline Table-Value user-defined function returns a table data type and is an exceptional alternative to a view as the user-defined function can pass parameters into a T-SQL select command and in essence provide us with a parameterized, non-updateable view of the underlying tables.

Multi-statement Table-Value User-Defined Function

A Multi-Statement Table-Value user-defined function returns a table and is also an exceptional alternative to a view as the function can support multiple T-SQL statements to build the final result where the view is limited to a single SELECT statement. Also, the ability to pass parameters into a TSQL select command or a group of them gives us the capability to in essence create a parameterized, non-updateable view of the data in the underlying tables. Within the create function command you must define the table structure that is being returned. After creating this type of user-defined function, It can be used in the FROM clause of a T-SQL command unlike the behavior found when using a stored procedure which can also return record sets.

Which TCP/IP port does SQL Server run on? How can it be changed?

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties –> Port number.both on client and the server.

What are the authentication modes in SQL Server? How can it be changed?

Windows mode and mixed mode (SQL & Windows).

To change authentication mode in SQL Server click Start, Programs, Microsoft SQL Server and click SQL Enterprise Manager to run SQL Enterprise Manager from the Microsoft SQL Server program group.

Select the server then from the Tools menu select SQL Server Configuration Properties, and choose the Security page.

Where are SQL server users names and passwords are stored in sql server?

They get stored in master db in the sysxlogins table.

Which command using Query Analyzer will give you the version of SQL server and operating system?

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY
('edition')

What is SQL server agent?

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). It is often overlooked as one of the main tools for SQL Server management. Its purpose is to ease the implementation of tasks for the DBA, with its full-function scheduling engine, which allows you to schedule your own jobs and scripts.

Can a stored procedure call itself or recursive stored procedure? How many level SP nesting possible?

Yes. Because Transact-SQL supports recursion, you can write stored procedures that call themselves. Recursion can be defined as a method of problem solving wherein the solution is arrived at by repetitively applying it to subsets of the problem. A common application of recursive logic is to perform numeric computations that lend themselves to repetitive evaluation by the same processing steps.

Stored procedures are nested when one stored procedure calls another or executes managed code by referencing a CLR routine, type, or aggregate. You can nest stored procedures and managed code references up to 32 levels.

What is @@ERROR?

The @@ERROR automatic variable returns the error code of the last Transact-SQL statement. If there was no error, @@ERROR returns zero. Because @@ERROR is reset after each Transact-SQL statement, it must be saved to a variable if it is needed to process it further after checking it.

What is Raiseerror?

Stored procedures report errors to client applications via the RAISERROR command. RAISERROR doesn't change the flow of a procedure; it merely displays an error message, sets the @@ERROR automatic variable, and optionally writes the message to the SQL Server error log and the NT application event log.

What is log shipping?

Log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server. Enterprise Editions only supports log shipping. In log shipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db can be used this as the Disaster Recovery plan. The key feature of log shipping is that is will automatically backup transaction logs throughout the day and automatically restore them on the standby server at defined interval.

What is the difference between a local and a global variable?

A local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement.
A global temporary table remains in the database permanently, but the rows exist only within a given connection. When connection are closed, the data in the global temporary table disappears. However, the table definition remains with the database for access when database is opened next time.

What command do we use to rename a db?

sp_renamedb ‘oldname’ , ‘newname’

If someone is using db it will not accept sp_renmaedb. In that case first bring db to single user using sp_dboptions. Use sp_renamedb to rename database. Use sp_dboptions to bring database to multi user mode.

What is sp_configure commands and set commands?

Use sp_configure to display or change server-level settings. To change database-level settings, use ALTER DATABASE. To change settings that affect only the current user session, use the SET statement.

What are the different types of replication? Explain.

The SQL Server 2000-supported replication types are as follows:

· Transactional
· Snapshot
· Merge

Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. Snapshot replication is best used as a method for replicating data that changes infrequently or where the most up-to-date values (low latency) are not a requirement. When synchronization occurs, the entire snapshot is generated and sent to Subscribers.

Transactional replication, an initial snapshot of data is applied at Subscribers, and then when data modifications are made at the Publisher, the individual transactions are captured and propagated to Subscribers.

Merge replication is the process of distributing data from Publisher to Subscribers, allowing the Publisher and Subscribers to make updates while connected or disconnected, and then merging the updates between sites when they are connected.

What are the OS services that the SQL Server installation adds?

MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution transac co-ordinator)

What are three SQL keywords used to change or set someone’s permissions?

GRANT, DENY, and REVOKE.

What does it mean to have quoted_identifier on? What are the implications of having it off?

When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. When SET QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers.

What is the STUFF function and how does it differ from the REPLACE function?

STUFF function to overwrite existing characters. Using this syntax, STUFF(string_expression, start, length, replacement_characters), string_expression is the string that will have characters substituted, start is the starting position, length is the number of characters in the string that are substituted, and replacement_characters are the new characters interjected into the string.

REPLACE function to replace existing characters of all occurance. Using this syntax REPLACE(string_expression, search_string, replacement_string), where every incidence of search_string found in the string_expression will be replaced with replacement_string.

Using query analyzer, name 3 ways to get an accurate count of the number of records in a table?

SELECT * FROM table1
SELECT COUNT(*) FROM table1
SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2

How to rebuild Master Database?

Shutdown Microsoft SQL Server 2000, and then run Rebuildm.exe. This is located in the Program Files\Microsoft SQL Server\80\Tools\Binn directory. In the Rebuild Master dialog box, click Browse. In the Browse for Folder dialog box, select the \Data folder on the SQL Server 2000 compact disc or in the shared network directory from which SQL Server 2000 was installed, and then click OK. Click Settings. In the Collation Settings dialog box, verify or change settings used for the master database and all other databases. Initially, the default collation settings are shown, but these may not match the collation selected during setup. You can select the same settings used during setup or select new collation settings. When done, click OK. In the Rebuild Master dialog box, click Rebuild to start the process. The Rebuild Master utility reinstalls the master database. To continue, you may need to stop a server that is running.
Source: http://msdn2.microsoft.com/en-us/library/aa197950(SQL.80).aspx

What is the basic functions for master, msdb, model, tempdb databases?

The Master database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer this database with care. The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping. The tempdb holds temporary objects such as global and local temporary tables and stored procedures. The model is essentially a template database used in the creation of any new user database created in the instance.

What are primary keys and foreign keys?

Primary keys are the unique identifiers for each row. They must contain unique values and cannot be null. Due to their importance in relational databases, Primary keys are the most fundamental of all keys and constraints. A table can have only one Primary key.

Foreign keys are both a method of ensuring data integrity and a manifestation of the relationship
between tables.

What is data integrity? Explain constraints?

Data integrity is an important feature in SQL Server. When used properly, it ensures that data is accurate, correct, and valid. It also acts as a trap for otherwise undetectable bugs within applications.

A PRIMARY KEY constraint is a unique identifier for a row within a database table. Every table should have a primary key constraint to uniquely identify each row and only one primary key constraint can be created for each table. The primary key constraints are used to enforce entity integrity.

A UNIQUE constraint enforces the uniqueness of the values in a set of columns, so no duplicate values are entered. The unique key constraints are used to enforce entity integrity as the primary key constraints.

A FOREIGN KEY constraint prevents any actions that would destroy links between tables with the corresponding data values. A foreign key in one table points to a primary key in another table. Foreign keys prevent actions that would leave rows with foreign key values when there are no primary keys with that value. The foreign key constraints are used to enforce referential integrity.

A CHECK constraint is used to limit the values that can be placed in a column. The check constraints are used to enforce domain integrity.

A NOT NULL constraint enforces that the column will not accept null values. The not null constraints are used to enforce domain integrity, as the check constraints.

What are the properties of the Relational tables?

Relational tables have six properties:

· Values are atomic.
· Column values are of the same kind.
· Each row is unique.
· The sequence of columns is insignificant.
· The sequence of rows is insignificant.
· Each column must have a unique name.

What is De-normalization?

De-normalization is the process of attempting to optimize the performance of a database by adding redundant data. It is sometimes necessary because current DBMSs implement the relational model poorly. A true relational DBMS would allow for a fully normalized database at the logical level, while providing physical storage of data that is tuned for high performance. De-normalization is a technique to move from higher to lower normal forms of database modeling in order to speed up database access.

How to get @@error and @@rowcount at the same time?

If @@Rowcount is checked after Error checking statement then it will have 0 as the value of @@Recordcount as it would have been reset. And if @@Recordcount is checked before the error-checking statement then @@Error would get reset. To get @@error and @@rowcount at the same time do both in same statement and store them in local
variable. SELECT @RC = @@ROWCOUNT, @ER = @@ERROR

What is Identity?

Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID column also generates numbers, the value of this cannot be controled. Identity/GUID columns do not need to be indexed.

What is a Scheduled Jobs or What is a Scheduled Tasks?

Scheduled tasks let user automate processes that run on regular or predictable cycles. User can schedule administrative tasks, such as cube processing, to run during times of slow business activity. User can also determine the order in which tasks run by creating job steps within a SQL Server Agent job. E.g. Back up database, Update Stats of Tables. Job steps give user control over flow of execution.
If one job fails, user can configure SQL Server Agent to continue to run the remaining tasks or to stop execution.

What is a table called, if it does not have neither Cluster nor Non-cluster Index? What is it used for?

A heap is a table that does not have a clustered index and, therefore, the pages are not linked by pointers. The IAM pages are the only structures that link the pages in a table together.

Unindexed tables are good for fast storing of data. Many times it is better to drop all indexes from table and than do bulk of inserts and to restore those indexes after that.

What is BCP? When does it used?

BulkCopy is a tool used to copy huge amount of data from tables and views. BCP does not copy the structures same as source to destination.

How do you load large data to the SQL server database?

BulkCopy is a tool used to copy huge amount of data from tables. BULK INSERT command helps to Imports a data file into a database table or view in a user-specified format.

Can we rewrite subqueries into simple select statements or with joins?

Subqueries can often be re-written to use a standard outer join, resulting in faster performance. As we may know, an outer join uses the plus sign (+) operator to tell the database to return all non-matching rows with NULL values. Hence we combine the outer join with a NULL test in the WHERE clause to reproduce the result set without using a sub-query.

Can SQL Servers linked to other servers like Oracle?

SQL Server can be lined to any server provided it has OLE-DB provider from Microsoft to allow a link. E.g. Oracle has a OLE-DB provider for oracle that Microsoft provides to add it as linked server to SQL Server group.

How to know which index a table is using?

SELECT table_name,index_name FROM user_constraints

How to copy the tables, schema and views from one SQL server to another?

Microsoft SQL Server 2000 Data Transformation Services (DTS) is a set of graphical tools and programmable objects that lets user extract, transform, and consolidate data from disparate sources into single or multiple destinations.

What is Self Join?

This is a particular case when one table joins to itself, with one or two aliases to avoid confusion. A self join can be of any type, as long as the joined tables are the same. A self join is rather unique in that it involves a relationship with only one table. The common example is when company have a hierarchal reporting structure whereby one member of staff reports to another.

What is Cross Join?

A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table. The common example is when company wants to combine each product with a pricing table to analyze each product at each price.

Which virtual table does a trigger use?

Inserted and Deleted.

List few advantages of Stored Procedure.

· Stored procedure can reduced network traffic and latency, boosting application performance.
· Stored procedure execution plans can be reused, staying cached in SQL Server's memory,

reducing server overhead.

· Stored procedures help promote code reuse.
· Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients.
· Stored procedures provide better security to your data.

What is DataWarehousing?

· Subject-oriented, meaning that the data in the database is organized so that all the data elements relating to the same real-world event or object are linked together.
· Time-variant, meaning that the changes to the data in the database are tracked and recorded so that reports can be produced showing changes over time.
· Non-volatile, meaning that data in the database is never over-written or deleted, once committed, the data is static, read-only, but retained for future reporting.
· Integrated, meaning that the database contains data from most or all of an organization's operational applications, and that this data is made consistent.

What is OLTP(OnLine Transaction Processing)?

In OLTP - online transaction processing systems relational database design use the discipline of data modeling and generally follow the Codd rules of data normalization in order to ensure absolute data integrity. Using these rules complex information is broken down into its most simple structures (a table) where all of the individual atomic level elements relate to each other and satisfy the normalization rules.

How do SQL server 2000 and XML linked? Can XML be used to access data?

FOR XML (ROW, AUTO, EXPLICIT)

You can execute SQL queries against existing relational databases to return results as XML rather than standard rowsets. These queries can be executed directly or from within stored procedures. To retrieve XML results, use the FOR XML clause of the SELECT statement and specify an XML mode of RAW, AUTO, or EXPLICIT.

OPENXML

OPENXML is a Transact-SQL keyword that provides a relational/rowset view over an in-memory XML document. OPENXML is a rowset provider similar to a table or a view. OPENXML provides a way to access XML data within the Transact-SQL context by transferring data from an XML document into the relational tables. Thus, OPENXML allows you to manage an XML document and its interaction with the relational environment.

What is an execution plan? When would you use it? How would you view the execution plan?

An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the SQL Server query optimizer for a stored procedure or ad-hoc query and is a very useful tool for a developer to understand the performance characteristics of a query or stored procedure since the plan is the one that SQL Server will place in its cache and use to execute the stored procedure or query. From within Query Analyzer is an option called "Show Execution Plan" (located on the Query drop-down menu). If this option is turned on it will display query execution plan in separate window when query is ran again.

General Guidelinesin Answering Interview Questions

Everyone is nervous on interviews. If you simply allow yourself to feel nervous, you'll do much better. Remember also that it's difficult for the interviewer as well.
In general, be upbeat and positive. Never be negative.
Rehearse your answers and time them. Never talk for more than 2 minutes straight.
Don't try to memorize answers word for word. Use the answers shown here as a guide only, and don't be afraid to include your own thoughts and words. To help you remember key concepts, jot down and review a few key words for each answer. Rehearse your answers frequently, and they will come to you naturally in interviews.
As you will read in the accompanying report, the single most important strategy in interviewing, as in all phases of your job search, is what we call: "The Greatest Executive Job Finding Secret." And that is...
Find out what people want, than show them how you can help them get it.
Find out what an employer wants most in his or her ideal candidate, then show how you meet those qualifications.
In other words, you must match your abilities, with the needs of the employer. You must sell what the buyer is buying. To do that, before you know what to emphasize in your answers, you must find out what the buyer is buying... what he is looking for. And the best way to do that is to ask a few questions yourself.
You will see how to bring this off skillfully as you read the first two questions of this report. But regardless of how you accomplish it, you must remember this strategy above all: before blurting out your qualifications, you must get some idea of what the employer wants most. Once you know what he wants, you can then present your qualifications as the perfect "key" that fits the "lock" of that position.
· Other important interview strategies:
· Turn weaknesses into strengths (You'll see how to do this in a few moments.)
· Think before you answer. A pause to collect your thoughts is a hallmark of a thoughtful person.
As a daily exercise, practice being more optimistic. For example, try putting a positive spin on events and situations you would normally regard as negative. This is not meant to turn you into a Pollyanna, but to sharpen your selling skills. The best salespeople, as well as the best liked interview candidates, come off as being naturally optimistic, "can do" people. You will dramatically raise your level of attractiveness by daily practicing to be more optimistic.
Be honest...never lie.
Keep an interview diary. Right after each interview note what you did right, what could have gone a little better, and what steps you should take next with this contact. Then take those steps. Don't be like the 95% of humanity who say they will follow up on something, but never do.

About the 64 questions...

You might feel that the answers to the following questions are "canned", and that they will seldom match up with the exact way you are asked the questions in actual interviews. The questions and answers are designed to be as specific and realistic as possible. But no preparation can anticipate thousands of possible variations on these questions. What's important is that you thoroughly familiarize yourself with the main strategies behind each answer. And it will be invaluable to you if you commit to memory a few key words that let you instantly call to mind your best answer to the various questions. If you do this, and follow the principles of successful interviewing presented here, you're going to do very well.
Good luck...and good job-hunting!

Question 1 Tell me about yourself.

TRAPS: Beware, about 80% of all interviews begin with this "innocent" question. Many candidates, unprepared for the question, skewer themselves by rambling, recapping their life story, delving into ancient work history or personal matters.
BEST ANSWER: Start with the present and tell why you are well qualified for the position. Remember that the key to all successful interviewing is to match your qualifications to what the interviewer is looking for. In other words you must sell what the buyer is buying. This is the single most important strategy in job hunting.
So, before you answer this or any question it's imperative that you try to uncover your interviewer's greatest need, want, problem or goal.
To do so, make you take these two steps:
1. Do all the homework you can before the interview to uncover this person's wants and needs (not the generalized needs of the industry or company)
2. As early as you can in the interview, ask for a more complete description of what the position entails. You might say: "I have a number of accomplishments I'd like to tell you about, but I want to make the best use of our time together and talk directly to your needs. To help me do, that, could you tell me more about the most important priorities of this position? All I know is what I (heard from the recruiter, read in the classified ad, etc.)"
Then, ALWAYS follow-up with a second and possibly, third question, to draw out his needs even more. Surprisingly, it's usually this second or third question that unearths what the interviewer is most looking for.
You might ask simply, "And in addition to that?..." or, "Is there anything else you see as essential to success in this position?:
This process will not feel easy or natural at first, because it is easier simply to answer questions, but only if you uncover the employer's wants and needs will your answers make the most sense. Practice asking these key questions before giving your answers, the process will feel more natural and you will be light years ahead of the other job candidates you're competing with.
After uncovering what the employer is looking for, describe why the needs of this job bear striking parallels to tasks you've succeeded at before. Be sure to illustrate with specific examples of your responsibilities and especially your achievements, all of which are geared to present yourself as a perfect match for the needs he has just described.

Question 2 What are your greatest strengths?

TRAPS: This question seems like a softball lob, but be prepared. You don't want to come across as egotistical or arrogant. Neither is this a time to be humble.
BEST ANSWER: You know that your key strategy is to first uncover your interviewer's greatest wants and needs before you answer questions. And from Question 1, you know how to do this.
Prior to any interview, you should have a list mentally prepared of your greatest strengths. You should also have, a specific example or two, which illustrates each strength, an example chosen from your most recent and most impressive achievements.
You should, have this list of your greatest strengths and corresponding examples from your achievements so well committed to memory that you can recite them cold after being shaken awake at 2:30AM.
Then, once you uncover your interviewer's greatest wants and needs, you can choose those achievements from your list that best match up.
As a general guideline, the 10 most desirable traits that all employers love to see in their employees are:
1. A proven track record as an achiever...especially if your achievements match up with the employer's greatest wants and needs.
2. Intelligence...management "savvy".
3. Honesty...integrity...a decent human being.
4. Good fit with corporate culture...someone to feel comfortable with...a team player who meshes well with interviewer's team.
5. Likeability...positive attitude...sense of humor.
6. Good communication skills.
7. Dedication...willingness to walk the extra mile to achieve excellence.
8. Definiteness of purpose...clear goals.
9. Enthusiasm...high level of motivation.
10. Confident...healthy...a leader.

Question 3 What are your greatest weaknesses?

TRAPS: Beware - this is an eliminator question, designed to shorten the candidate list. Any admission of a weakness or fault will earn you an "A" for honesty, but an "F" for the interview.
PASSABLE ANSWER: Disguise a strength as a weakness.
Example: "I sometimes push my people too hard. I like to work with a sense of urgency and everyone is not always on the same wavelength."
Drawback: This strategy is better than admitting a flaw, but it's so widely used, it is transparent to any experienced interviewer.
BEST ANSWER: (and another reason it's so important to get a thorough description of your interviewer's needs before you answer questions): Assure the interviewer that you can think of nothing that would stand in the way of your performing in this position with excellence. Then, quickly review you strongest qualifications.
Example: "Nobody's perfect, but based on what you've told me about this position, I believe I' d make an outstanding match. I know that when I hire people, I look for two things most of all. Do they have the qualifications to do the job well, and the motivation to do it well? Everything in my background shows I have both the qualifications and a strong desire to achieve excellence in whatever I take on. So I can say in all honesty that I see nothing that would cause you even a small concern about my ability or my strong desire to perform this job with excellence."
Alternate strategy (if you don't yet know enough about the position to talk about such a perfect fit):Instead of confessing a weakness, describe what you like most and like least, making sure that what you like most matches up with the most important qualification for success in the position, and what you like least is not essential.
Example: Let's say you're applying for a teaching position. "If given a choice, I like to spend as much time as possible in front of my prospects selling, as opposed to shuffling paperwork back at the office. Of course, I long ago learned the importance of filing paperwork properly, and I do it conscientiously. But what I really love to do is sell (if your interviewer were a sales manager, this should be music to his ears.)

Question 4 Tell me about something you did – or failed to do – that you now feel a little ashamed of.

TRAPS: There are some questions your interviewer has no business asking, and this is one. But while you may feel like answering, "none of your business," naturally you can’t. Some interviewers ask this question on the chance you admit to something, but if not, at least they’ll see how you think on your feet.
Some unprepared candidates, flustered by this question, unburden themselves of guilt from their personal life or career, perhaps expressing regrets regarding a parent, spouse, child, etc. All such answers can be disastrous.
BEST ANSWER: As with faults and weaknesses, never confess a regret. But don’t seem as if you’re stonewalling either.
Best strategy: Say you harbor no regrets, then add a principle or habit you practice regularly for healthy human relations.
Example: Pause for reflection, as if the question never occurred to you. Then say, "You know, I really can’t think of anything." (Pause again, then add): "I would add that as a general management principle, I’ve found that the best way to avoid regrets is to avoid causing them in the first place. I practice one habit that helps me a great deal in this regard. At the end of each day, I mentally review the day’s events and conversations to take a second look at the people and developments I’m involved with and do a doublecheck of what they’re likely to be feeling. Sometimes I’ll see things that do need more follow-up, whether a pat on the back, or maybe a five minute chat in someone’s office to make sure we’re clear on things…whatever."
"I also like to make each person feel like a member of an elite team, like the Boston Celtics or LA Lakers in their prime. I’ve found that if you let each team member know you expect excellence in their performance…if you work hard to set an example yourself…and if you let people know you appreciate and respect their feelings, you wind up with a highly motivated group, a team that’s having fun at work because they’re striving for excellence rather than brooding over slights or regrets."

Question 5 Why are you leaving (or did you leave) this position?

TRAPS: Never badmouth your previous industry, company, board, boss, staff, employees or customers. This rule is inviolable: never be negative. Any mud you hurl will only soil your suit.
Especially avoid words like "personality clash", "didn’t get along", or others which cast a shadow on your competence, integrity, or temperament.
BEST ANSWER:
(If you have a job presently)If you’re not yet 100% committed to leaving your present post, don’t be afraid to say so. Since you have a job, you are in a stronger position than someone who does not. But don’t be coy either. State honestly what you’d be hoping to find in a new spot. Of course, as stated often before, you answer will all the stronger if you have already uncovered what this position is all about and you match your desires to it.
(If you do not presently have a job.)Never lie about having been fired. It’s unethical – and too easily checked. But do try to deflect the reason from you personally. If your firing was the result of a takeover, merger, division wide layoff, etc., so much the better.
But you should also do something totally unnatural that will demonstrate consummate professionalism. Even if it hurts , describe your own firing – candidly, succinctly and without a trace of bitterness – from the company’s point-of-view, indicating that you could understand why it happened and you might have made the same decision yourself.
Your stature will rise immensely and, most important of all, you will show you are healed from the wounds inflicted by the firing. You will enhance your image as first-class management material and stand head and shoulders above the legions of firing victims who, at the slightest provocation, zip open their shirts to expose their battle scars and decry the unfairness of it all.
For all prior positions:Make sure you’ve prepared a brief reason for leaving. Best reasons: more money, opportunity, responsibility or growth.

Question 6 The "Silent Treatment"

TRAPS: Beware – if you are unprepared for this question, you will probably not handle it right and possibly blow the interview. Thank goodness most interviewers don’t employ it. It’s normally used by those determined to see how you respond under stress. Here’s how it works:
You answer an interviewer’s question and then, instead of asking another, he just stares at you in a deafening silence.
You wait, growing a bit uneasy, and there he sits, silent as Mt. Rushmore, as if he doesn’t believe what you’ve just said, or perhaps making you feel that you’ve unwittingly violated some cardinal rule of interview etiquette.
When you get this silent treatment after answering a particularly difficult question , such as "tell me about your weaknesses", its intimidating effect can be most disquieting, even to polished job hunters.
Most unprepared candidates rush in to fill the void of silence, viewing prolonged, uncomfortable silences as an invitation to clear up the previous answer which has obviously caused some problem. And that’s what they do – ramble on, sputtering more and more information, sometimes irrelevant and often damaging, because they are suddenly playing the role of someone who’s goofed and is now trying to recoup. But since the candidate doesn’t know where or how he goofed, he just keeps talking, showing how flustered and confused he is by the interviewer’s unmovable silence.
BEST ANSWER: Like a primitive tribal mask, the Silent Treatment loses all it power to frighten you once you refuse to be intimidated. If your interviewer pulls it, keep quiet yourself for a while and then ask, with sincere politeness and not a trace of sarcasm, "Is there anything else I can fill in on that point?" That’s all there is to it.
Whatever you do, don’t let the Silent Treatment intimidate you into talking a blue streak, because you could easily talk yourself out of the position.

Question 7 Why should I hire you?

TRAPS: Believe it or not, this is a killer question because so many candidates are unprepared for it. If you stammer or adlib you’ve blown it.
BEST ANSWER: By now you can see how critical it is to apply the overall strategy of uncovering the employer’s needs before you answer questions. If you know the employer’s greatest needs and desires, this question will give you a big leg up over other candidates because you will give him better reasons for hiring you than anyone else is likely to…reasons tied directly to his needs.
Whether your interviewer asks you this question explicitly or not, this is the most important question of your interview because he must answer this question favorably in is own mind before you will be hired. So help him out! Walk through each of the position’s requirements as you understand them, and follow each with a reason why you meet that requirement so well.
Example: "As I understand your needs, you are first and foremost looking for someone who can manage the sales and marketing of your book publishing division. As you’ve said you need someone with a strong background in trade book sales. This is where I’ve spent almost all of my career, so I’ve chalked up 18 years of experience exactly in this area. I believe that I know the right contacts, methods, principles, and successful management techniques as well as any person can in our industry."
"You also need someone who can expand your book distribution channels. In my prior post, my innovative promotional ideas doubled, then tripled, the number of outlets selling our books. I’m confident I can do the same for you."
"You need someone to give a new shot in the arm to your mail order sales, someone who knows how to sell in space and direct mail media. Here, too, I believe I have exactly the experience you need. In the last five years, I’ve increased our mail order book sales from $600,000 to $2,800,000, and now we’re the country’s second leading marketer of scientific and medical books by mail." Etc., etc., etc.,
Every one of these selling "couplets" (his need matched by your qualifications) is a touchdown that runs up your score. IT is your best opportunity to outsell your competition.Top
Question 8 Aren’t you overqualified for this position?
TRAPS: The employer may be concerned that you’ll grow dissatisfied and leave.
BEST ANSWER: As with any objection, don’t view this as a sign of imminent defeat. It’s an invitation to teach the interviewer a new way to think about this situation, seeing advantages instead of drawbacks.
Example: "I recognize the job market for what it is – a marketplace. Like any marketplace, it’s subject to the laws of supply and demand. So ‘overqualified’ can be a relative term, depending on how tight the job market is. And right now, it’s very tight. I understand and accept that."
"I also believe that there could be very positive benefits for both of us in this match."
"Because of my unusually strong experience in ________________ , I could start to contribute right away, perhaps much faster than someone who’d have to be brought along more slowly."
"There’s also the value of all the training and years of experience that other companies have invested tens of thousands of dollars to give me. You’d be getting all the value of that without having to pay an extra dime for it. With someone who has yet to acquire that experience, he’d have to gain it on your nickel."
"I could also help you in many things they don’t teach at the Harvard Business School. For example…(how to hire, train, motivate, etc.) When it comes to knowing how to work well with people and getting the most out of them, there’s just no substitute for what you learn over many years of front-line experience. You company would gain all this, too."
"From my side, there are strong benefits, as well. Right now, I am unemployed. I want to work, very much, and the position you have here is exactly what I love to do and am best at. I’ll be happy doing this work and that’s what matters most to me, a lot more that money or title."
"Most important, I’m looking to make a long term commitment in my career now. I’ve had enough of job-hunting and want a permanent spot at this point in my career. I also know that if I perform this job with excellence, other opportunities cannot help but open up for me right here. In time, I’ll find many other ways to help this company and in so doing, help myself. I really am looking to make a long-term commitment."
NOTE: The main concern behind the "overqualified" question is that you will leave your new employer as soon as something better comes your way. Anything you can say to demonstrate the sincerity of your commitment to the employer and reassure him that you’re looking to stay for the long-term will help you overcome this objection.Top
Question 9 Where do you see yourself five years from now?
TRAPS: One reason interviewers ask this question is to see if you’re settling for this position, using it merely as a stopover until something better comes along. Or they could be trying to gauge your level of ambition.
If you’re too specific, i.e., naming the promotions you someday hope to win, you’ll sound presumptuous. If you’re too vague, you’ll seem rudderless.
BEST ANSWER: Reassure your interviewer that you’re looking to make a long-term commitment…that this position entails exactly what you’re looking to do and what you do extremely well. As for your future, you believe that if you perform each job at hand with excellence, future opportunities will take care of themselves.
Example: "I am definitely interested in making a long-term commitment to my next position. Judging by what you’ve told me about this position, it’s exactly what I’m looking for and what I am very well qualified to do. In terms of my future career path, I’m confident that if I do my work with excellence, opportunities will inevitable open up for me. It’s always been that way in my career, and I’m confident I’ll have similar opportunities here."Top
Question 10 Describe your ideal company, location and job.
TRAPS: This is often asked by an experienced interviewer who thinks you may be overqualified, but knows better than to show his hand by posing his objection directly. So he’ll use this question instead, which often gets a candidate to reveal that, indeed, he or she is looking for something other than the position at hand.
BEST ANSWER: The only right answer is to describe what this company is offering, being sure to make your answer believable with specific reasons, stated with sincerity, why each quality represented by this opportunity is attractive to you.
Remember that if you’re coming from a company that’s the leader in its field or from a glamorous or much admired company, industry, city or position, your interviewer and his company may well have an "Avis" complex. That is, they may feel a bit defensive about being "second best" to the place you’re coming from, worried that you may consider them bush league.
This anxiety could well be there even though you’ve done nothing to inspire it. You must go out of your way to assuage such anxiety, even if it’s not expressed, by putting their virtues high on the list of exactly what you’re looking for, providing credible reason for wanting these qualities.
If you do not express genuine enthusiasm for the firm, its culture, location, industry, etc., you may fail to answer this "Avis" complex objection and, as a result, leave the interviewer suspecting that a hot shot like you, coming from a Fortune 500 company in New York, just wouldn’t be happy at an unknown manufacturer based in Topeka, Kansas.

Question 11 Why do you want to work at our company?

TRAPS: This question tests whether you’ve done any homework about the firm. If you haven’t, you lose. If you have, you win big.
BEST ANSWER: This question is your opportunity to hit the ball out of the park, thanks to the in-depth research you should do before any interview.
Best sources for researching your target company: annual reports, the corporate newsletter, contacts you know at the company or its suppliers, advertisements, articles about the company in the trade press.

Question 12 What are your career options right now?

TRAPS: The interviewer is trying to find out, "How desperate are you?"
BEST ANSWER: Prepare for this question by thinking of how you can position yourself as a desired commodity. If you are still working, describe the possibilities at your present firm and why, though you’re greatly appreciated there, you’re looking for something more (challenge, money, responsibility, etc.). Also mention that you’re seriously exploring opportunities with one or two other firms.
If you’re not working, you can talk about other employment possibilities you’re actually exploring. But do this with a light touch, speaking only in general terms. You don’t want to seem manipulative or coy.

Question 13 Why have you been out of work so long?

TRAPS: A tough question if you’ve been on the beach a long time. You don’t want to seem like damaged goods.
BEST ANSWER: You want to emphasize factors which have prolonged your job search by your own choice.
Example: "After my job was terminated, I made a conscious decision not to jump on the first opportunities to come along. In my life, I’ve found out that you can always turn a negative into a positive IF you try hard enough. This is what I determined to do. I decided to take whatever time I needed to think through what I do best, what I most want to do, where I’d like to do it…and then identify those companies that could offer such an opportunity."
"Also, in all honesty, you have to factor in the recession (consolidation, stabilization, etc.) in the (banking, financial services, manufacturing, advertising, etc.) industry."
"So between my being selective and the companies in our industry downsizing, the process has taken time. But in the end, I’m convinced that when I do find the right match, all that careful evaluation from both sides of the desk will have been well worthwhile for both the company that hires me and myself.

Question 14 Tell me honestly about the strong points and weak points of your boss (company, management team, etc.)…

TRAPS: Skillfull interviewers sometimes make it almost irresistible to open up and air a little dirty laundry from your previous position. DON’T
BEST ANSWER: Remember the rule: Never be negative. Stress only the good points, no matter how charmingly you’re invited to be critical.
Your interviewer doesn’t care a whit about your previous boss. He wants to find out how loyal and positive you are, and whether you’ll criticize him behind his back if pressed to do so by someone in this own company. This question is your opportunity to demonstrate your loyalty to those you work with.

Question 15 What good books have you read lately?

TRAPS: As in all matters of your interview, never fake familiarity you don’t have. Yet you don’t want to seem like a dullard who hasn’t read a book since Tom Sawyer.
BEST ANSWER: Unless you’re up for a position in academia or as book critic for The New York Times, you’re not expected to be a literary lion. But it wouldn’t hurt to have read a handful of the most recent and influential books in your profession and on management.
Consider it part of the work of your job search to read up on a few of these leading books. But make sure they are quality books that reflect favorably upon you, nothing that could even remotely be considered superficial. Finally, add a recently published bestselling work of fiction by a world-class author and you’ll pass this question with flying colors.

Question 16 Tell me about a situation when your work was criticized.

TRAPS: This is a tough question because it’s a more clever and subtle way to get you to admit to a weakness. You can’t dodge it by pretending you’ve never been criticized. Everybody has been. Yet it can be quite damaging to start admitting potential faults and failures that you’d just as soon leave buried.
This question is also intended to probe how well you accept criticism and direction.

BEST ANSWERS: Begin by emphasizing the extremely positive feedback you’ve gotten throughout your career and (if it’s true) that your performance reviews have been uniformly excellent.
Of course, no one is perfect and you always welcome suggestions on how to improve your performance. Then, give an example of a not-too-damaging learning experience from early in your career and relate the ways this lesson has since helped you. This demonstrates that you learned from the experience and the lesson is now one of the strongest breastplates in your suit of armor.
If you are pressed for a criticism from a recent position, choose something fairly trivial that in no way is essential to your successful performance. Add that you’ve learned from this, too, and over the past several years/months, it’s no longer an area of concern because you now make it a regular practice to…etc.
Another way to answer this question would be to describe your intention to broaden your master of an area of growing importance in your field. For example, this might be a computer program you’ve been meaning to sit down and learn… a new management technique you’ve read about…or perhaps attending a seminar on some cutting-edge branch of your profession.
Again, the key is to focus on something not essential to your brilliant performance but which adds yet another dimension to your already impressive knowledge base.

Question 17 What are your outside interests?

TRAPS: You want to be a well-rounded, not a drone. But your potential employer would be even more turned off if he suspects that your heavy extracurricular load will interfere with your commitment to your work duties.
BEST ANSWERS: Try to gauge how this company’s culture would look upon your favorite outside activities and be guided accordingly.
You can also use this question to shatter any stereotypes that could limit your chances. If you’re over 50, for example, describe your activities that demonstrate physical stamina. If you’re young, mention an activity that connotes wisdom and institutional trust, such as serving on the board of a popular charity.
But above all, remember that your employer is hiring your for what you can do for him, not your family, yourself or outside organizations, no matter how admirable those activities may be.

Question 18 The "Fatal Flaw" question

TRAPS: If an interviewer has read your resume carefully, he may try to zero in on a "fatal flaw" of your candidacy, perhaps that you don’t have a college degree…you’ve been out of the job market for some time…you never earned your CPA, etc.
A fatal flaw question can be deadly, but usually only if you respond by being overly defensive.
BEST ANSWERS: As every master salesperson knows, you will encounter objections (whether stated or merely thought) in every sale. They’re part and parcel of the buyer’s anxiety. The key is not to exacerbate the buyer’s anxiety but diminish it. Here’s how…
Whenever you come up against a fatal flaw question:
1. Be completely honest, open and straightforward about admitting the shortcoming. (Showing you have nothing to hide diminishes the buyer’s anxiety.)
2. Do not apologize or try to explain it away. You know that this supposed flaw is nothing to be concerned about, and this is the attitude you want your interviewer to adopt as well.
3. Add that as desirable as such a qualification might be, its lack has made you work all the harder throughout your career and has not prevented you from compiling an outstanding tack record of achievements. You might even give examples of how, through a relentless commitment to excellence, you have consistently outperformed those who do have this qualification.
Of course, the ultimate way to handle "fatal flaw" questions is to prevent them from arising in the first place. You will do that by following the master strategy described in Question 1, i.e., uncovering the employers needs and them matching your qualifications to those needs.
Once you’ve gotten the employer to start talking about his most urgently-felt wants and goals for the position, and then help him see in step-by-step fashion how perfectly your background and achievements match up with those needs, you’re going to have one very enthusiastic interviewer on your hands, one who is no longer looking for "fatal flaws".

Question 19 How do you feel about reporting to a younger person (minority, woman, etc)?

TRAPS: It’s a shame that some interviewers feel the need to ask this question, but many understand the reality that prejudices still exist among some job candidates, and it’s better to try to flush them out beforehand.
The trap here is that in today’s politically sensitized environment, even a well-intentioned answer can result in planting your foot neatly in your mouth. Avoid anything which smacks of a patronizing or an insensitive attitude, such as "I think they make terrific bosses" or "Hey, some of my best friends are…"
Of course, since almost anyone with an IQ above room temperature will at least try to steadfastly affirm the right answer here, your interviewer will be judging your sincerity most of all. "Do you really feel that way?" is what he or she will be wondering.
So you must make your answer believable and not just automatic. If the firm is wise enough to have promoted peopled on the basis of ability alone, they’re likely quite proud of it, and prefer to hire others who will wholeheartedly share their strong sense of fair play.
BEST ANSWER: You greatly admire a company that hires and promotes on merit alone and you couldn’t agree more with that philosophy. The age (gender, race, etc.) of the person you report to would certainly make no difference to you.
Whoever has that position has obviously earned it and knows their job well. Both the person and the position are fully deserving of respect. You believe that all people in a company, from the receptionist to the Chairman, work best when their abilities, efforts and feelings are respected and rewarded fairly, and that includes you. That’s the best type of work environment you can hope to find.

Question 20 On confidential matters…

TRAPS: When an interviewer presses you to reveal confidential information about a present or former employer, you may feel it’s a no-win situation. If you cooperate, you could be judged untrustworthy. If you don’t, you may irritate the interviewer and seem obstinate, uncooperative or overly suspicious.
BEST ANSWER: Your interviewer may press you for this information for two reasons.
First, many companies use interviews to research the competition. It’s a perfect set-up. Here in their own lair, is an insider from the enemy camp who can reveal prized information on the competition’s plans, research, financial condition, etc.
Second, the company may be testing your integrity to see if you can be cajoled or bullied into revealing confidential data.
What to do? The answer here is easy. Never reveal anything truly confidential about a present or former employer. By all means, explain your reticence diplomatically. For example, "I certainly want to be as open as I can about that. But I also wish to respect the rights of those who have trusted me with their most sensitive information, just as you would hope to be able to trust any of your key people when talking with a competitor…"
And certainly you can allude to your finest achievements in specific ways that don’t reveal the combination to the company safe.
But be guided by the golden rule. If you were the owner of your present company, would you feel it ethically wrong for the information to be given to your competitors? If so, steadfastly refuse to reveal it.
Remember that this question pits your desire to be cooperative against your integrity. Faced with any such choice, always choose integrity. It is a far more valuable commodity than whatever information the company may pry from you. Moreover, once you surrender the information, your stock goes down. They will surely lose respect for you.
One President we know always presses candidates unmercifully for confidential information. If he doesn’t get it, he grows visibly annoyed, relentlessly inquisitive, It’s all an act. He couldn’t care less about the information. This is his way of testing the candidate’s moral fiber. Only those who hold fast are hired.

Question 21 Would you lie for the company?

TRAPS: This another question that pits two values against one another, in this case loyalty against integrity.
BEST ANSWER: Try to avoid choosing between two values, giving a positive statement which covers all bases instead.
Example: "I would never do anything to hurt the company.."
If aggressively pressed to choose between two competing values, always choose personal integrity. It is the most prized of all values.Top

Question 22 Looking back, what would you do differently in your life?

TRAPS: This question is usually asked to uncover any life-influencing mistakes, regrets, disappointments or problems that may continue to affect your personality and performance.
You do not want to give the interviewer anything negative to remember you by, such as some great personal or career disappointment, even long ago, that you wish could have been avoided.
Nor do you wish to give any answer which may hint that your whole heart and soul will not be in your work.
BEST ANSWER: Indicate that you are a happy, fulfilled, optimistic person and that, in general, you wouldn’t change a thing.
Example: "It’s been a good life, rich in learning and experience, and the best it yet to come. Every experience in life is a lesson it its own way. I wouldn’t change a thing."

Question 23 Could you have done better in your last job?

TRAPS: This is no time for true confessions of major or even minor problems.
BEST ANSWER: Again never be negative.
Example: "I suppose with the benefit of hindsight you can always find things to do better, of course, but off the top of my head, I can’t think of anything of major consequence."
(If more explanation seems necessary)Describer a situation that didn’t suffer because of you but from external conditions beyond your control.
For example, describe the disappointment you felt with a test campaign, new product launch, merger, etc., which looked promising at first, but led to underwhelming results. "I wish we could have known at the start what we later found out (about the economy turning, the marketplace changing, etc.), but since we couldn’t, we just had to go for it. And we did learn from it…"

Question 24 Can you work under pressure?

TRAPS: An easy question, but you want to make your answer believable.
BEST ANSWER: Absolutely…(then prove it with a vivid example or two of a goal or project accomplished under severe pressure.)

Question 25 What makes you angry?

TRAPS: You don’t want to come across either as a hothead or a wimp.
BEST ANSWER: Give an answer that’s suited to both your personality and the management style of the firm. Here, the homework you’ve done about the company and its style can help in your choice of words.
Examples: If you are a reserved person and/or the corporate culture is coolly professional:
"I’m an even-tempered and positive person by nature, and I believe this helps me a great deal in keeping my department running smoothly, harmoniously and with a genuine esprit de corps. I believe in communicating clearly what’s expected, getting people’s commitment to those goals, and then following up continuously to check progress."
"If anyone or anything is going off track, I want to know about it early. If, after that kind of open communication and follow up, someone isn’t getting the job done, I’ll want to know why. If there’s no good reason, then I’ll get impatient and angry…and take appropriate steps from there. But if you hire good people, motivate them to strive for excellence and then follow up constantly, it almost never gets to that state."
If you are feisty by nature and/or the position calls for a tough straw boss.
"You know what makes me angry? People who (the fill in the blanks with the most objectionable traits for this type of position)…people who don’t pull their own weight, who are negative, people who lie…etc."

Question 26 Why aren’t you earning more money at this stage of your career?

TRAPS: You don’t want to give the impression that money is not important to you, yet you want to explain why your salary may be a little below industry standards.
BEST ANSWER: You like to make money, but other factors are even more important.
Example: "Making money is very important to me, and one reason I’m here is because I’m looking to make more. Throughout my career, what’s been even more important to me is doing work I really like to do at the kind of company I like and respect.
(Then be prepared to be specific about what your ideal position and company would be like, matching them as closely as possible to the opportunity at hand.

Question 27 Who has inspired you in your life and why?

TRAPS: The two traps here are unpreparedness and irrelevance. If you grope for an answer, it seems you’ve never been inspired. If you ramble about your high school basketball coach, you’ve wasted an opportunity to present qualities of great value to the company.
BEST ANSWER: Have a few heroes in mind, from your mental "Board of Directors" – Leaders in your industry, from history or anyone else who has been your mentor.
Be prepared to give examples of how their words, actions or teachings have helped inspire your achievements. As always, prepare an answer which highlights qualities that would be highly valuable in the position you are seeking.

Question 28 What was the toughest decision you ever had to make?

TRAPS: Giving an unprepared or irrelevant answer.
BEST ANSWER: Be prepared with a good example, explaining why the decision was difficult…the process you followed in reaching it…the courageous or effective way you carried it out…and the beneficial results.

Question 29 Tell me about the most boring job you’ve ever had.

TRAPS: You give a very memorable description of a very boring job. Result? You become associated with this boring job in the interviewer’s mind.
BEST ANSWER: You have never allowed yourself to grow bored with a job and you can’t understand it when others let themselves fall into that rut.
Example: "Perhaps I’ve been fortunate, but that I’ve never found myself bored with any job I have ever held. I’ve always enjoyed hard work. As with actors who feel there are no small parts, I also believe that in every company or department there are exciting challenges and intriguing problems crying out for energetic and enthusiastic solutions. If you’re bored, it’s probably because you’re not challenging yourself to tackle those problems right under your nose."

Question 30 Have you been absent from work more than a few days in any previous position?

TRAPS: If you’ve had a problem, you can’t lie. You could easily be found out. Yet admitting an attendance problem could raise many flags.
BEST ANSWER: If you have had no problem, emphasize your excellent and consistent attendance record throughout your career.
Also describe how important you believe such consistent attendance is for a key executive…why it’s up to you to set an example of dedication…and why there’s just no substitute for being there with your people to keep the operation running smoothly, answer questions and handle problems and crises as they arise.
If you do have a past attendance problem, you want to minimize it, making it clear that it was an exceptional circumstance and that it’s cause has been corrected.
To do this, give the same answer as above but preface it with something like, "Other that being out last year (or whenever) because of (your reason, which is now in the past), I have never had a problem and have enjoyed an excellent attendance record throughout my career. Furthermore, I believe, consistent attendance is important because…" (Pick up the rest of the answer as outlined above.).

Question 31 What changes would you make if you came on board?

TRAPS: Watch out! This question can derail your candidacy faster than a bomb on the tracks – and just as you are about to be hired.
Reason: No matter how bright you are, you cannot know the right actions to take in a position before you settle in and get to know the operation’s strengths, weaknesses key people, financial condition, methods of operation, etc. If you lunge at this temptingly baited question, you will probably be seen as someone who shoots from the hip.
Moreover, no matter how comfortable you may feel with your interviewer, you are still an outsider. No one, including your interviewer, likes to think that a know-it-all outsider is going to come in, turn the place upside down and with sweeping, grand gestures, promptly demonstrate what jerks everybody’s been for years.
BEST ANSWER: You, of course, will want to take a good hard look at everything the company is doing before making any recommendations.
Example: "Well, I wouldn’t be a very good doctor if I gave my diagnosis before the examination. Should you hire me, as I hope you will, I’d want to take a good hard look at everything you’re doing and understand why it’s being done that way. I’d like to have in-depth meetings with you and the other key people to get a deeper grasp of what you feel you’re doing right and what could be improved.
"From what you’ve told me so far, the areas of greatest concern to you are…" (name them. Then do two things. First, ask if these are in fact his major concerns. If so then reaffirm how your experience in meeting similar needs elsewhere might prove very helpful).

Question 32 I’m concerned that you don’t have as much experience as we’d like in…

TRAPS: This could be a make-or-break question. The interviewer mostly likes what he sees, but has doubts over one key area. If you can assure him on this point, the job may be yours.
BEST ANSWER: This question is related to "The Fatal Flaw" (Question 18), but here the concern is not that you are totally missing some qualifications, such as CPA certification, but rather that your experience is light in one area.
Before going into any interview, try to identify the weakest aspects of your candidacy from this company’s point of view. Then prepare the best answer you possible can to shore up your defenses.
To get past this question with flying colors, you are going to rely on your master strategy of uncovering the employer’s greatest wants and needs and then matching them with your strengths. Since you already know how to do this from Question 1, you are in a much stronger position.
More specifically, when the interviewer poses as objection like this, you should…
1. Agree on the importance of this qualification.
2. Explain that your strength may be indeed be greater than your resume indicates because…
3. When this strength is added to your other strengths, it’s really your combination of qualifications that’s most important.
Then review the areas of your greatest strengths that match up most favorably with the company’s most urgently-felt wants and needs.
This is powerful way to handle this question for two reasons. First, you’re giving your interviewer more ammunition in the area of his concern. But more importantly, you’re shifting his focus away from this one, isolated area and putting it on the unique combination of strengths you offer, strengths which tie in perfectly with his greatest wants.

Question 33 How do you feel about working nights and weekends?

TRAPS: Blurt out "no way, Jose" and you can kiss the job offer goodbye. But what if you have a family and want to work a reasonably normal schedule? Is there a way to get both the job and the schedule you want?
BEST ANSWER: First, if you’re a confirmed workaholic, this question is a softball lob. Whack it out of the park on the first swing by saying this kind of schedule is just your style. Add that your family understands it. Indeed, they’re happy for you, as they know you get your greatest satisfaction from your work.
If however, you prefer a more balanced lifestyle, answer this question with another: "What’s the norm for your best people here?"
If the hours still sound unrealistic for you, ask, "Do you have any top people who perform exceptionally for you, but who also have families and like to get home in time to see them at night?" Chances are this company does, and this associates you with this other "top-performers-who-leave-not-later-than-six" group.
Depending on the answer, be honest about how you would fit into the picture. If all those extra hours make you uncomfortable, say so, but phrase your response positively.
Example: "I love my work and do it exceptionally well. I think the results speak for themselves, especially in …(mention your two or three qualifications of greater interest to the employer. Remember, this is what he wants most, not a workaholic with weak credentials). Not only would I bring these qualities, but I’ve built my whole career on working not just hard, but smart. I think you’ll find me one of the most productive people here.
I do have a family who likes to see me after work and on weekends. They add balance and richness to my life, which in turn helps me be happy and productive at work. If I could handle some of the extra work at home in the evenings or on weekends, that would be ideal. You’d be getting a person of exceptional productivity who meets your needs with strong credentials. And I’d be able to handle some of the heavy workload at home where I can be under the same roof as my family. Everybody would win."

Question 34 Are you willing to relocate or travel?

TRAPS: Answer with a flat "no" and you may slam the door shut on this opportunity. But what if you’d really prefer not to relocate or travel, yet wouldn’t want to lose the job offer over it?
BEST ANSWER: First find out where you may have to relocate and how much travel may be involved. Then respond to the question.
If there’s no problem, say so enthusiastically.
If you do have a reservation, there are two schools of thought on how to handle it.
One advises you to keep your options open and your reservations to yourself in the early going, by saying, "no problem". You strategy here is to get the best offer you can, then make a judgment whether it’s worth it to you to relocate or travel.
Also, by the time the offer comes through, you may have other offers and can make a more informed decision. Why kill of this opportunity before it has chance to blossom into something really special? And if you’re a little more desperate three months from now, you might wish you hadn’t slammed the door on relocating or traveling.
The second way to handle this question is to voice a reservation, but assert that you’d be open to relocating (or traveling) for the right opportunity.
The answering strategy you choose depends on how eager you are for the job. If you want to take no chances, choose the first approach.
If you want to play a little harder-to-get in hopes of generating a more enticing offer, choose the second.

Question 35 Do you have the stomach to fire people? Have you had experience firing many people?

TRAPS: This "innocent" question could be a trap door which sends you down a chute and lands you in a heap of dust outside the front door. Why? Because its real intent is not just to see if you’ve got the stomach to fire, but also to uncover poor judgment in hiring which has caused you to fire so many. Also, if you fire so often, you could be a tyrant.
So don’t rise to the bait by boasting how many you’ve fired, unless you’ve prepared to explain why it was beyond your control, and not the result of your poor hiring procedures or foul temperament.
BEST ANSWER: Describe the rational and sensible management process you follow in both hiring and firing.
Example: "My whole management approach is to hire the best people I can find, train them thoroughly and well, get them excited and proud to be part of our team, and then work with them to achieve our goals together. If you do all of that right, especially hiring the right people, I’ve found you don’t have to fire very often.
"So with me, firing is a last resort. But when it’s got to be done, it’s got to be done, and the faster and cleaner, the better. A poor employee can wreak terrible damage in undermining the morale of an entire team of good people. When there’s no other way, I’ve found it’s better for all concerned to act decisively in getting rid of offenders who won’t change their ways."

Question 36 Why have you had so many jobs?

TRAPS: Your interviewer fears you may leave this position quickly, as you have others. He’s concerned you may be unstable, or a "problem person" who can’t get along with others.
BEST ANSWER: First, before you even get to the interview stage, you should try to minimize your image as job hopper. If there are several entries on your resume of less than one year, consider eliminating the less important ones. Perhaps you can specify the time you spent at previous positions in rounded years not in months and years.
Example: Instead of showing three positions this way:
6/1982 – 3/1983, Position A;4/1983 – 12/1983, Position B;1/1984 – 8/1987, Position C;
…it would be better to show simply:
1982 – 1983, Position A;1984 – 1987 Position C.
In other words, you would drop Position B altogether. Notice what a difference this makes in reducing your image as a job hopper.
Once in front of the interviewer and this question comes up, you must try to reassure him. Describe each position as part of an overall pattern of growth and career destination.
Be careful not to blame other people for your frequent changes. But you can and should attribute certain changes to conditions beyond your control.
Example: Thanks to an upcoming merger, you wanted to avoid an ensuing bloodbath, so you made a good, upward career move before your department came under the axe of the new owners.
If possible, also show that your job changes were more frequent in your younger days, while you were establishing yourself, rounding out your skills and looking for the right career path. At this stage in your career, you’re certainly much more interested in the best long-term opportunity.
You might also cite the job(s) where you stayed the longest and describe that this type of situation is what you’re looking for now.

Question 37 What do you see as the proper role/mission of……a good (job title you’re seeking);…a good manager;…
an executive in serving the community;…a leading company in our industry; etc.

TRAPS: These and other "proper role" questions are designed to test your understanding of your place in the bigger picture of your department, company, community and profession….as well as the proper role each of these entities should play in its bigger picture.
The question is most frequently asked by the most thoughtful individuals and companies…or by those concerned that you’re coming from a place with a radically different corporate culture (such as from a big government bureaucracy to an aggressive small company).
The most frequent mistake executives make in answering is simply not being prepared (seeming as if they’ve never giving any of this a though.)…or in phrasing an answer best suited to their prior organization’s culture instead of the hiring company’s.Top
BEST ANSWER: Think of the most essential ingredients of success for each category above – your job title, your role as manager, your firm’s role, etc.
Identify at least three but no more than six qualities you feel are most important to success in each role. Then commit your response to memory.
Here, again, the more information you’ve already drawn out about the greatest wants and needs of the interviewer, and the more homework you’ve done to identify the culture of the firm, the more on-target your answer will be.

Question 38 What would you say to your boss if he’s crazy about an idea, but you think it stinks?

TRAPS: This is another question that pits two values, in this case loyalty and honesty, against one another.
BEST ANSWER: Remember the rule stated earlier: In any conflict between values, always choose integrity.
Example: I believe that when evaluating anything, it’s important to emphasize the positive. What do I like about this idea?"
"Then, if you have reservations, I certainly want to point them out, as specifically, objectively and factually as I can."
"After all, the most important thing I owe my boss is honesty. If he can’t count on me for that, then everything else I may do or say could be questionable in his eyes."
"But I also want to express my thoughts in a constructive way. So my goal in this case would be to see if my boss and I could make his idea even stronger and more appealing, so that it effectively overcomes any initial reservation I or others may have about it."
"Of course, if he overrules me and says, ‘no, let’s do it my way,’ then I owe him my full and enthusiastic support to make it work as best it can."

Question 39 How could you have improved your career progress?

TRAPS: This is another variation on the question, "If you could, how would you live your life over?" Remember, you’re not going to fall for any such invitations to rewrite person history. You can’t win if you do.
BEST ANSWER: You’re generally quite happy with your career progress. Maybe, if you had known something earlier in life (impossible to know at the time, such as the booming growth in a branch in your industry…or the corporate downsizing that would phase out your last job), you might have moved in a certain direction sooner.
But all things considered, you take responsibility for where you are, how you’ve gotten there, where you are going…and you harbor no regrets.

Question 40 What would you do if a fellow executive on your own corporate level wasn’t pulling his/her weight…and this was hurting your department?

TRAPS: This question and other hypothetical ones test your sense of human relations and how you might handle office politics.
BEST ANSWER: Try to gauge the political style of the firm and be guided accordingly. In general, fall back on universal principles of effective human relations – which in the end, embody the way you would like to be treated in a similar circumstance.
Example: "Good human relations would call for me to go directly to the person and explain the situation, to try to enlist his help in a constructive, positive solution. If I sensed resistance, I would be as persuasive as I know how to explain the benefits we can all gain from working together, and the problems we, the company and our customers will experience if we don’t."Top
POSSIBLE FOLLOW-UP QUESTION: And what would you do if he still did not change his ways?
ANSWER: "One thing I wouldn’t do is let the problem slide, because it would only get worse and overlooking it would set a bad precedent. I would try again and again and again, in whatever way I could, to solve the problem, involving wider and wider circles of people, both above and below the offending executive and including my own boss if necessary, so that everyone involved can see the rewards for teamwork and the drawbacks of non-cooperation."
"I might add that I’ve never yet come across a situation that couldn’t be resolved by harnessing others in a determined, constructive effort."

Question 41 You’ve been with your firm a long time. Won’t it be hard switching to a new company?

TRAPS: Your interviewer is worried that this old dog will find it hard to learn new tricks.
BEST ANSWER: To overcome this objection, you must point to the many ways you have grown and adapted to changing conditions at your present firm. It has not been a static situation. Highlight the different responsibilities you’ve held, the wide array of new situations you’ve faced and conquered.
As a result, you’ve learned to adapt quickly to whatever is thrown at you, and you thrive on the stimulation of new challenges.
To further assure the interviewer, describe the similarities between the new position and your prior one. Explain that you should be quite comfortable working there, since their needs and your skills make a perfect match.

Question 42 May I contact your present employer for a reference?

TRAPS: If you’re trying to keep your job search private, this is the last thing you want. But if you don’t cooperate, won’t you seem as if you’re trying to hide something?
BEST ANSWER: Express your concern that you’d like to keep your job search private, but that in time, it will be perfectly okay.
Example: "My present employer is not aware of my job search and, for obvious reasons; I’d prefer to keep it that way. I’d be most appreciative if we kept our discussion confidential right now. Of course, when we both agree the time is right, then by all means you should contact them. I’m very proud of my record there.

Question 43 Give me an example of your creativity (analytical skill…managing ability, etc.)

TRAPS: The worst offense here is simply being unprepared. Your hesitation may seem as if you’re having a hard time remembering the last time you were creative, analytical, etc.
BEST ANSWER: Remember from Question 2 that you should commit to memory a list of your greatest and most recent achievements, ever ready on the tip of your tongue.
If you have such a list, it’s easy to present any of your achievements in light of the quality the interviewer is asking about. For example, the smashing success you orchestrated at last year’s trade show could be used as an example of creativity, or analytical ability, or your ability to manage.

Question 44 Where could you use some improvement?

TRAPS: Another tricky way to get you to admit weaknesses. Don’t fall for it.
BEST ANSWER: Keep this answer, like all your answers, positive. A good way to answer this question is to identify a cutting-edge branch of your profession (one that’s not essential to your employer’s needs) as an area you’re very excited about and want to explore more fully over the next six months.

Question 45 What do you worry about?

TRAPS: Admit to worrying and you could sound like a loser. Saying you never worry doesn’t sound credible.
BEST ANSWER: Redefine the word ‘worry’ so that it does not reflect negatively on you.
Example: "I wouldn’t call it worry, but I am a strongly goal-oriented person. So I keep turning over in my mind anything that seems to be keeping me from achieving those goals, until I find a solution. That’s part of my tenacity, I suppose."

Question 46 How many hours a week do you normally work?

TRAPS: You don’t want to give a specific number. Make it to low, and you may not measure up. Too high, and you’ll forever feel guilty about sneaking out the door at 5:15.
BEST ANSWER: If you are in fact a workaholic and you sense this company would like that: Say you are a confirmed workaholic, that you often work nights and weekends. Your family accepts this because it makes you fulfilled.
If you are not a workaholic: Say you have always worked hard and put in long hours. It goes with the territory. It one sense, it’s hard to keep track of the hours because your work is a labor of love, you enjoy nothing more than solving problems. So you’re almost always thinking about your work, including times when you’re home, while shaving in the morning, while commuting, etc.

Question 47 What’s the most difficult part of being a (job title)?

TRAPS: Unless you phrase your answer properly, your interviewer may conclude that whatever you identify as "difficult" is where you are weak.
BEST ANSWER: First, redefine "difficult" to be "challenging" which is more positive. Then, identify an area everyone in your profession considers challenging and in which you excel. Describe the process you follow that enables you to get splendid results…and be specific about those results.
Example: "I think every sales manager finds it challenging to motivate the troops in a recession. But that’s probably the strongest test of a top sales manager. I feel this is one area where I excel."
"When I see the first sign that sales may slip or that sales force motivation is flagging because of a downturn in the economy, here’s the plan I put into action immediately…" (followed by a description of each step in the process…and most importantly, the exceptional results you’ve achieved.).

Question 48 The "Hypothetical Problem"

TRAPS: Sometimes an interviewer will describe a difficult situation and ask, "How would you handle this?" Since it is virtually impossible to have all the facts in front of you from such a short presentation, don’t fall into the trap of trying to solve this problem and giving your verdict on the spot. It will make your decision-making process seem woefully inadequate.
BEST ANSWER: Instead, describe the rational, methodical process you would follow in analyzing this problem, who you would consult with, generating possible solutions, choosing the best course of action, and monitoring the results.
Remember, in all such, "What would you do?" questions, always describe your process or working methods, and you’ll never go wrong.

Question 49 What was the toughest challenge you’ve ever faced?

TRAPS: Being unprepared or citing an example from so early in your life that it doesn’t score many points for you at this stage of your career.
BEST ANSWER: This is an easy question if you’re prepared. Have a recent example ready that demonstrates either:
1. A quality most important to the job at hand; or
2. A quality that is always in demand, such as leadership, initiative, managerial skill, persuasiveness, courage, persistence, intelligence, etc.

Question 50 Have you consider starting your own business?

TRAPS: If you say "yes" and elaborate enthusiastically, you could be perceived as a loose cannon in a larger company, too entrepreneurial to make a good team player…or someone who had to settle for the corporate life because you couldn’t make a go of your own business.
Also too much enthusiasm in answering "yes" could rouse the paranoia of a small company indicating that you may plan to go out on your own soon, perhaps taking some key accounts or trade secrets with you.
On the other hand, if you answer "no, never" you could be perceived as a security-minded drone who never dreamed a big dream.Top
BEST ANSWER: Again it’s best to:
1. Gauge this company’s corporate culture before answering and…
2. Be honest (which doesn’t mean you have to vividly share your fantasy of the franchise or bed-and-breakfast you someday plan to open).
In general, if the corporate culture is that of a large, formal, military-style structure, minimize any indication that you’d love to have your own business. You might say, "Oh, I may have given it a thought once or twice, but my whole career has been in larger organizations. That’s where I have excelled and where I want to be."
If the corporate culture is closer to the free-wheeling, everybody’s-a-deal-maker variety, then emphasize that in a firm like this, you can virtually get the best of all worlds, the excitement of seeing your own ideas and plans take shape…combined with the resources and stability of a well-established organization. Sounds like the perfect environment to you.
In any case, no matter what the corporate culture, be sure to indicate that any desires about running your own show are part of your past, not your present or future.
The last thing you want to project is an image of either a dreamer who failed and is now settling for the corporate cocoon…or the restless maverick who will fly out the door with key accounts, contacts and trade secrets under his arms just as soon as his bankroll has gotten rebuilt.
Always remember: Match what you want with what the position offers. The more information you’ve uncovered about the position, the more believable you can make your case.

Question 51 What are your goals?

TRAPS: Not having any…or having only vague generalities, not highly specific goals.
BEST ANSWER: Many executives in a position to hire you are strong believers in goal-setting. (It’s one of the reason they’ve achieved so much). They like to hire in kind.
If you’re vague about your career and personal goals, it could be a big turnoff to may people you will encounter in your job search.
Be ready to discuss your goals for each major area of your life: career, personal development and learning, family, physical (health), community service and (if your interviewer is clearly a religious person) you could briefly and generally allude to your spiritual goals (showing you are a well-rounded individual with your values in the right order).
Be prepared to describe each goal in terms of specific milestones you wish to accomplish along the way, time periods you’re allotting for accomplishment, why the goal is important to you, and the specific steps you’re taking to bring it about. But do this concisely, as you never want to talk more than two minutes straight before letting your interviewer back into the conversation.

Question 52 What do you for when you hire people?

TRAPS: Being unprepared for the question.
BEST ANSWER: Speak your own thoughts here, but for the best answer weave them around the three most important qualifications for any position.
1. Can the person do the work (qualifications)?
2. Will the person do the work (motivation)?
3. Will the person fit in ("our kind of team player")?

Question 53 Sell me this stapler…(this pencil…this clock…or some other object on interviewer’s desk).

TRAPS: Some interviewers, especially business owners and hard-changing executives in marketing-driven companies, feel that good salesmanship is essential for any key position and ask for an instant demonstration of your skill. Be ready.
BEST ANSWER: Of course, you already know the most important secret of all great salesmanship – "find out what people want, then show them how to get it."
If your interviewer picks up his stapler and asks, "sell this to me," you are going to demonstrate this proven master principle. Here’s how:
"Well, a good salesman must know both his product and his prospect before he sells anything. If I were selling this, I’d first get to know everything I could about it, all its features and benefits."
"Then, if my goal were to sell it you, I would do some research on how you might use a fine stapler like this. The best way to do that is by asking some questions. May I ask you a few questions?"
Then ask a few questions such as, "Just out of curiosity, if you didn’t already have a stapler like this, why would you want one? And in addition to that? Any other reason? Anything else?"
"And would you want such a stapler to be reliable?...Hold a good supply of staples?" (Ask more questions that point to the features this stapler has.)
Once you’ve asked these questions, make your presentation citing all the features and benefits of this stapler and why it’s exactly what the interviewer just told you he’s looking for.
Then close with, "Just out of curiosity, what would you consider a reasonable price for a quality stapler like this…a stapler you could have right now and would (then repeat all the problems the stapler would solve for him)? Whatever he says, (unless it’s zero), say, "Okay, we’ve got a deal."
NOTE: If your interviewer tests you by fighting every step of the way, denying that he even wants such an item, don’t fight him. Take the product away from him by saying, "Mr. Prospect, I’m delighted you’ve told me right upfront that there’s no way you’d ever want this stapler. As you well know, the first rule of the most productive salespeople in any field is to meet the needs of people who really need and want our products, and it just wastes everyone’s time if we try to force it on those who don’t. And I certainly wouldn’t want to waste your time. But we sell many items. Is there any product on this desk you would very much like to own…just one item?" When he points something out, repeat the process above. If he knows anything about selling, he may give you a standing ovation.

Question 54 "The Salary Question" – How much money do you want?

TRAPS: May also be phrases as, "What salary are you worth?"…or, "How much are you making now?" This is your most important negotiation. Handle it wrong and you can blow the job offer or go to work at far less than you might have gotten.
BEST ANSWER: For maximum salary negotiating power, remember these five guidelines:
1. Never bring up salary. Let the interviewer do it first. Good salespeople sell their products thoroughly before talking price. So should you. Make the interviewer want you first, and your bargaining position will be much stronger.
2. If your interviewer raises the salary question too early, before you’ve had a chance to create desire for your qualifications, postpone the question, saying something like, "Money is important to me, but is not my main concern. Opportunity and growth are far more important. What I’d rather do, if you don’t mind, is explore if I’m right for the position, and then talk about money. Would that be okay?"
3. The #1 rule of any negotiation is: the side with more information wins. After you’ve done a thorough job of selling the interviewer and it’s time to talk salary, the secret is to get the employer talking about what he’s willing to pay before you reveal what you’re willing to accept. So, when asked about salary, respond by asking, "I’m sure the company has already established a salary range for this position. Could you tell me what that is?" Or, "I want an income commensurate with my ability and qualifications. I trust you’ll be fair with me. What does the position pay?" Or, more simply, "What does this position pay?"
4. Know beforehand what you’d accept. To know what’s reasonable, research the job market and this position for any relevant salary information. Remember that most executives look for a 20-25%$ pay boost when they switch jobs. If you’re grossly underpaid, you may want more.
5. Never lie about what you currently make, but feel free to include the estimated cost of all your fringes, which could well tack on 25-50% more to your present "cash-only" salary.

Question 55 The Illegal Question

TRAPS: Illegal questions include any regarding your age…number and ages of your children or other dependents…marital status…maiden name…religion…political affiliation…ancestry…national origin…birthplace…naturalization of your parents, spouse or children…diseases…disabilities…clubs…or spouse’s occupation…unless any of the above are directly related to your performance of the job. You can’t even be asked about arrests, though you can be asked about convictions.
BEST ANSWER: Under the ever-present threat of lawsuits, most interviewers are well aware of these taboos. Yet you may encounter, usually on a second or third interview, a senior executive who doesn’t interview much and forgets he can’t ask such questions.
You can handle an illegal question in several ways. First, you can assert your legal right not to answer. But this will frighten or embarrass your interviewer and destroy any rapport you had.
Second, you could swallow your concerns over privacy and answer the question straight forwardly if you feel the answer could help you. For example, your interviewer, a devout Baptist, recognizes you from church and mentions it. Here, you could gain by talking about your church.
Third, if you don’t want your privacy invaded, you can diplomatically answer the concern behind the question without answering the question itself.
Example: If you are over 50 and are asked, "How old are you?" you can answer with a friendly, smiling question of your own on whether there’s a concern that your age my affect your performance. Follow this up by reassuring the interviewer that there’s nothing in this job you can’t do and, in fact, your age and experience are the most important advantages you offer the employer for the following reasons…
Another example: If asked, "Do you plan to have children?" you could answer, "I am wholeheartedly dedicated to my career", perhaps adding, "I have no plans regarding children." (You needn’t fear you’ve pledged eternal childlessness. You have every right to change your plans later. Get the job first and then enjoy all your options.)
Most importantly, remember that illegal questions arise from fear that you won’t perform well. The best answer of all is to get the job and perform brilliantly. All concerns and fears will then varnish, replaced by respect and appreciation for your work.

Question 56 The "Secret" Illegal Question

TRAPS: Much more frequent than the Illegal question (see Question 55) is the secret illegal question. It’s secret because it’s asked only in the interviewer’s mind. Since it’s not even expressed to you, you have no way to respond to it, and it can there be most damaging.
Example: You’re physically challenged, or a single mother returning to your professional career, or over 50, or a member of an ethnic minority, or fit any of a dozen other categories that do not strictly conform to the majority in a given company.
Your interviewer wonders, "Is this person really able to handle the job?"…"Is he or she a ‘good fit’ at a place like ours?"…"Will the chemistry ever be right with someone like this?" But the interviewer never raises such questions because they’re illegal. So what can you do?
BEST ANSWER: Remember that just because the interviewer doesn’t ask an illegal question doesn’t mean he doesn’t have it. More than likely, he is going to come up with his own answer. So you might as well help him out.
How? Well, you obviously can’t respond to an illegal question if he hasn’t even asked. This may well offend him. And there’s always the chance he wasn’t even concerned about the issue until you brought it up, and only then begins to wonder.
So you can’t address "secret" illegal questions head-on. But what you can do is make sure there’s enough counterbalancing information to more than reassure him that there’s no problem in the area he may be doubtful about.
For example, let’s say you’re a sales rep who had polio as a child and you need a cane to walk. You know your condition has never impeded your performance, yet you’re concerned that your interviewer may secretly be wondering about your stamina or ability to travel. Well, make sure that you hit these abilities very hard, leaving no doubt about your capacity to handle them well.
So, too, if you’re in any different from what passes for "normal". Make sure, without in any way seeming defensive about yourself that you mention strengths, accomplishments, preferences and affiliations that strongly counterbalance any unspoken concern your interviewer may have.

Question 57 What was the toughest part of your last job?

TRAPS: This is slightly different from the question raised earlier, "What’s the most difficult part of being a (job title…)" because this asks what you personally have found most difficult in your last position. This question is more difficult to redefine into something positive. Your interviewer will assume that whatever you found toughest may give you a problem in your new position.
BEST ANSWER: State that there was nothing in your prior position that you found overly difficult, and let your answer go at that. If pressed to expand your answer, you could describe the aspects of the position you enjoyed more than others, making sure that you express maximum enjoyment for those tasks most important to the open position, and you enjoyed least those tasks that are unimportant to the position at hand.

Question 58 How do you define success…and how do you measure up to your own definition?

TRAPS: Seems like an obvious enough question. Yet many executives, unprepared for it, fumble the ball.
BEST ANSWER: Give a well-accepted definition of success that leads right into your own stellar collection of achievements.
Example: "The best definition I’ve come across is that success is the progressive realization of a worthy goal."
"As to how I would measure up to that definition, I would consider myself both successful and fortunate…"(Then summarize your career goals and how your achievements have indeed represented a progressive path toward realization of your goals.)

Question 59 "The Opinion Question" – What do you think about …Abortion…The President…The Death Penalty…(or any other controversial subject)?

TRAPS: Obviously, these and other "opinion" questions should never be asked. Sometimes they come up over a combination dinner/interview when the interviewer has had a drink or two, is feeling relaxed, and is spouting off about something that bugged him in today’s news. If you give your opinion and it’s the opposite of his, you won’t change his opinions, but you could easily lose the job offer.
BEST ANSWER: In all of these instances, just remember the tale about student and the wise old rabbi. The scene is a seminary, where an overly serious student is pressing the rabbi to answer the ultimate questions of suffering, life and death. But no matter how hard he presses, the wise old rabbi will only answer each difficult question with a question of his own.
In exasperation, the seminary student demands, "Why, rabbi, do you always answer a question with another question?" To which the rabbi responds, "And why not?"
If you are ever uncomfortable with any question, asking a question in return is the greatest escape hatch ever invented. It throws the onus back on the other person, sidetracks the discussion from going into an area of risk to you, and gives you time to think of your answer or, even better, your next question!
In response to any of the "opinion" questions cited above, merely responding, "Why do you ask?" will usually be enough to dissipate any pressure to give your opinion. But if your interviewer again presses you for an opinion, you can ask another question.
Or you could assert a generality that almost everyone would agree with. For example, if your interviewer is complaining about politicians then suddenly turns to you and asks if you’re a Republican or Democrat, you could respond by saying, "Actually, I’m finding it hard to find any politicians I like these days."
(Of course, your best question of all may be whether you want to work for someone opinionated.)

Question 60 If you won $10 million lottery, would you still work?

TRAPS: Your totally honest response might be, "Hell, no, are you serious?" That might be so, but any answer which shows you as fleeing work if given the chance could make you seem lazy. On the other hand, if you answer, "Oh, I’d want to keep doing exactly what I am doing, only doing it for your firm," you could easily inspire your interviewer to silently mutter to himself, "Yeah, sure. Gimme a break."
BEST ANSWER: This type of question is aimed at getting at your bedrock attitude about work and how you feel about what you do. Your best answer will focus on your positive feelings.
Example: "After I floated down from cloud nine, I think I would still hold my basic belief that achievement and purposeful work are essential to a happy, productive life. After all, if money alone bought happiness, then all rich people would be all happy, and that’s not true.
"I love the work I do, and I think I’d always want to be involved in my career in some fashion. Winning the lottery would make it more fun because it would mean having more flexibility, more options...who knows?"
"Of course, since I can’t count on winning, I’d just as soon create my own destiny by sticking with what’s worked for me, meaning good old reliable hard work and a desire to achieve. I think those qualities have built many more fortunes that all the lotteries put together."

Question 61 Looking back on your last position, have you done your best work?

TRAPS: Tricky question. Answer "absolutely" and it can seem like your best work is behind you. Answer, "no, my best work is ahead of me," and it can seem as if you didn’t give it your all.
BEST ANSWER: To cover both possible paths this question can take, your answer should state that you always try to do your best, and the best of your career is right now. Like an athlete at the top of his game, you are just hitting your career stride thanks to several factors. Then, recap those factors, highlighting your strongest qualifications.

Question 62 Why should I hire you from the outside when I could promote someone from within?

TRAPS: This question isn’t as aggressive as it sounds. It represents the interviewer’s own dilemma over this common problem. He’s probably leaning toward you already and for reassurance, wants to hear what you have to say on the matter.
BEST ANSWER: Help him see the qualifications that only you can offer.
Example: "In general, I think it’s a good policy to hire from within – to look outside probably means you’re not completely comfortable choosing someone from inside.
"Naturally, you want this department to be as strong as it possibly can be, so you want the strongest candidate. I feel that I can fill that bill because…(then recap your strongest qualifications that match up with his greatest needs)."

Question 63 Tell me something negative you’ve heard about our company…

TRAPS: This is a common fishing expedition to see what the industry grapevine may be saying about the company. But it’s also a trap because as an outsider, you never want to be the bearer of unflattering news or gossip about the firm. It can only hurt your chances and sidetrack the interviewer from getting sold on you.
BEST ANSWER: Just remember the rule – never be negative – and you’ll handle this one just fine.

Question 64 On a scale of one to ten, rate me as an interviewer.

TRAPS: Give a perfect "10," and you’ll seem too easy to please. Give anything less than a perfect 10, and he could press you as to where you’re being critical, and that road leads downhill for you.
BEST ANSWER: Once again, never be negative. The interviewer will only resent criticism coming from you. This is the time to show your positivism.
However, don’t give a numerical rating. Simply praise whatever interview style he’s been using.
If he’s been tough, say "You have been thorough and tough-minded, the very qualities needed to conduct a good interview."
If he’s been methodical, say, "You have been very methodical and analytical, and I’m sure that approach results in excellent hires for your firm."
In other words, pay him a sincere compliment that he can believe because it’s anchored in the behavior you’ve just seen.