Interview Questions

Change management is the biggest challenge in each and every industry. After requirements stage when development is started client will come-up with some new changes or enhancements. 

Cross departmental or cross team management – like conflict management between teams. Also individuals. This requires soft skills and smartness. 

Communication problems – In real time this can happen. You might be good in speaking and understanding the English language. BUT sometimes it happens like Different people across the globe speak different style of English. In USA itself Mexico people speak English differently. Romans speak different English. So at initial level to understand the accent can be a challenge but after some time you will become perfect. 

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.

It is necessary to understand some of the concepts used extensively in object oriented programming.These include

Objects
Classes
Data abstraction and encapsulation
Inheritance
Polymorphism
Dynamic Binding
Message passing

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.

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

While allocating KSDS Datasets, free space is declared at regular intervals at the time of initial loading. This is done because this free space is utilized for keeping the data arranged in sequence physically, even though inserted randomly.

The job cost sheets constitute the subsidiary ledger for the Work in Process Inventory Account.

A job cost sheet is a form used to record the costs chargeable to a specific job and to determine the total and unit costs of the completed job. Companies keep a separate job cost sheet for each job.