Interview Questions

It is the folder that contains web applications. The folder that has been published as virtual folder by IIS can only contain web applications

Following are the benefits of data integration:

- Makes reporting, monitoring, placing customer information across the enterprise flexible and convenient.

- Data usage is efficient.

- Cost Effective.

- Risk adjusted profitability management as it allows accurate data extraction.

- Allows timely and reliable reporting, as data quality is the prime technology for business challenges.

Super global arrays are the built in arrays that can be used anywhere. They are also called as auto-global as they can be used inside a function as well. The arrays with the longs names such as $HTTP_SERVER_VARS, must be made global before they can be used in an array. This $HTTP_SERVER_VARS check your php.ini setting for long arrays.

As a manager, the tough decisions I make involve layoffs. Before making those hard decisions, I always think particularly about what is best for my employees and the business. While I do not relish making those kinds of decisions, I do not shy away from this part of my job. Two years ago, I had to let some employees go due to the monetary climate. This was a tough decision that was ultimately necessary for the good of the organization and everyone working for the company.

When an object is passed by value, this means that a copy of the object is passed. Thus, even if changes are made to that object, it doesn’t affect the original value. 

When an object is passed by reference, this means that the actual object is not passed, rather a reference of the object is passed. Thus, any changes made by the external method, are also reflected in all places.

An index is a object which is used to improve performance during retrieval of records.

CREATE [UNIQUE] INDEX index_name 

ON employee[emp_id, emp_name,dept_id]

[COMPUTE STATISTICS]

The UNIQUE keyword is used when combined values of the index should be unique.

The COMPUTE STATISTICS during the creation of index optimizes the plan of execution of the SQL statement and improves performance.

The INTO option moves the information in the TIOA into the reserved specified area, while the SET option simply returns the address of the TIOA to the specified BLL cell or address of a linkage-section.

Say “Yes” if you have made up your mind to work for a call center. Call centers would usually work 24 X 7 which needs some executives to be always present in the center. This means that you would need to work in shifts.