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.

SELECT *FROM Employees WHERE EmpName like ‘M%’.

SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel') and SERVERPROPERTY ('edition').

This command is used when a large processing of data has occurred. If any large amount of deletions, any modifications, or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.

- 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.

When you work at a call center you will come across irritated, angry, and abusive customers, you can say you will do that following to handle them:

-  Listen to them and empathize with their situation

-  Apologize and take ownership of the problem and give a solution

-  Approach them and ask for a reason for their displeasure

-  If they insist on talking to your manager, get him on line ASAP

- Follow up after giving the solution and ask for feedback

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.

Answer this question around the following steps :

1. Greet customer.

2. Tell your name to the customer.

3. Ask customer how you can be of any assistance to him/her.

4. Listen carefully and patiently to the customers query or requirement.

5. Provide the customer with the best solution or assistance without making him/her wait for long.

6. Inquire if customer is satisfied with the assistance or help provided.

7. Ask the customer if he needs any further assistance.