Interview Questions

They are DEFINE CLUSTER, DATA and INDEX.

GROUP BY partitions the selected rows on the distinct values of the column on which you group by. HAVING selects GROUPs which match the criteria specified

In angular.js services are the singleton objects or functions that are used for carrying out specific tasks.
It holds some business logic and these function can be called as controllers, directive, filters and so on.

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. 

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.

Any code written in any .NET complaint languages when compiled, converts into MSIL (Microsoft Intermediate Language) code in form of an assembly through CLS, CTS. IL is the language that CLR can understand. On execution, this IL is converted into binary code by CLR’s just in time compiler (JIT) and these assemblies or DLL are loaded into the memory.

Open Market Operations (OMO) refer to the buying and selling of government securities in the open market in order to expand or contract the amount of money in the banking system.

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.