Interview Questions

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.

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

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.

They are DEFINE CLUSTER, DATA and INDEX.

Validation controls are responsible to validate the data of an input control. Whenever you provide any input to an application, it performs the validation and displays an error message to user, in case the validation fails.

ASP.NET 4.0 contains the following six types of validation controls:

   => CompareValidator - Performs a comparison between the values contained in two controls.
   => CustomValidator - Writes your own method to perform extra validation.
   => RangeValidator- Checks value according to the range of value.
   => RegularExpressionValidator - Ensures that input is according to the specified pattern or not.
   =>  RequiredFieldValidator - Checks either a control is empty or not.
   => ValidationSummary - Displays a summary of all validation error in a central location.

I/O operations like reading or writing a file is not possible with client-side javascript. However , this can be done by coding a Java applet that reads files for the script. 

In a correlated query, the outer query is related to the inner query. This means one or more columns in the outer query are referenced. It’s used when the outer queries value is being used by inner query. For example, we need to find which employee had more perks in the current month than they did in the previous month. The correlated subquery is executed for each row of perks information in the parent query to first determine what the perks were for each employee in the previous month. This data, in turn, is compared to perks for each employee in the current month, and only those employees whose perks in the current month were greater that their previous month's perks are returned.