Interview Questions

Inheritance is the ability to create new classes based on existing classes. It is useful to reuse existing code.

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.

Example:

"I have several awesome  achievements in my career. Probably the most awesome achievements were the delivery of the most recent version replace update to one of our core products for customer bills. This was a 1-year project and I was one of 9 team members. What made it more for me was that my role expanded from being one of the tech team individuals to taking the lead on building the mobile makings of the product. In order to deliver this aspect of the product, I pulled in 3 new project resources with new specific skills in each of the mobile technology floors we targeted and cross-trained all project resources to support each floor. In the last, our team delivered the product on time and have received numerous accolades, both external and internal. The mobile component was particularly  identified to be world class and distributed the product at its release. Our CEO spent time showing the mobile components to the industry and press and it has since met with superb  reviews. Would you like to see the Android version of the product?"

Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted.

The function setcookie() is used to define a cookie that is to be sent along with HTTP headers. The cookie must be sent prior to any output from the script as is the protocol restriction. After setting the cookies, they can be used when the next page is loaded by using $_COOKIE or $HTTP_COOKIE_VARS arrays.

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.

Primary key : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.

Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table.