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.

CONSTRUCTOR : PHP allows developers to declare constructor methods for classes. Classes which have a constructor method call this method on each newly-created object, so it is suitable for any initialization that the object may need before it is used.

DESTRUCTORS : PHP 5 introduces a destructor concept similar to that of other object-oriented languages, such as C++. The destructor method will be called as soon as all references to a particular object are removed or when the object is explicitly destroyed or in any order in shutdown sequence.

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. 

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.

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.

A default constructor is a constructor that either has no parameters, or if it has parameters, all the parameters have default values.

In single virtual machine,JVM passes arguments only by value.