Interview Questions

The knowledge of Joins is a MUST for every interviewee. Most SQL programmers have used inner join and  outer join[left/right]; but the catch point here is to also mention cross join and self-join.

Answer this question around the following steps :

1. Greet customer.

2. Tell your name to the customer.

3. Ask customer how you can be of any assistance to him/her.

4. Listen carefully and patiently to the customers query or requirement.

5. Provide the customer with the best solution or assistance without making him/her wait for long.

6. Inquire if customer is satisfied with the assistance or help provided.

7. Ask the customer if he needs any further assistance.

Classless Inter-Domain Routing 

The main difference lies in the motive of the two parties. The main motive of the hedger is to hedge(minimize) the risk from the occurence of some events. 

The motive of the speculator is to gamble in the market in order to make the profit by buying/selling the derivative products.

An application plan or package is generated by the bind to define an access path. 

Business facts or measures and foreign keys are persisted in fact tables which are referred as candidate keys in dimension tables. Additive values are usually provided by the fact tables which acts as independent variables by which dimensional attributes are analyzed.

Attributes that are used to constrain and group data for performing data warehousing queries are persisted in the dimension tables.

A PHP filter is used to validate and filter data coming from insecure sources.
To test, validate and filter user input or custom data is an important part of any web application.
The PHP filter extension is designed to make data filtering easier and quicker.

Overloading allows multiple functions to exist with same name but different parameters. Again if you take bike as an example, it has a function “Start” with two forms i.e. ’Auto Start’ and ’kick start’.