Interview Questions

A center equipped to handle a large volume of telephone calls. These calls could be the calls coming in from customers for service or support or these could be the calls that call center executives make to the customers for marketing

There are mainly two types of call centers :

a) Inbound call centers – Inbound call centers are those which receive support or service calls from customers usually on a toll free number. For e.g. when you call up a bank to check the status of your request for credit card, it is an inbound call.

b) Outbound call centers – Outbound call centers are those in which the call center executives make calls to the customers. These calls are usually made to generate the leads or sales. For e.g. when you receive a call from a bank offering you a personal loan, it is an outbound call. 

Service oriented architecture (SOA) is an architectural style that supports service oriented methodology that is being added in the cloud architecture as a mandatory component. Cloud architecture support the use of on-demand access to resources and it provides lots of other facilities that are being found in SOA as well. SOA makes these requirements optional to use. But, to get the full functionality and more performance based efficiency there is a requirement for the mixture of SOA and cloud architecture.

Variable costs are expenses that vary in proportion to the amount of goods or services that a business produces. 

Examples of variable cost include labor, packaging and raw materials.

Array is collection of same data type. Array size is fixed, It cannot be expanded.

But ArrayList is a growable collection of objects.ArrayList is a part of Collections Framework and can work with only objects.

SQL Server is having a fantastic feature to retrieve data persisted in the form of XML format. The data in the XML format can be retrieved using FOR XML clause appending to the SELECT statement.

It offers 3 modes.

- “FOR XML AUTO": Returns XML elements that are nested, based on which tables are listed in the "from" part of the query, and which fields are listed in the "select" part.

- "FOR XML RAW": Returns XML elements with the "row" prefix (ex: ""). Each column in a table is represented as an attribute and null column values aren't included.

- "FOR XML EXPLICIT": Explicit mode is the most complex shaping method used in SQL Server 2000. It allows users to query a data source in such a way that the names and values of the returned XML are specified before the query batch is executed. 

Web application provides services (Free and Paid) apart from information.

Ex: Online Banking System

It provides Bank  information , Branches & ATM information, Loans information etc...

And It provides balance enquiry, Fund transfer, Bill payments like services.

The persons whose primary investing objective is to preserve capital while generating a tax-free income stream, then municipal bonds are worth considering.

Municipal bonds (munis) are debt obligations issued by government entities. When you buy a municipal bond, you are loaning money to the issuer in exchange for a set number of interest payments over a predetermined period. At the end of that period, the bond reaches its maturity date, and the full amount of your original investment is returned to you.

Types of Municipal Bonds :

Municipal bonds come in the following two varieties:

1. General obligation bonds (GO)
2. Revenue bonds

General obligation bonds, issued to raise immediate capital to cover expenses, are supported by the taxing power of the issuer.

Revenue bonds, which are issued to fund infrastructure projects, are supported by the income generated by those projects.

Both types of bonds are tax exempt and particularly attractive to risk-averse investors due to the high likelihood that the issuers will repay their debts.

FIND_GROUP(function) FIND_COLUMN(function)