Interview Questions

Why Are You Looking For A New Job?

Purpose - This question is asked to get some insights into your personality and your relationship with your last job, colleagues and employer. So you should be careful while answering this question.

1. Never bad-mouth your former employers.
Why? It is very simple as the interviewer will envision that you will bad-mouth them when you decide to leave, and nobody wants bad rumors about themselves or their company.

2. Never bad-mouth your previous co-workers.
Why? This world is too small, your co-workers could be a friend, relative of the interviewer.

3. Never bad-mouth about the responsibilities and tasks you performed at your previous job.
Why? Thinking that the new employer would give you great responsibilities and tasks and if you give a hate speech on the previous job responsibilities and activities and to your surprise if your interviewer is thinking about similar tasks for this position, you have already given a reason to quit the new job which you have not yet got. So guess, the chances of you getting the job is Nil.

Keep the answer short and try not to disclose too much. A straight answer is best and as stated above avoid negative statements about yourself, your work, or your ability to get along with others.

E.g.
My organization was forced to downsize.

Our department was eliminated due to corporate restructuring.

I am looking for a bigger challenge and to grow my career.

I am relocating to this area due to family ( Marriage, Kids Education etc...)

I received degree and want to utilize my new skills in this new position.

I am interested in a job with more responsibility and challenges.

I am seeking a position with a stable company with room for growth and opportunity for advancement.

Catalog views return information that is used by the SQL Server Database Engine. Catalog Views are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. All user- available catalog metadata is exposed through catalog views.

Debenture holder are those who provides long term loan at specific interest rate in term of cash and creditor provides only short term credit in term of cash for purchasing of goods.

IUnknown as an interface of a COM object. Every COM object has to support IUnknown, besides optionally adding other interfaces.

IUnknown is made of QueryInterface, AddRef and Release.

It refers to the possibility for an investor to experience  losses due to  factors that affect the overall performance of the financial markets. Market risk cannot be eliminated through diversification, though it can be hedged against. The sources of market risk include natural disasters, recessions, political turmoil, changes in interest rates and terrorist attacks.

Some of the rules which should be followed while naming a variable in VB are as follows: 

1) Characters should be less than 255.

2) Space between characters should be allowed.

3) A variable should begin with a number.

4) Period may not be permitted.

Star schema: A highly de-normalized technique. A star schema has one fact table and is associated with numerous dimensions table and depicts a star.

Snow flake schema: The normalized principles applied star schema is known as Snow flake schema. Every dimension table is associated with sub dimension table.

Differences:

- A dimension table will not have parent table in star schema, whereas snow flake schemas have one or more parent tables.

- The dimensional table itself consists of hierarchies of dimensions in star schema, where as hierarchies are split into different tables in snow flake schema. The drilling down data from top most hierarchies to the lowermost hierarchies can be done.

setcookie('variable','value','time');
variable - name of the cookie variable
value     - value of the cookie variable
time       - expiry time

Example:
<?php
setcookie('Test',$i,time()+3600);
?>
Test - cookie variable name
$i - value of the variable 'Test'
time()+3600 - denotes that the cookie will expire after an one hour