Interview Questions

We can tune the report by using index awarness in universe

The difference lies with the execution of the languages. PHP is server side scripting language, which means that it can’t interact directly with the user. Whereas, JavaScript is client side scripting language, that is used to interact directly with the user.

1. A fixed budget is established for a specific level of activity whereas flexible budget is prepared for various levels of activity.

2. Fixed budget cannot be changed after the period commences, whereas a flexible budget can be changed after the period commence.

3. Fixed budget is more suitable for fixed expenses whereas flexible budget takes both fixed as well as variable expenses in account.

4. Fixed budget includes only fixed costs, whereas a flexible budget includes fixed costs, variable costs and semi variable costs.

5. Fixed budget is mainly used in planning stage whereas flexible budget is used in controlling stage.

GROUP BY partitions the selected rows on the distinct values of the column on which you group by. HAVING selects GROUPs which match the criteria specified

ADO or Active X Data objects, allows developers to create applications that can interoperate well with other data application services.

- 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 non clustered 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 non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

What are your weaknesses?

This is a very common interview question for many jobs across industries. Most people feel Answering strengths is easy but weaknesses is difficult. If approached the right way this question will give you chance to build trust. You have 3 options/approaches to answer this question. 

1. Deny having any weaknesses. This approach is least common and surely not the way to go.

2. Spin a Weakness into a strength. Like, "I'm a perfectionist" or "I care too much"

Note - This is very common approach and some interviewers think you are not being honest. 

3. Give an honest answer (Recommended). Answer the question honestly without shooting yourself in the foot. 

E.g. My weakness is public speaking, I am working on it. Ofcourse make sure this is not the primary requirement of the job.