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. 

COM is the component Object Model is a system whch creates application which are binary form that is language independent , object oriented ,modular and reusable .

DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.

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.

UNION selects only distinct values whereas UNION ALL selects all values and not just distinct ones

Smart money is a term used for credit card.

A network in which there are multiple network links between computers to provide multiple paths for data to travel.