SQL JOIN allows access to records of other table based on the given conditions between two tables.

Ex: If we are provided with the department ID of each employee, then we can use the department ID of the employee table to merge with the department ID of the department table to access department names.

UNION operation allows addition of 2 similar data sets to create a resulting set that contains all the data from the source data sets.

Ex: If we are provided with 2 employee tables of the same structure, we can UNION them to create a singular result that will contain all employee from both the table.

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.

- A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index.

- A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

Inbound customer service agents handle incoming calls from customers for:

- Requests for help

- Inquiries or requests for information

- Placing orders, in product purchases

- Applications for services

- Filing complaints

Outbound customer service agents make calls to random potential customers to sell a service or product. These agents can also be called as telemarketing executives.

This question focuses to check your ability to handle situations. Do not answer this question with anything that states retaliation. Talk about handling the situation with patience and relaxed mind set. You can answer it as “ If the customer on the other side of the phone line is angry i will first try calming him and ask him his/her problem. After that I will try sufficing the best solution keeping in mind his problem. In this sector customer satisfaction is very important and thus it will be my primary goal.

KPO stands for Knowledge Process Outsourcing. It is a subset of call centers. The ways in which a KPO differs from a call center are :

1. In KPO knowledge and information related work is carried out.

2. Staff requirement is for highly skilled people.

3. Is mainly related to support and not sales.

4. Carries out works mainly for research and analysis process besides support.

Nationalized banks are also known as public sector banks where the government is responsible for the deposition of money in these banks while in a private bank money is deposited by the person who owns the bank.

A cheque is basically issued by an individual but a draft is issued by a bank. In a demand draft you have to pay before issuing while a check is withdrawn from the account.