Interview Questions

Q:

What are the benefits of data integration?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

0 2511
Q:

What is Constructors and Destructors?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2511
Q:

What is the use of super-global arrays in PHP?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2510
Q:

My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?

Answer

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


 

Report Error

View answer Workspace Report Error Discuss

0 2509
Q:

Define and explain COM?

Answer

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 .

Report Error

View answer Workspace Report Error Discuss

0 2508
Q:

What do you think about the challenges faced by a Business Analyst ?

Answer

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. 

Report Error

View answer Workspace Report Error Discuss

0 2507
Q:

Difference between a query and a statement in SQL?

Answer

An SQL statement is a string of characters that conforms to the syntax and format specified in the international standard.


A query is a statement that returns a record-set.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2507
Q:

Can you work in shifts?

Answer

Say “Yes” if you have made up your mind to work for a call center. Call centers would usually work 24 X 7 which needs some executives to be always present in the center. This means that you would need to work in shifts. 

Report Error

View answer Workspace Report Error Discuss

Subject: Call Center

1 2507