Interview Questions

Innovation is generally considered a process that brings together various novel ideas in a way that they have an impact on society. It differs from invention in that innovation refers to the use of a better and, as a result, novel idea or method, whereas invention refers more directly to the creation of the idea or method itself. Innovation differs from improvement in that innovation refers to the notion of doing something different rather than doing the same thing better.

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database. The trigger is mostly used for maintaining the integrity of the information on the database.

Syntax:

CREATE OR REPLACE TRIGGER [Trigger Name] [Before / After / Instead Of]

ON [schema].[table]

<PL/SQL subprogram>

Types of PL/SQL triggers : 

> Row trigger          - The trigger fires for each ROW affected.

> Statement trigger - The trigger is fired once when the condition is matched

> Before and After trigger - The BEFORE trigger run the trigger action before the insert, update or delete statement. The AFTER trigger runs the trigger action after the insert, update or delete statement is executes.

Instance is an object not an attribute

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

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?"

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.

$_SERVER and $_ENV arrays contain different information. The information depends on the server and operating system being used. Most of the information can be seen of an array for a particular server and operating system. The syntax is as follows:

foreach($_SERVER as $key =>$value)

{ echo “Key=$key, Value=$value\n”; }

The interest-rate effect suggests that an increase in the price level will increase the demand for money, increase interest rates, and decrease consumption and investment spending.